Normalization pattern implemented in a scenario

Asked By Frannie 0 points N/A Posted on - 11/07/2011

Can you please suggest a normalization pattern that can be implemented in a scenario where data have the same invoice number but different information like cost, supplier etc.?

• Status: Open
• Question Views: 729
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Internet

Best Answer by Harpe byers

Go To Solution

Answered By Mahesh Babu 20 points N/A #106493

Normalization pattern implemented in a scenario

Hallo Frannie,

In this case, since the invoice number remains the same on all occasions, you will then have to use as the primary key and then use it to reference the various tables that you will have together. But then each table will have a natural key, that will have some meaning, so as each row in the tables you have can be uniquely identified.

For more information on how to normalize your tables I will refer you to the following sites, they offer detailed information especially related to your case.

http://www.phlonx.com/resources/nf3/

http://pages.cs.wisc.edu/~dbbook/openAccess/thirdEdition/solutions/ans3ed-oddonly.pdf

__

Regards
Mahesh Babu

 

 

 

About Mahesh Babu

Questions
1

Answers
473

Best Answers
87

• Vote Up 0 Vote Down

• Posted on - 11/23/2011
• Question Category: Internet

Best Answer

Best Answer

Answered By Harpe byers 10 points N/A #106494

Normalization pattern implemented in a scenario

There is a primary key and concatenated primary key.

A primary key is a unique key that represents the whole row of a table/data. The concatenated primary key is two primary keys which are actually in different columns but for data normalization process they are considered one because no two rows have the same combination of these two primary keys.

Please follow this –

1. In your case, make your invoice number your primary key,

2. Choose another key as your second primary key which shall not have in any row any combination of same invoice number. e.g. take items invoiced. Now these two keys are not having any combination of these two primary keys in any row.

3. You shall arrange your table in a way it looks like normalization in attached picture.

4. You will see your results done as per the picture attached.

About Harpe byers

Questions
3

Answers
202

Best Answers
91

• Vote Up 0 Vote Down

• Posted on - 12/07/2012
• Question Category: Internet