Computer Science Database work

ENTITY RELATIONSHIP DIAGRAMS

Entity Relationship Diagrams

Name

Institution

Date

( Driver_no (Primary key) Driver name Driver Bus Shift_no(primary key) Time_ofday SHIFT ) ( Bus_NO(primary key) Shift_no(foreign key) )

( Route_shift_Id Shift_no(foreign key) Route_no(Foreign key) Route_Shift ) ( Section_Id(Primary key) Section_name Route_no(foreighn key) ) ( Section ) ( Route_name Route_no (primary key) Length Routes )