Question: based the UNF, perform the normalization process from 1NF to 3NF. Attributes: (UNF) student_name student_Id (PRIMARY KEY) student_faculty student_programName program_code student_phoneNumber student_cgpa semester_session course_code (PRIMARY

based the UNF, perform the normalization process from 1NF to 3NF.

Attributes: (UNF)

  • student_name

  • student_Id (PRIMARY KEY)

  • student_faculty

  • student_programName

  • program_code

  • student_phoneNumber

  • student_cgpa

  • semester_session

  • course_code (PRIMARY KEY)

  • course_subjectName

  • credit_hours

  • course_section

  • lect_Id (PRIMARY KEY)

  • lect_name

  • lect_course

  • head_program_id (PRIMARY KEY)

  • head_program_name

  • head_program_programName

  • head_program_approval

  • coordinator_id (PRIMARY KEY)

  • coordinator_name

  • coordinator_courses

  • coordinator_approval

  • coordinator categories

  • dean_id (PRIMARY KEY)

  • dean_name

  • dean_of_faculty

  • dean_approval

  • registration_status

  • registration_id (PRIMARY KEY)

  • registration_receivedDate

  • registration_processedDate

- registration_type

Constraints: cgpa (not more than 4.0 pointers)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!