Examine the information and determine the entities

Assignment Help Database Management System

Reference no: EM133159378

Now lets consider designing a database for the a car lot. Consider the following statements ->
• Our car lot sells many cars every month (we have a big inventory)
• Our car lot has many customers (everyone loves us!)
• Our car lot has many sales persons (we are ready to help our customers)
• Each car sale persons sells many cars a week (our prices are great)
• Our car lot provides many mechanical services (all our mechanics are experts)
• Our Service department has many mechanics (any mechanic would love to work here)
• Our mechanics provide service to our customers (our repeat business is awesome)

Question 1. Examine the above information and determine the Entities.

Question 2. With each entity - determine some attributes for each entity. As a note - is there any information in the above statements that is not helpful for our database design?

Question 3. Now lets consider our Car Lot database design and determine the relationship of our Entities
Using LucidChart or similar tool (Visio) to construct an ERD based on the above scenario.

The approach to take to solve this problem would likely be accomplished using the following steps in your preferred ER diagraming tool

1. Read the statements and list out the Entities

2. Determine some attributes that each entity would have

3. Determine the Data Types for each of the Attributes

4. Determine and resolve the Relationship cardinality for the Entities. (Hint - there are multiple Many-to-Many relationships above. Please remember that creating an additional table to resolve is needed) You do not need to include the Data Types.

Reference no: EM133159378

Questions Cloud

Purchasing decision for health care products and supplies : How important is green in the overall purchasing decision for health care products and supplies? Defend your answer.

Explain the globalization-environmental sustainability : In your opinion, what is the role of the Human Resource Professional in promoting proper corporate addressment to the many issues concerning Globalization & Env

Organization structure and management process : What type of organization structure and management process did CPI appear to have and what type of structure would have been better suited to its changing envir

Should a business plan remain static or change over time : Should a business plan remain static or change over time? Should Human Resource Management remain consistent and static, or should it too change over time?

Examine the information and determine the entities : Examine the information and determine the Entities - determine the relationship of our Entities Using LucidChart or similar tool (Visio)

Training and professional development programs : Link your answer to how an organization should invest in people through training and professional development programs.

Analysis of the hiring process : analysis of the hiring process including regulatory requirements, sourcing applicants, the formal interview, the selection process, and onboarding

Assignment on guarantee goes awry : How to attract more customers from companies in the local business park was the topic of this month's meeting of departmental managers.

Difference between bfoq and business necessity defenses : BFOQ's and "business necessity" sometimes serve as exceptions to the rule that you cannot discriminate in employment decisions.

User Account

All Pages