Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

6. Identify seven types of hidden histories.

Answered: 1 week ago

Question

What is human nature?

Answered: 1 week ago