DBMS_UNIT3_Quiz

Composite or multi-valued attributes are converted into atomic attributes in the following Normal Form.

• 1 NF

• 2 NF

• 3 NF

• 4 NF

if a relation R contains more than one key, then each key can be called as

• prime key

• primary key

• candidate key

• super key

Let E and F are two set of functional dependencies. If every functional dependency in E is present in the close of F (F+). What it implies

• E covers F

• F covers E

• FD is covered by E

• F+ is covered by E

After normalization, if all functional dependencies are covered by the decomposed relations. This is called______

• Non additive join property

• independent preservation property

• dependency preservation property

• additive join propery

Addition of an attribute to the left and right side of a functional dependency results into another valid functional dependency is called as __________

• reflexive rule

• augmentation rule

• projective rule

• pseudotransitive rule

Consider a relation R(A, B, C, D, E, F, G, H) with the following set of function dependencies. FD = {A->BC, B->CF, CH->G, E->A, F->EG}. Find the number of keys the relation have.

• 3

• 4

• 5

• 6

Consider a relation R(A, B, C, D, E, F) with the following functional dependencies. FD = {A->BC, B->CF, CH->G, E->A, F->EG}. Find the normal form the relation R follows.

• Follows 1 NF, but not 2 NF

• Follows 2 NF, but not 3 NF

• Follows 3 NF, but not BCNF

• Follows BCNF but not 3 NF

Which of the following is true

• None

• All relations follows bother 3 NF and BCNF

• Every relation which is in 3 NF is also in BCNF

• Every relation which is in BCNF is also in 3 NF

Consider the attributes requirements for a student relation as shown in the figure. Find the statement which is false

• Registration_Num can be a primary key

• UID is candidate key

• BankAccount_Num is candidate key

• None

Consider the DB schema shown in the figure with suppliers, parts, and catalog relations.

According to the DB schema and assumptions, which of the following is true about the schema?

• The schema is in 3NF but not in BCNF

• The schema is in BCNF

• The schema is in 2NF but not in 3NF

• The schema is not in 2NF