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
Design an algorithm to implement operations  Each and every operation specified in the functional model could be formulated as an algorithm. The algorithm indicates how operat

#Use the following database schema: 1) Patient—PatientID, Name, DOB 2) Doctor—DoctorID, Name, MedLicenseNumber, Phone 3) Medication—MedicationID, BrandName, GenericName 4) Prescrip

What is an object design? Object design is a very interactive method, which decides the relationship among objects, classifies operations on classes, determines overall system

Automated system for appointment with sms and call confirmation with service providers and user has to be initiate automatically. After selecting time and date to use service, s

What are the two methods for dealing deadlock problem? The two procedures for dealing deadlock problem is deadlock detection and deadlock recovery.

Why is need for the multiple access paths?

A model in database system mostly defines the organisation of data or structure and a set of operations on that data. Relational model is a easy model in which database is represen

The following data are required to be stored by a family physician. Family#, FamilyAddress, Patient#, PatientName, ServiceCode, ServiceFee, ServiceDate A family can have seve

what do you mean by consistency in rdbms?

project on dbms