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 Date-Time, Alighting Date-Time)
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 (1-to-1)
Passenger --(travels on)-- Trip (1-to-many)
Vehicle --(is used on)-- Scheduled Trip (1-to-many)
Driver --(drives)-- Vehicle (1-to-1)
Scheduled Trip --(includes)-- Trip (1-to-many)
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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!