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/23/2017 5:05:13 PM | Location : USA

Ask an Expert

Related Discussions:- dbms, Assignment Help, Ask Question on dbms, Get Answer, Expert's Help, dbms Discussions

Write discussion on dbms
Your posts are moderated

Write your message here..

Related Questions

What is concurrent control, What is concurrent control? Control resides... What is concurrent control? Control resides concurrently in various independent objects, every a separate task. A task can wait for input but other task continues implementatio

Define polling, Define Polling. A Polling process is used to recognize... Define Polling. A Polling process is used to recognize the highest priority source by software means. In this process there is one common branch address for all interrupts.

Where the grade of service is measured, The grade of service is measured in... The grade of service is measured in (A) Percentage                                  (B)  Number (C)  Fractional Number                    (D)  Logarithmic Number  Ans

Analytical engine by babbage, Charles Babbage 'The grandfather of modern co... Charles Babbage 'The grandfather of modern computer' had designed two computers: The Difference Engine: It was based on mathematical principle of finite differences and was us

Hazards of pipeline - computer architecture, Hazards of pipeline - computer... Hazards of pipeline - computer architecture: Hazards : When a programmer (or compiler) writes assembly program code, they make the supposition that each instruction is execut

We define our own match code id''s for sap matchcodes, Can we define our ow... Can we define our own Match Code ID's for SAP Matchcodes? Yes, the number 0 to 9 are reserved for us to make our own Match Code Ids for a SAP described Matchcode object.

Define swapping, Define swapping.  A process needs to be in memory to b... Define swapping.  A process needs to be in memory to be implemented. Though a process can be swapped temporarily out of memory to a backing store and then brought back into mem

Spmd model for programming, Q. SPMD model for programming? A normal ass... Q. SPMD model for programming? A normal assumption was that it must be possible and not too hard to capture the SPMD model for programming MIMD computers in data parallel langu

Explain system software with system programming, Explain the evolution of s... Explain the evolution of system software with system programming. System-software is collection of system programs which perform a variety of functions, name are: file editing,

Illustrate about the single inheritance, Illustrate about the single inheri... Illustrate about the single inheritance During inheritance, superclass feature may by override by a subclass defining that feature with the same name. The overriding features (