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

Explain about hexadecimal numbers system, Q. Explain about Hexadecimal Numb... Q. Explain about Hexadecimal Numbers system? Hexadecimal system has 16 digits that are represented as 0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F. A number (F2) H is equivalent to

Write short note on quantization, Write short note on Quantization. Qua... Write short note on Quantization. Quantization: This is the first step in PCM. The whole amplitude range of the modulating signal is divided in a number of standard levels term

Determine the nand gate, Find out the two inputs when the NAND gate output ... Find out the two inputs when the NAND gate output will be low. Ans. The output of NAND gate will be low if the two inputs are 11. The Truth Table of NAND gate is shown

Two methods of copying a information document, There are basically two meth... There are basically two methods of copying: Photocopying This is a modified development of photography. It is quite expensive and slow and is not often used for routine rep

Structure of input - output interface, Q. Structure of Input - Output Inter... Q. Structure of Input - Output Interface? Due to complexity and number of external devices that I/O interface control, there is not any standard structure of I/O interface. Let

Advantage and disadvantage of threaded binary trees, Advantage  1.     ... Advantage  1.       By doing threading we neglect the recursive method of traversing a Tree , which makes use of stack and consumes many memory and time . 2.       The node

Corresponding port numbers, A) Around how many entries are there in this fi... A) Around how many entries are there in this file on your VM? B) Select and list names and corresponding port numbers for four well-liked services listed in this file?

Explain processing of an interrupt, Q. Explain Processing of an Interrupt? ... Q. Explain Processing of an Interrupt? The interrupt is processed as: Step 1: Number field in INT instruction is multiplied by 4 to get its entry in interrupt vector table.

What are the necessary elements of an e-banking site, What are the necessar... What are the necessary elements of an e-banking site? E-banking systems rely upon a number of common elements or processes. The given list comprises many of the potential elem

#title.sequential circuit, design modulo 12 up synchronous counter using t ... design modulo 12 up synchronous counter using t flip flop