Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This case study concerns a Car Rental Company. The purpose of the database is to record which customers rent which cars. The company has
This case study concerns a Car Rental Company. The purpose of the database is to record which customers rent which cars. The company has a fleet of cars. Car details include the car registration, make (e.g. Ford, Nissan) and model (e.g. Mondeo, Micra). The company has many customers that can rent many cars. Customer details include their Address, telephone and driver's license number. Each customer rents a car for an agreed period of time that starts at the loan date and ends at the return date. A rental number uniquely identifies each car rental. Every time a car is returned from a rental, it is checked for damage by a service manager. Each service manager checks many cars. Before a car is rented by a customer, it is cleaned by a team of cleaner. Each cleaner cleans many cars. G11.1 Conceptual Model: Identify Entities and Relationships. Read the Case Study and identify the key entities and relationships. Draw a conceptual model of the database. You MUST include the cardinality and participation of each relationship. G11.2: Logical Model: Convert the conceptual model to a logical model by adding attributes and keys (primary keys and foreign keys) G11.3: Many to Many Decomposition: Decompose one Many to Many relationship.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started