lecture-18-4nf

lecture-18-4nf - Fourth Normal Form T. M. Murali November...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Fourth Normal Form T. M. Murali November 8, 2010 T. M. Murali November 8, 2010 CS 4604: Fourth Normal Form Attribute Independence in BCNF Schemas Name Name DeptName Number Textbooks BookFor Courses Teach Professors T. M. Murali November 8, 2010 CS 4604: Fourth Normal Form Attribute Independence in BCNF Schemas Name Name DeptName Number Textbooks BookFor Courses Teach Professors I Relation is Courses(Number, DeptName, Textbook, Professor) . T. M. Murali November 8, 2010 CS 4604: Fourth Normal Form Attribute Independence in BCNF Schemas Name Name DeptName Number Textbooks BookFor Courses Teach Professors I Relation is Courses(Number, DeptName, Textbook, Professor) . I Allow more than professor to teach a course. Keep the same relation. T. M. Murali November 8, 2010 CS 4604: Fourth Normal Form Attribute Independence in BCNF Schemas Name Name DeptName Number Textbooks BookFor Courses Teach Professors I Relation is Courses(Number, DeptName, Textbook, Professor) . I Allow more than professor to teach a course. Keep the same relation. Is the relation in BCNF? T. M. Murali November 8, 2010 CS 4604: Fourth Normal Form Attribute Independence in BCNF Schemas Name Name DeptName Number Textbooks BookFor Courses Teach Professors I Relation is Courses(Number, DeptName, Textbook, Professor) . I Allow more than professor to teach a course. Keep the same relation. Is the relation in BCNF? No. T. M. Murali November 8, 2010 CS 4604: Fourth Normal Form Attribute Independence in BCNF Schemas Name Name DeptName Number Textbooks BookFor Courses Teach Professors I Relation is Courses(Number, DeptName, Textbook, Professor) . I Allow more than professor to teach a course. Keep the same relation. Is the relation in BCNF? No. I Allow more than one textbook for the same course. Keep the same relation. Each professor uses every textbook in the course. T. M. Murali November 8, 2010 CS 4604: Fourth Normal Form Attribute Independence in BCNF Schemas Name Name DeptName Number Textbooks BookFor Courses Teach Professors I Relation is Courses(Number, DeptName, Textbook, Professor) . I Allow more than professor to teach a course. Keep the same relation. Is the relation in BCNF? No. I Allow more than one textbook for the same course. Keep the same relation. Each professor uses every textbook in the course. Is the relation in BCNF? T. M. Murali November 8, 2010 CS 4604: Fourth Normal Form Attribute Independence in BCNF Schemas Name Name DeptName Number Textbooks BookFor Courses Teach Professors I Relation is Courses(Number, DeptName, Textbook, Professor) . I Allow more than professor to teach a course. Keep the same relation. Is the relation in BCNF? No. I Allow more than one textbook for the same course. Keep the same relation. Each professor uses every textbook in the course. Is the relation in BCNF? Yes!...
View Full Document

This note was uploaded on 12/24/2011 for the course CS 4604 taught by Professor Cmmalik during the Fall '08 term at Virginia Tech.

Page1 / 72

lecture-18-4nf - Fourth Normal Form T. M. Murali November...

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

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