In what normal form is the LOTS relation schema in Figure 15.12(a) with respect to the restrictive interpretations of normal form that take only the primary key into account? Would it be in the same normal form if the general definitions of normal form were used?

What will be an ideal response?


If we only take the primary key into account, the LOTS relation schema in Figure 14.11
(a) will be in 2NF since there are no partial dependencies on the primary key .
However, it is not in 3NF, since there are the following two transitive dependencies on
the primary key:
PROPERTY_ID# ->COUNTY_NAME ->TAX_RATE, and
PROPERTY_ID# ->AREA ->PRICE.
Now, if we take all keys into account and use the general definition of 2NF and 3NF, the
LOTS relation schema will only be in 1NF because there is a partial dependency
COUNTY_NAME ->TAX_RATE on the secondary key {COUNTY_NAME, LOT#}, which
violates 2NF.

Computer Science & Information Technology

You might also like to view...

An overloaded function is one

A) that calls other functions. B) that has the same name as another function. C) that has too many parameters. D) that attempts to do too much in a single function. E) that does different things depending on who calls it.

Computer Science & Information Technology

With ________ selected the database will be compacted and repaired each time it is closed

A) Compact Objects on Close B) Compact Application C) Compact on Close D) Compact & Repair

Computer Science & Information Technology

Ordered lists are numbered.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

It is difficult to change a picture on a slide.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology