Task
Overview of business case:
Daily Drive is a small start-up company that sells cars in Wagga. Daily Drive can get cars from several different suppliers. Daily Drive keeps its models in several showrooms across the city. At this stage customers cannot view the available models online so to order they must visit one of the showrooms. Daily Drive 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.
Note: The overview of business case is included here to provide context only. For the purpose of identifying entities, attributes and relationships between entities please read Daily Drive business rules and instructions for creating your ERD below.
Daily Drive business rules and instructions for creating your ERD:
1. Each supplier supplies one or more different types of cars. Each and every type of car is supplied by only one supplier. Every supplier is identified by a supplier code. The company name, street, city, state, postcode, phone number, and account number are kept in the system for every supplier. For each type of car, the type name (i.e. Sedan, SUV, ute, etc.) and market segment (i.e. small family, large family, etc.) are kept in the system.
Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule
2. Each type of car has one or more models. Each model is supplied as part of a type of car. For each model, the model name, engine capacity, seating capacity, year manufactured, and Daily Drive retail price must be kept in the system.
Add the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule to the same copy of the ERD that you created for business rule 1.
3. Each type of car is stored in a specific warehouse. Each warehouse stores only one type of car. Each warehouse is identified by a warehouse ID. For each warehouse address, postcode, phone number are kept in the system.
Add the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule to the same copy of the ERD that you created for business rule 1 and business rule 2.