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

Dig deeper on Oracle DBA jobs, training and certification

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