Question

1. Apply the Normalization rules to your database design. Describe in words how 1NF, 2NF and 3NF apply to your design/database schema.
2. Apply all the modifications that you made due to applying NF rules to your actual database in the DBMS (MS SQL Server).
3. Put your explanation for how 1NF, 2NF and 3NF apply to your database in a Word document OR PowerPoint presentation.

Any database for example is fine.

Answer 1

Normalization is the process in which the data is organized in a database in order to avoid data redundancy, insertion, update and deletion anomalies. Take example to below table-

course_num	course_nme	prof_name	prof_email	student_id	student_name	student_email
CSE101	SE	John Tan	[email protected]	S101 S102	Shadma Jack	[email protected] [email protected]
CSE102	DBMS	Glenn	[email protected]	S107	Shagil	[email protected]
CSE103	DBDA	Simon	[email protected]	S108	Eunica	[email protected]
CSE104	DAA	Satish	[email protected]	S108	Yaxin	[email protected]

1 NF: A table is said to be in first normal form it has the following properties:

1. It should contain only atomic values.

The student detail in the given COURSE table is not atomic, so it can be make atomic by putting each records in individual row.

The first normal form of the given table would be-

COURSE(course_num, course_nme, prof_name, prof_email, student_id, student_name, student_email)

2 NF: A table is said to be in its second normal form if:

1. It is in first normal form.
2. Should not have any partial dependency.

              The given COURSE table when converted to 2 NF, it gives 3 tables-

              COURSE(course_num, course_name)

              Professor(prof_id, prof_name, prof_email)

              Student(student_id, student_name, student_email)

              Enroll(enroll_id, course_num, student_id, prof_id, grade)

3 NF : A table is said to be in third normal form if:

1. It is in second normal form
2. It does not have any transitive dependency

Tables in 3 NF-

COURSE(course_num, course_name)

              Professor(prof_id, prof_name, prof_email)

              Student(student_id, student_name, student_email)

              Enroll(enroll_id, course_num, student_id, prof_id)

              Grade(enroll_id, grade)