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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started