1. TEST INSTRUCTIONS Create a new schema named as "Schema_100123456" (replace it with your student Id). Create a Physical Data Model (EER model) for the following case description (ABC City Transit). Forward Engineer your physical data model to create the schema on MySQL Server with the necessary tables in it. Insert at least three (3) records per table and make sure to match the Primary key and foreign key values during data insertion. 2. SUBMISSION INSTRUCTIONS: You are required to submit your test as a single MS Word document/pdf (use the provided template) that would contain the following items: An image/screenshot of the Physical Data Model (EER model) Images/screenshots of all tables populated with test data (at least 3 records per table) {Recommended and best strategy is to export your Image as PNG from Workbench, edit it using MS Paint and then import in MS Word) Example of a Table Data Image CustomerID 1 2 3 First Name Andy Max Sandy NULL Last Name Rana Chen Williams Address 123 any st 321 abc st 456 toronto 44 NULL NULL NULL ABC City Transit Management ABC City is a mid-sized Canadian city and has decided to offer public transit system for its citizens. You have been assigned to create a Transit management software system and first task is to create a database for it. The city has acquired a fleet of 150 buses and has defined Ten (10) Routes for passengers. The buses will run in three Eight hour shifts daily. Each route would consist of multiple stops (one stop as starting and ending stop each) and different number of buses would be assigned to a route daily. One driver will be assigned to a route for one shift daily (with maximum 5 shifts weekly). The Route supervisor will create a weekly schedule for Routes with bus and driver assignment. Sometimes buses need repairs and are temporarily taken out of the fleet. Route supervisors manage multiple routes. There are other type of employees of the transit system such as front office workers, manager, fare inspectors etc. Passengers can buy smart cards for bus fare payment and scan these cards while entering the bus. Passengers would also have the option of paying cash fares. Each smart card would have a unique identifier and passengers should be able to see their usage summaries by creating a free account on city's Transit website. Transit Managers should also be able to view multiple reports. Make and document educated assumptions about any missing information. 1. TEST INSTRUCTIONS Create a new schema named as "Schema_100123456" (replace it with your student Id). Create a Physical Data Model (EER model) for the following case description (ABC City Transit). Forward Engineer your physical data model to create the schema on MySQL Server with the necessary tables in it. Insert at least three (3) records per table and make sure to match the Primary key and foreign key values during data insertion. 2. SUBMISSION INSTRUCTIONS: You are required to submit your test as a single MS Word document/pdf (use the provided template) that would contain the following items: An image/screenshot of the Physical Data Model (EER model) Images/screenshots of all tables populated with test data (at least 3 records per table) {Recommended and best strategy is to export your Image as PNG from Workbench, edit it using MS Paint and then import in MS Word) Example of a Table Data Image CustomerID 1 2 3 First Name Andy Max Sandy NULL Last Name Rana Chen Williams Address 123 any st 321 abc st 456 toronto 44 NULL NULL NULL ABC City Transit Management ABC City is a mid-sized Canadian city and has decided to offer public transit system for its citizens. You have been assigned to create a Transit management software system and first task is to create a database for it. The city has acquired a fleet of 150 buses and has defined Ten (10) Routes for passengers. The buses will run in three Eight hour shifts daily. Each route would consist of multiple stops (one stop as starting and ending stop each) and different number of buses would be assigned to a route daily. One driver will be assigned to a route for one shift daily (with maximum 5 shifts weekly). The Route supervisor will create a weekly schedule for Routes with bus and driver assignment. Sometimes buses need repairs and are temporarily taken out of the fleet. Route supervisors manage multiple routes. There are other type of employees of the transit system such as front office workers, manager, fare inspectors etc. Passengers can buy smart cards for bus fare payment and scan these cards while entering the bus. Passengers would also have the option of paying cash fares. Each smart card would have a unique identifier and passengers should be able to see their usage summaries by creating a free account on city's Transit website. Transit Managers should also be able to view multiple reports. Make and document educated assumptions about any missing information