How can I implement the normalization on a table?

Asked By nahida 0 points N/A Posted 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?

• Status: Open
• Question Views: 1075
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By limasler 15 points N/A #93751

How can I implement the normalization on a table?

 

Hi Nahida,

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.

·https://en.wikipedia.org/wiki/Database_normalization
· https://www.thoughtco.com/database-normalization-basics-1019735

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.

About limasler

Questions
2

Answers
50

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 09/11/2012
• Question Category: Oracle Database