Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

3. Contrast relational contexts in organizations

Answered: 1 week ago

Question

2. Describe ways in which organizational culture is communicated

Answered: 1 week ago

Question

1. Describe and compare approaches to managing an organization

Answered: 1 week ago