Describe and illustrate the process of normalizing (step by step from 1NF till BCNF) the relation...

Transcribed Image Text:

Describe and illustrate the process of normalizing (step by step from 1NF till BCNF) the relation shown below to BCNF. Indicate the Primary Keys (PK) as well as the Foreign Keys (FK) for each new relations. FD 1: ABG FD 2: A CD FD 3: CD FD 4: BEF R = (A, B, C, D, E, F, G) PK: AB - Primary Key is A and B together Describe and illustrate the process of normalizing (step by step from 1NF till BCNF) the relation shown below to BCNF. Indicate the Primary Keys (PK) as well as the Foreign Keys (FK) for each new relations. FD 1: ABG FD 2: A CD FD 3: CD FD 4: BEF R = (A, B, C, D, E, F, G) PK: AB - Primary Key is A and B together