Im kind of new to database designs and could use some help.
This is just for learning.
This is what i want to ty and make
A "Used Cars" web shop (will no be making the web page, just the database)
Data must include
Cars: make (like Audi, Opel, Ford, etc.), model (like A6, Astra, Focus), color, fuel type, year, number of doors, mileage
Seller: name, address, phone, email
Review: Sellers can make reviews on car models
How can you help?
Since im just learning from books/internet, i would like to see how the tables for this databasw would look like so i know if im doing it correct.
So could any one help me out here?
Think of what the tables would be. If there is every two of the same thing (for example, car) then you know it needs to be a table. Then, continue reading. The table names are staring you straight in the face, as are the attributes.
For future reference, if you're wondering if it is correct, post work you have already done, then possibly someone can help you.