CPT140 Database Concepts

Question 2
Figure 1: Entity relationship diagram
Question 3(A)
Considering
R (A, B, C, D, E, F, G)
D → G, B
E → A
B → G, E, C
A → F, C
1. By using inference rules to find the minimal basis the key of the relation is D
2. For the relation to be in BCNF the key which is D has to be in the left side for all the FDs which is
not the case thus the relation Is not in BCNF
(B)
Considering