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 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!