Question: Data modeling - the conceptual model and the logical model Prompt: Suppose the requirements for a rental car company have established two entity relationship diagrams,

Data modeling - the conceptual model and the logical model

Prompt: Suppose the requirements for a rental car company have established two entity relationship diagrams, shown below. These models are to be used to track and measure sales based on branch. Please review the two diagrams thoroughly before answering the questions that follow.

Data modeling - the conceptual model and the logical model Prompt: Suppose

the requirements for a rental car company have established two entity relationship

Using the given information , complete the following critical elements:

  1. Identify the type of each model (conceptual data model and the logical data model). Explain your selection.
  2. Identify the components of each model: the entities and attributes. Describe an entity and an attribute, and identify an example from each model.
  3. Describe the relationship between the entities in each model.
  4. Describe how these models benefit the organization, the rental car company. In the context of the scenario (involving a rental car company), why is the central entity the branch rather than the sales?
  5. How would these models be useful for the rental car business to build a database?

Inventory (vehicle) Employee Diagram One Branch Sales INVENTORY EMPLOYEE EMPLOYEE ID VEHICLE ID EMPLOYEE ID EMPLOYEE FIRST NAME EMPLOYEE LAST NAME EMPLOYEE BIRTHDATE BRANCH ID Diagram Two VEHICLE MAKE CODE VEHICLE MODEL CODE VEHICLE DESCRIPTION VEHICLE YEAR VEHICLE RENTAL PRICE BRANCH ID BRANCH BRANCH ID BRANCH DESCRIPTION REGION ID REGION NAME BRANCH SALES QUOTA REGION MANAGER SALES SALES ID SALES AMOUNT SALES COMMISSION PERCENTAGE VEHICLES RENTED COUNT EFFECTIVE DATE BRANCH ID

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!