Question: Based on the provided information, here's how you could proceed: Identify Elementary Facts: Passengers make trips using public transportation. Passengers pay for trips using a
Based on the provided information, here's how you could proceed:
Identify Elementary Facts:
Passengers make trips using public transportation.
Passengers pay for trips using a Go card.
Vehicles operate on daily routes.
Drivers drive vehicles on scheduled trips.
Trips have start and end times.
Passengers have Go card numbers.
Passengers provide personal information name address, contact number when purchasing Go cards.
Draw Fact Types:
Passenger Go Card Number, Name, Address, Contact Number
Vehicle Registration Number, Colour, Capacity, Model Year, Mode
Driver Driver ID Name, Contact Number, Address, Date of Birth, License Number, License Type
Scheduled Trip Schedule ID Route ID Driver ID Start Time, End Time
Trip Transaction ID Go Card Number, Cost, Schedule ID Operations Date, Pick Up Address, Drop Off Address, Boarding DateTime, Alighting DateTime
Identify Uniqueness Constraints:
Passenger: Go Card Number unique
Vehicle: Registration Number unique
Driver: Driver ID unique
Scheduled Trip: Schedule ID unique
Trip: Transaction ID unique
Identify Cardinality Constraints:
Passenger has Go Card Number to
Passenger travels on Trip tomany
Vehicle is used on Scheduled Trip tomany
Driver drives Vehicle to
Scheduled Trip includes Trip tomany
Draw Role Constraints:
Specify role constraints such as "Passenger travels on Trip", "Driver drives Vehicle", etc.
Review and Finalize:
Ensure all essential facts are captured.
Verify that constraints accurately represent the relationships.
Confirm that the ORM diagram reflects the domain accurately.
By following these steps, you'll develop a comprehensive ORM diagram that models the state's public transport system effectively. create a orm diagram
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
