Unit 6: Data Model Assignment
Introduction
Overview: In this assignment, you will look at two types of models used in data modeling—the conceptual model and the logical model. These are just two types of tools used in data architecture and data modeling that must be created before a database is built. These models are part of the steps required for developing a fully comprehensive system. Without these steps, it would be impossible to properly capture and document the business requirements needed in a system. Notice that you will have to describe the significance of these type of analysis and model drafting for your final project.
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.
Directions
Your Assignment: Using the given information and context from this course, complete the following critical elements:
- Identify the type of each model (conceptual data model and the logical data model). Explain your selection.
- Identify the components of each model: the entities and attributes. Describe an entity and an attribute, and identify an example from each model.
- Describe the relationship between the entities in each model.
- 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?
- How would these models be useful for the rental car business to build a database?
