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
Explain five duties of Database Administrator? 1. DBA administers the three stages of the database and, in consultation along with the whole user community, sets up an defin

How many levels can be viewed in Architecture of the database ? Architecture of the database can be viewed as three levels.

1. Determine that the Checkpoints are a part of  Ans: Checkpoints are a part of Recovery measures

Why do so various organizations use MySQL? Advantages: Open source Highly efficient Offers a high scalability in terms of size and connectivity. Highly prote

a) Distinguish between ‘database' and ‘Database Management Systems (DBMS)'. b) List and briefly describe five potential benefits of the database approach compared to conventio

Define Network DBMS The NDBMS is built primarily on a one-to-many relationship, but where a parent-child representation between the data items cannot be ensured. This may occur

Which types of data supported by MySQL for Time and Date formats?  MySQL supports a number of time and date column formats: Some of them are 1) DATE 2) DATETIME 3) TIM

How to use Oracle

What do you understand by transitive dependencies? Define with an example any two problems that can take place in the database if transitive dependencies are available in the datab

After the completion of the logical model the physical model is to be made. The oracle 10 G will be used as a database server and all the tables with their column are created and i