Overview of business case:
Drive-n-Drop is a transport company that provides bus services to the public in the Sydney metropolitan area. The company employs a number of bus drivers and owns a fleet of over 90 busses. Drive-n-Drop has been using an Excel spreadsheet to track their business activities; however, this has caused many redundancies and inefficiency.
With view to their expanding business and under the new management, they decided to investigate the option of implementing a database system. Accordingly. they hired you to design a relational database to better track and record their operational data.
Your task:
Create an ERD for each of the following statements that describe the current business rules for Drive-n-Drop. For each new statement being the business rule, extend the ERD to include the additional business rule in the ERD (created in previous point - for example; B will include A&B. C will include A. B & C, etc.)
Use Crows Foot notations and include all of the following in each part:
• All entities with Primary key and any foreign key attributes;
• The relationships between entities;
• The cardinality and optionality of each relationship;
• Any M:N relationships are be resolved to 1:M relationships