Relational Database Management Systems_Unit2_IP

Relational Database Management Systems_Unit2_IP -...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Student_ID Grade Student_Name Instructor_Loc Instructor_Name Course_ID Major Course_Title Partial Dependency Partial Dependency Transitive Dependency 1NF (Student_ID, Course_ID , Student_Name, Major, Course_Title, Instructor_Name, Instructor_Loc, Grade) Partial Dependencies: (Student_ID Student_Name, Major) (Course_ID Course_Title, Instructor_Name, Intructor_Loc) Transitive Dependencies: (Instructor_Name Instructor_Loc)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Instructor_Name Instructor_Loc Grade Student_ID Course_ID Instructor_Loc Instructor_Name Course_ID Course_Title Student_ID
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Student_Name Major Table name: Student Student (Student_ID , Student_Name, Major) Table name: Course Course (Course_ID , Course_Title, Instructor_Name, Instructor_Loc) Table name: Instructor Instructor (Instructor_Name , Instructor_Loc) Table name: Grade Grade (Student_ID , Course_ID , Grade) Third Normal Form (3NF) conversion results Student Major Course Grade Instructor Student ID Student Name Course Title Course ID Instructor Name Instructor Loc N M N 1 Entity-Relationship diagram...
View Full Document

Page1 / 3

Relational Database Management Systems_Unit2_IP -...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online