QUESTION 2 - Database Design using Normalization (20 marks) Normalize the following unnormalized relation. Show all the functional and any multi volved dependences between the attributes indicate the primary keys, foreign keys and referential integrity constraints for each relation that should be in 4 NE Mole and state assumptions as necessary BUS(BusPlate No. Year Make, Driverse No. Name FName, RouteNo Houteflag. From To, Day Time Duration Busstop Map Problem. Date Reported A RouteNo is assigned to each operated route from a starting point (From to a finishing point (fol. The same RouteNo is used for the opposite route (RouteFlag. A or 8, 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 by different buses and several drivers during a certain day. During the route the bus makes several stops at different streets, mentioned in Busstop. 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: 1238 From: Dionysios Solomos Square Toksokratous Duration: 35 min, app 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. Time Day Weekdays 05:30 06:00 Saturday 06:25 07:00 Sunday 06:25