Consider the following requirements of a car rental company: A member may rent more than one car and a car can be rented by more than one member in a given period. Cars are classified into categories (For example; economy, premium, SUV). A car is assigned to only one driver, but a driver can drive many cars. A car can only belong to one category, but a category can have one or more cars. Details of car rent must be recorded to reflect the rent duration and cost. 1. What are the possible entities in this business case? 2. Suggest 2 relationship names that might exist between the entities 3. List at least 2 attributes of each entity?
Consider the following requirements of a car rental company: A member may rent more than one car and a car can be rented by more than one member in a given period. Cars are classified into categories (For example; economy, premium, SUV). A car is assigned to only one driver, but a driver can drive many cars. A car can only belong to one category, but a category can have one or more cars. Details of car rent must be recorded to reflect the rent duration and cost. 1. What are the possible entities in this business case? 2. Suggest 2 relationship names that might exist between the entities 3. List at least 2 attributes of each entity?
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage