N/APosted on - 10/18/2011
I have the following table for my database.
I want to apply the normalization technique on the above table.
How can I apply the technique?
Please also inform me, how many ways I can apply the technique?
How can I implement the normalization on a table?
It seems to be an order table of your database. So Don’t add Customer ID , Customer Name and the City in a one table. Basically normalization removes the duplications of data in a database. It helps you to organize data in efficient way and avoid waste of server space. There are steps in normalization that called 1NF (First Normal Form) to 4NF form you can get clear idea about normalization by visiting following sites.
In your application there will be separate tables for Customer Detail, Product Detail, Order and the Order Details. Order table have the reference of Customer ID. Using that you can get the customer name and the city. So no need to add the Customer Address field into the order table. Unit price and the quantity should goes to order Detail table and set the reference Product ID in it.
Think this is helpful.