Illustrate the fifth normal form, Database Management System

Fifth Normal Form (5NF)

These relations still have a difficulty. While defining the 4NF we mentioned that all the attributes depend upon each other. Whereas creating the two tables in the 4NF, although we have preserved the dependencies among Vendor Code and Item code in the first table and Vendor Code and Item code in the second table, we have lost the relationship among Item Code and Project No. If there were a primary key then this loss of dependency would not have happened..

 

Posted Date: 7/26/2013 6:39:34 AM | Location : United States







Related Discussions:- Illustrate the fifth normal form, Assignment Help, Ask Question on Illustrate the fifth normal form, Get Answer, Expert's Help, Illustrate the fifth normal form Discussions

Write discussion on Illustrate the fifth normal form
Your posts are moderated
Related Questions
QUESTION (a) Give two advantages of using Linked List as compared to arrays. (b) (i) You are working as programmer at the Orange Mauritius branch. You have been asked to cre

What is system log?  What are the entries?       Ans:  The system log that is generally written on stable storage contains the redundant data required to recover from volatile

how to design a bakery business in data base

Determine the rule that a value of a foreign key should appear as a value of some particular table is called a  Ans: Referential constraint.    The rule that a value of a fo

State the terms Designing the database and Normalization Designing the database: Out of the ERD we have formed, it is very easy to verify the tables, the attributes which the


in case of functional dependencies how we get the higher normal form.

Define physical and logical data independence. How does this architecture help in achieving these? Data independence entails that change in one view must not need a change in t


A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;