Find a 3nf decomposition , Database Management System

Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following set of functional dependencies:

{Faculty → Dean, Dean Faculty, Department Chair, Professor Rank Chair, Department Faculty, Student DepartmentFacultyDean,

ProfessorRank DepartmentFaculty}

Is the decomposition non-loss and dependency preserving?


Posted Date: 4/6/2013 3:07:19 AM | Location : United States

Related Discussions:- Find a 3nf decomposition , Assignment Help, Ask Question on Find a 3nf decomposition , Get Answer, Expert's Help, Find a 3nf decomposition Discussions

Write discussion on Find a 3nf decomposition
Your posts are moderated
Related Questions
Insulation between conceptual and physical structures It can be defined as: 1. The Database Administrator should be capable to vary the storage structures without affectin

What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the whole database. A differential backup creates a copy of

What is Natural Language Interfaces? Natural Language Interfaces - These interfaces accept requests written within English or a few other language and attempt to "understand" t

The primary key is selected from the

What is trigger Triggers are statements that are implemented automatically by the system as the side effect of a change to the database.

Use again the GE Flight Quest Data and build on the work done for homework 1 and 2. The goal is to create a classification model which classifies flights into "on-time" (you can de

Define a view and a trigger. Construct a view for the above relations that have the information about suppliers and the elements they supply. The view holds the S#, SNAME, P# , PNA

Describe the algorithm for updating indices for a single level index when a record is    (i) Inserted  (ii)  deleted What will be the modification if there are multilevel in

How persistent programming languages differ from traditional programming languages? Database languages vary from traditional programming languages in that they directly manipul

Which language has presently become the defacto standard for interfacing application programs along with relational database system? The language which has recently become the