This case study concerns a Car Rental Company. The purpose of the database is to record...

 

Transcribed Image Text:

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. 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.