Question
Draw an ER Model using Visio for the following. Make sure the ER model is in 3rd Normal Form. (50 pts): Note: Include 2-3 attributes
Draw an ER Model using Visio for the following. Make sure the ER model is in 3rd Normal Form. (50 pts):
Note: Include 2-3 attributes (in addition to the PK and FK) for each of the entities in your normalized ER Model. Further, include at least one attribute (in addition to the two FKs/composite PK) for each bridge/junction table that you include in your ER Model.
A car dealership Luxuryforyou that buys and sells luxury cars needs to revamp its existing database. It hires a team of data modeling and analytic experts to revamp its current database. Luxuryforyou has car experts called Sales Agent1 that interact with individuals (called Sellers) who would like to sell their cars to Luxuryforyou. A seller can sell many cars while Sales Agent1 can be involved with multiple sellers. The make, model, miles, color, and any additional feature of a particular car that a seller is trying to sell needs to recorded. The SalesAgent1 must record their own name, phone number, date they first interacted with a potential seller. Also, the sale price of the car, which is a mutually agreed price between the seller and SalesAgent1 must be recorded, along with the date/time of sale. Before finalizing the sale (that is before Luxuryforyou approves the purchase of a car from a seller), the QualityCheck division at Luxuryforyou runs a background check on a car (for title, accident records etc). The Quality Check department can check multiple cars (that sellers are trying to sell), while it only does background check once for a car that a seller is trying to sell. Luxuryforyou has car experts called Sales Agent2 that that interact with individuals (called buyers) who would like to buy cars from Luxuryforyou. A buyer may buy many cars while Sales Agent2 can be involved with multiple buyers. The make, model, miles, color, and any additional feature of a particular car that a buyer is buying needs to recorded. The SalesAgent2 must record their name, phone number, date they first interacted with a potential buyer. Also, the sold price of the car, which is a mutually agreed price between the buyer and SalesAgent2 must be recorded, along with the date/time of sale. Further, before driving a car out of the dealership, a buyer must get the car inspected. To track sales agent performance, Luxuryforyou has managers that manage both Sales Agent1 and Sales Agent2. Sales Agent1 can be managed by one manager, while a manager can manage multiple Sales Agent1. The relationship between the Sales Agent2 and the manager is similar to that of Sales Agent1 with manager.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started