Question: Normalize the following unnormalized relation Show all the functional and any multi-volued dependencies between the attributes Indicate the primary keys foreign keys, and referential integrity

Normalize the following unnormalized relation Show all the functional and any multi-volued dependencies between the attributes Indicate the primary keys foreign keys, and referential integrity constraints for each relation that should be in 4 N.F. Make and state assumptions as necessary BUS(BusPloteNo, Year, Make, DriverLicenseNo, LName, FName, RouteNo, RouteFlog, From, To, Day, Time Duration, Bus Stop, Map, Problem Date Reported A Route No is assigned to each operated route from a starting point (from) to a finishing point (To). The same RouteNo is used for the opposite route (RouteFleg. A or B. is used to differentiate the two). Buses and drivers are assigned to bus routes scheduled at specific times during a day. Overall, one route may be operated different buses and several drivers during a certain day. During the route the bus makes several stops at different streets mentioned in Bus Stop. Sometimes problems concerning specific routes are reported by passengers and these are recorded in the database Some sample data are shown below. Bus Schedule RouteNo 123 B From: Dionysios Solomos Square To: Isokratous Duration: 35 min. appr. Day Time Weekdays 06:05 06:35 Saturday 07:05 07:35 Sunday 07:05 Bus Schedule RouteNo: 123 A From: Isokratous To: Dionysios Solomos Square Duration: 35 min. appr. Day Weekdays 05:30 06:00 Saturday 06:25 07:00 Sunday 06:25
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
