... R
A
al
al
al
a2
a2
C
cl
c2
c2
c3
c3
E
el
el
el
el
el
B
bl
bl
b2
b2
b2
D
dl
dl
d2
d2
d3
I. Determine the functional dependency of R.
2. Minimize the obtained functional dependency of R and Draw its graph.
3. Define the primary key (s) of R.
b) Given the relation
Video (Customer-No, Customer-name, Customer-last-name, Customer-address, Cassette-No,
Cassette-Purchase-price, Editor-name, Editor-address, Film-No, Film-title, Film-duration, Editor-No
Film-nationality, Film-producer, First-'year_appearance, Type, Cassette-rent-date, Cassette-rent-duration)
and the set of functional dependencies:
F = {Cassette-No - film-No, Cassette-Purchase-price
Film-No- film-title, Editor-No, Film-duration, Film-nationality, film-producer,
First-'year_appearance, Type
Cassette-No, cassette-rent-date - Customer-No, cassette-rent-duration
Customer-No - Customer-name, Customer-last-name, Customer-address}
1. Explainwhythe relationabove is not in2FN?
2. Decompose the relation Video in order to obtain a relational schema in 2FN (only in 2FN).
3. Are the obtained relations in 3FN? Ifnot, modify the schema in order to obtain a
result in 3 FN.
4. Are the obtained relations in FNBC? justify your answer