Higher normal forms, Database Management System

Higher Normal Forms Is there more normal forms beyond BCNF? Yes, though, these normal forms are not based on the concept of functional dependence. More normalisation is needed if the relation has Multi-valued, template dependencies or join dependencies. These topics are beyond the scope of this unit you can refer to more readings for further detail on these. MCS-043 has more discussion on these topics.

 

Posted Date: 3/7/2013 2:15:07 AM | Location : United States







Related Discussions:- Higher normal forms, Assignment Help, Ask Question on Higher normal forms, Get Answer, Expert's Help, Higher normal forms Discussions

Write discussion on Higher normal forms
Your posts are moderated
Related Questions
what are the reasons having variable length records

What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers

Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are

Define Partial Key and Primary Key A partial key, also known as discriminator, is the set of attributes which can uniquely identify weak entities that are related to similar o

What are the two types of errors? The two types of errors are: a) Logical error b) System error

Explain about primary key Primary Key: It is one of the candidate keys that are taken to be the recognizing key for the entire table. E.g. although there are two candidate ke

Describe a technique for direct search? Explain how data is stored within a file so which direct searching can be performed. For a file of unordered fixed length records by u

Suppose that in an organisation, an employee may do different roles in dissimilar projects. Say, RAM is doing coding in one project and doing designing in another. Suppose that the

What is foreign key? A relation schema r1 derived from an ER schema may contain among its attributes the primary key of another relation schema r2.this attribute is known as a

List the types of authorization. A) Read authorization B) Write authorization C) Update authorization D) Drop authorization