Question: Database Design Assignment This assignment contains two questions. 1. Draw and ER diagram that reflects the following elicited data requirements. The ER diagram must be

 Database Design Assignment This assignment contains two questions. 1. Draw and

Database Design Assignment This assignment contains two questions. 1. Draw and ER diagram that reflects the following elicited data requirements. The ER diagram must be drawn using word and abiding to the ER notation presented in the lectures\book. In this question you are asked to only create a diagram. You are not asked to convert to tables You are asked to create a database for a busing company. You need to keep track of the differ- ent buses, each having a plate number, make year, and number of seats. You also need to keep track of drivers that work in the company. The information kept on each driver should include. the license number, age, and name. Drivers cannot drive any bus, but rather each driver is as- signed with specific buses in the fleet he/she is allowed to drive (different drivers are permitted to drive different buses). Accordingly, a driver may be allowed drive many different buses, and a bus can be driven by many different drivers. 2. Convert the ER diagram that is found in the next page to a logical relational data model. Submit on Brightspace the relational model you arrived at (.e. the list of tables, their primary and for- eign keys)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!