This preview shows pages 1–10. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full 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.
 Fall '08
 CMMALIK

Click to edit the document details