Objective: this assignment is designed to let you have a hands-on experience wit

Question

Objective: this assignment is designed to let you have a hands-on experience with normalization. A normalized schema provides a good starting point for further development of a database application and easier maintenance it later on. Normalization is a process of modifying an existing database schema to bring its component tables into compliance with a series of normal forms. The goal of the normalization is to ensure that every non-key attribute in every table is directly dependent on the whole candidate key (nothing else but the key).

Consider a relation R with six attributes A, B, C, D, E, F. You are given the following dependences:

Cà F, E

BCà D,

D à B, and

ED à C.

Is{(ABDE)} a candidate key of this relation? If not, is {(ADE)}? Justify your answer.

Consider the relation F with six attributes F,R,I,D,A,Y with the following dependences:

   R à I,

RY àF,

FY à A, and

FA àR.

List all keys for F and justify your answer.

Identify prime and non-prime attributes and justify your answer.

Classify each functional dependency and justify your answer.

Determine normal form for the relation F and justify your answer.

Explanation / Answer

1. ABDE is not a candidate key because this key does not derive all attributes

ABD is also not a candidate key beacuse it does not derive all other attributes

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

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