Question: please draw E-R model / CDM / LDM SellYourCar.com is a website to sell and buy cars. The website administrator has to make a database
please draw E-R model / CDM / LDM
SellYourCar.com is a website to sell and buy cars. The website administrator has to make a database where he can store all important information about cars in sale. Your task is to help him designing a CDM / E-R model for his database. Make sure it is 3NF. In what follows, information about what to put in this database:
Customers, who want to buy or sell cars, should enter to the website using a login and a password. The login has to be unique. The website also maintains the names, address, and telephone numbers of all the customers.
Each customer can publish one or many advertisements. You should store the date of publication and the date of expiration of each advertisement. An advertisement is about one car. An advertisement has one type. Types are: "long-term" (advertisement will last 3 months), "short-term" (advertisement will last 1 week).
The cost of the advertisement depends on the type advertisement ("long-term" advertisements are more expensive than "short-term") and on the customer (good customers pay less than new customers).
Each car has an identifier, year, model, color, and price.
You should store in the DB the options of each car. Options include: Sun roof, GPS, leather seat...
When a car is sold, DB should indicate that the car was sold and the customer who bought the car.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
