Hi any one help for me am going to design database for my project, The project related to used cars selling i:e The seller needs to register with my site and upload their car photos and giving car details etc.. Any one can u suggest me how to design the database, what necessary steps i need to take before going to that database design.This is first time am going to design pls help for me.
You need to go through the process of collecting the business methods and then use those to define the information that will be stored. You should collect this information in just raw notes. Then you convert that into what is called a logical model, that lays out the information in a semi-normalized structure, or, in an object structure. You can then take that back to the business, reiterate their methods to them, using your structure. If they agree that you both accurately understand their methods and that your model reflects what they want stored you can then go to the database to create a fully normalized structure. Just remember that you need to keep track of what column or columns make up identifying characters to the business (don't get caught thinking that an identity column is identifying, it's unique and automatic, totally different from identifying). Those will require unique constraints (if you don't use a natural primary key, which most people don't). And remember, normalization is actually both a storage mechanism and a performance mechanism, so it is a necessary step when defining storage within a relational engine such as SQL Server. That's it in a nutshell. Have fun!