Question: Please give a write up for a theoretical database. Must include a mini world scenario, entities, attributes, and relationships. An example for this would be

Please give a write up for a theoretical database.

Must include a mini world scenario, entities, attributes, and relationships.

An example for this would be a bus system. Entities would include employees (attributes: employee number, name, email, phone number, DOB, title), Bus station (attributes: station number, name, address), buses (attributes: bus number, number of seats), routes (attributes: trip id, distance, time), schedule (attributes: route id, bus id), passenger (attributes: id, password, email, phone number, name, DOB). Must also include relationships, for example:

schedule--bus

schedule--route

route--station

schedule--station

bus--passengers

bus--employees

route--station

Also give a diagram showing relationships

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 Databases Questions!