I'm required to create an ERD, Relational Model, and a SQL Database/Schema for shopping used cars in Egypt, that allows users to get information about the used cars available for sale in Cairo, the different makes, models, sellers and locations.
P.S. Please don't copy and paste old answer
The database system you design should be based on the information provided on each used car, its listing owner and the other information provided on the ad page (e.g. sample) Your database design should store all the information about the car, including but not limited to: description, make, model, year, odometer range, price, features, body type, fuel type, location, payment method (cash / installment), etc. Each of the ads on the site is listed by an owner / agent, for each of them you need to store their name, and the date for which they joined OLX. Many times the owners list their phone numbers in the description, you will get bonus points if you are able to extract the phone numbers and store it with the owner information. The system should also allow users to register on your system using their email addresses, and pick a username, gender, age, birthdate, and a list of the car make and models they are interested in. After registering, the users can mark a purchase they did on the website for a listed car, providing the purchase price, the ad the sale was in reference to, and a textual review and a numeric rating for the process (1-5) Description: In this milestone, you are required to design the database ERD, create your database and schema in MySQL server for the data requirements presented on the previous slides. Deliverables: (20 points) - Entity-Relationship Diagram of your system - Relational Model for your system - A transcript for the SQL statements used to create your database and schema The database system you design should be based on the information provided on each used car, its listing owner and the other information provided on the ad page (e.g. sample) Your database design should store all the information about the car, including but not limited to: description, make, model, year, odometer range, price, features, body type, fuel type, location, payment method (cash / installment), etc. Each of the ads on the site is listed by an owner / agent, for each of them you need to store their name, and the date for which they joined OLX. Many times the owners list their phone numbers in the description, you will get bonus points if you are able to extract the phone numbers and store it with the owner information. The system should also allow users to register on your system using their email addresses, and pick a username, gender, age, birthdate, and a list of the car make and models they are interested in. After registering, the users can mark a purchase they did on the website for a listed car, providing the purchase price, the ad the sale was in reference to, and a textual review and a numeric rating for the process (1-5) Description: In this milestone, you are required to design the database ERD, create your database and schema in MySQL server for the data requirements presented on the previous slides. Deliverables: (20 points) - Entity-Relationship Diagram of your system - Relational Model for your system - A transcript for the SQL statements used to create your database and schema
