logo

RUNNING HEAD: DATABASE 4 DATABASE Student's Name: Drive2Impress Course Description

   

Added on  2020-03-16

4 Pages463 Words406 Views
RUNNING HEAD: DATABASE1DATABASEStudent’s Name: Course title: Date of submission:

RUNNING HEAD: DATABASE2Drive2Impress business rules andinstructions for creating your ERD:1.Eachsuppliersupplies one or more different types of cars. Each car type issupplied by only one supplier. Everysupplier is identified by asupplier code. The company name, street, city, state, postcode, phone number, and account number are also kept in the system for every supplier. For car type, the type name (i.e. Sedan, SUV, ute,etc.) andmarket 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 car type has one or more models.Each model issupplied as part of a car type. For each model, the model name, engine capacity, seatingcapacity,year manufactured,andDrive2Impress retail pricemust 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 ERD that you created for business rule 1.3. Each car type is kept in more than one showroom. Each showroom keepsone or more car types. Each showroom is identified by a showroom ID. For each showroom address, postcode, phone number are kept in the system.

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Entity Relationship Diagram (ERD) : Assignment
|5
|469
|411

Introduction to Database Systems
|10
|1030
|259

Database Systems Assessment 2: Modelling - ITC556
|6
|485
|426

Database Systems - Assignment
|10
|881
|187

Database Design
|30
|2273
|61

Database Systems Assessment 2: Modeling - ITC556
|8
|587
|266