answersLogoWhite

0

Example: The following relation is in First Normal Form, but not Second Normal Form:

Order #CustomerContact PersonTotal1Acme WidgetsJohn Doe$134.232ABC CorporationFred Flintstone$521.243Acme WidgetsJohn Doe$1042.424Acme WidgetsJohn Doe$928.53

In the table above, the order number serves as the primary key. Notice that the customer and total amount are dependent upon the order number -- this data is specific to each order. However, the contact person is dependent upon the customer. An alternative way to accomplish this would be to create two tables:

CustomerContact PersonAcme WidgetsJohn DoeABC CorporationFred Flintstone

Order #CustomerTotal1Acme Widgets$134.232ABC Corporation$521.243Acme Widgets$1042.424Acme Widgets$928.53

The creation of two separate tables eliminates the dependency problem experienced in the previous case. In the first table, contact person is dependent upon the primary key -- customer name. The second table only includes the information unique to each order. Someone interested in the contact person for each order could obtain this information by performing a JOIN operation.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

Is a swing an an example of a simple machine?

Yes, the simple machine is a lever if you look at the top of a normal playground swing.


Why is the prisoners dilemma popular?

Because it is a very simple example to explain both games theory and rational choice theory. It's simple to explain and really, really easy to understand.


Did and do where you use?

'Do' is used in the simple present tense when using first person, second person, or third person plural. For example: I do, you do and they do. 'Did' is used as the simple past tense of 'do'. For example: I did, you did and they did.


Where do you use and and?

'Do' is used in the simple present tense when using first person, second person, or third person plural. For example: I do, you do and they do. 'Did' is used as the simple past tense of 'do'. For example: I did, you did and they did.


What is simple past tense of the word explain?

The simple past tense of the word "explain" is "explained."


How do you find a percent for a normal number?

for example: 34% you move the decimal TWO times to the right: .34 volia! simple.


Explain why models are often used to study other planets.?

We use models to explain how life and such is. my example is the sun model. How would you know the orbit of the sun without that model? Now i know its a pretty simple reply but this is a simple question also. just think about it for a while


What is a word that starts with a l and end with a t and second letter is a vowel?

There are many words that meet the criteria. One simple example is let.


Explain the importance of each of the four steps in a simple decision-making model?

explain the importance of each of the four steps in a simple decision-making models?


I'm looking for a simple chart to show normal blood glucose levels...?

Simple chart for normal blood glucose levels...


What are example of an organic form of carbon?

Glucose is a simple example.


Explain why models are used in the study of nuclear physics?

to explain the complex features of simple phenomena