The Oracle Guru Question #2

Are you an Oracle guru? Try your hand at this week's quiz on a component of database table design.

QUESTION OF THE WEEK:

At this level of normalization, each column in a table that is not a determiner of the contents of another column must itself be a function of the other columns in the table. For example, in a table with three columns containing customer ID, product sold and price of the product when sold, the price would be a function of the customer ID (entitled to a discount) and the specific product.

a. 1NF
b. 2NF
c. 3NF
d. DKNF

See ANSWER

This was first published in July 2003
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close