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
What is key ? Key - A single attribute or a combination of two or more attributes of an entity set which is used to recognize one or more instances (rows) of the set (table) is

Draw an E_R Model for the following: An organization uses number of items of a equipment to generates goods. Each item is at one LOCATION, of one TYPE and has a DETAILED_DISCRI

Can you scan double-sided documents - and remove blank pages? Our software and imaging systems supports duplex scanning, at the same time scanning both sides of a page. Program

Differance between internal and external schema? Internal and external schema: Internal Schema • Describes the physical storage structure • Uses a physical data model External

Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided t

What is Asterisk in SQL? Asterisk (*): In SQL, the columns for all the tables and views in the FROM clause will be displayed.

Explain pipelining.        Ans: In order to describe pipelining in simple terms, think of it as breaking down processor functions into smaller and smaller parts. For instance,

Define the Traditional System Analysis and Design Traditional System Analysis and Design (SAD) have three basic life cycle models. A typical software lifecycle consists of the


What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data