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
Project Description: The work is about founding the best skilled person for the job. I will give you the job description. Skills required are Data Entry, Database Administrat

Consider the relations EMP(ENO,ENAME,AGE,BASIC_SALARY) WORK_IN(ENO,DNO) DEPT(DNO,DNAME,CITY) Express the following queries in SQL (i) Find names of employees who work in a dep

Question 1 Create a table student with attributes student name, roll number, total marks and percentage. Do the following operations Insert details in to the table Update

What functions does a data dictionary perform? In a (DBMS)data management system, the principal functions performed by the data dictionary are Management of data defini

a set of possible data value of an attribute is called??

Consider the relation schemas as follows. works (person name, company name, salary); lives (person name, street, city); located in(company name, city); managers (person name

Show a centralised schema to support the operation of the system you have chosen, including in particular: the product catalogue; the outlets and respective stocks; customer record

Use a Set operator to create a list of academics who have written or co-written less than 5 papers and also have greater than 3 interests. List their academic number in the output.

Creating views with check option : This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail: Examp