ER Modelling
Case - London Oyster Card (simplified)
Objective
Record information:
User information: name, address Oyster card information: card id, create date, card type, balance Trips: travel from, touch in date and time, travel to, touch out date and time, fare Dummy data 3rd Normal Form is used below to normalise the data. It is a 3 steps process, each step depends on the completion of the previous step and progressively transforming the data.
1st Normal Form: Atomicity
Posted by Sha Cheng on Wednesday, April 7, 2021