Question

Develop a NORMALIZED 3NF map for the following data.

COLLEGE ld Address City Degree Description Required Elective Course Course Credits Credits 20 40 37 35 CGCC Pecos Rd Chandler AAS-DBA Database Administration Elem Education Aviation Maintenance LPN Fine Arts Database Administration AAS-Ed 23 AAS-AV 25 MCC Southern Ave Mesa AAS-Nursin AAS-ART AAS-DBA 34 40 40 ram 26 20 20

Answer 1

Condition needs to satisfy 3NF:

1. Contains only atomic values(1 NF)

2. All the non key attributes are functionally dependant on primary key.(2NF)

3. No transitive functional dependancy (3NF)

Consider the given relation

College(Id, Address,City, Degree, Description, Required course credit, Elective course credit)

1. In this relation, Degree, Description, Required course credit, Elective course credit) has no atomic value, its a group of values collected. So the relation doesn't satisfy the 1NF.

To proceed further the table got split further.

College(Id, Address, City) --Primary key(Id)

College_degree(Degree, description, Required course credit, elective course credit) -- Primary Key(Degree)

Now it satisfies 1NF.

2. Only one primary key in the both the table and already satisfies 1NF - 2NF satisfied

3. There is no transitive dependancies among the attributes in the above relation. Hence it satisfies the 3NF.

so the final 3NF for the given table is.

College(Id, Address, City)

College_degree(Degree, description, Required course credit, elective course credit)