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
Get step-by-step solutions from verified subject matter experts
