Objective: this assignment is designed to let you have a hands-on experience wit
ID: 3710564 • Letter: O
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). e kevormsation iExplanation / Answer
a.
Candidate Key - FD
Super Keys - FDR, FDA, FDY, FDI
b.
Since candidate key is FD,
Prime Attributes are F and D
Non Prime Attributes are R, I, A and Y
c.
R->I is a Fully Functional Dependency because removal of R means the dependency is no more.
RY -> F is a Fully Functional Dependency because removal of R or Y means the dependency is no more.
FD -> Y is a Single Valued Functional Dependency since FD is the candidate key(primary key) and Y is a single attribute of the relation
FY -> A is a Fully Functional Dependency because removal of F or Y means the dependency is no more.
FA -> R is a Fully Functional Dependency because removal of F or A means the dependency is no more.
d.
The normal form of the relation F is 2NF
it is not in BCNF because for every alpha -> beta, alpha should be a super key/candidate key
This is not satisfied by the first dependency R->I
It is not in 3NF . For every alpha -> beta , alpha should be super key or beta should be prime attribute
This is not satisfied by the first dependency R->I
It is in 2NF. There is no partial dependency. ie. alpha -> beta such that beta is non-prime and alpha is part of candidate key. No such partial dependency exists hence it is in 2NF.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.