1. The lowest normal form that the relational model supports is a. the first nor

Question

1. The lowest normal form that the relational model supports is

a.   the first normal form.

b.   the second normal form.

c.   the third normal form.

d.   the Boyce-Codd normal form (BCNF).

2. ____________ is an index specified on the ordering key field of an ordered file of records.

a. Secondary index

b.   Primary index

c.   Clustering index

d.   Multi-level index

3, The higher normalized relational database schema implies

a less insertion anomalies

b. less deletion anomalies

c.   less modification anomalies

d.   all of a., b., and c.

Explanation / Answer

1. (a)The lowest normal form that the relational model supports is First Normal Form(1NF).

2. (b) A primary key is specified on the ordering key field where each tuple has a unique value.

3. (d) The higher normalized relational database schema implies :

less insertion anamolies,less deletion anamolies and less modification anamolies

An anamoly occurs in a database if all of a sudden the database state becomes inconsistent. This can be further specified as insertion,deletion and update anamoly depending on where the action is to be taken on the error whether it is a row update, insertion or deletion accordingly.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.