(A) For the relation;

CarSales (RegNo, BuyerName, Address, SalesPerson, Make, Model, Commission)

The following functional dependences hold,

RegNo _ID à Make, Model

RegNoà Commission

RegNo, BuyerName à SalesPerson

BuyerName à Address

Make, Model à Commission

RegNo à SalesPerson

a. Use Inference rules to find the minimal basis and determine the Key of the relation

b. Based on this key, determine if the relation is in BCNF.

c. If it is not in BCNF then decompose the relation into BCNF.

3(B) The following relation holds details about cars ;

CAR_DETAILS(Registration_No , Make , Model , Tow_Load , Engine_Size, Colour )

And has the following functional dependencies;

Make , Model -> Engine_Size

Registration_No -> Make, Colour, Model

Engine_Size -> Tow_Load

The relation is decomposed into ;

CAR_DETAILS1(Registration_No , Colour, Make , Engine_Size* ,Model)

CAR_DETAILS2(Engine_Size, Tow_Load)

Prove that the decomposition is incomplete and complete the decomposition.

Posted Date: 3/19/2013 5:31:50 AM | Location : United States

Ask an Expert

Related Discussions:- Determine bcnf-dcnf and key relation, Assignment Help, Ask Question on Determine bcnf-dcnf and key relation, Get Answer, Expert's Help, Determine bcnf-dcnf and key relation Discussions

Write discussion on Determine bcnf-dcnf and key relation
Your posts are moderated

Write your message here..

Related Questions

What is the disadvantage of a call by reference, What is the disadvantage o... What is the disadvantage of a call by reference? During a call by reference damage or loss of data is not restricted to the subroutine, but will instantly lead to alters to th

Database, why are older data models are being replaced by new data models why are older data models are being replaced by new data models

Need web-based database, Our company hires independent contractors to insta... Our company hires independent contractors to install equipment at precise locations across North America. We want to track the installation data and generate reports. The compan

Explain in detail about collaboration diagrams, Explain in detail about Col... Explain in detail about Collaboration Diagrams Collaboration diagrams are interaction diagrams which emphasize structural organisation of an object that transmit and receive m

What is foreign key, What is foreign key? A relation schema r1 derived ... What is foreign key? A relation schema r1 derived from an ER schema may contain among its attributes the primary key of another relation schema r2.this attribute is known as a

Design and building a distributed information system, prototype of a distri... prototype of a distributed information system for a national car part retail outlet chain.

Dataware house(job scheduling strategy), Define a job scheduling strategy t... Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

Define deadlock term, a. Define the term "deadlock". There are four conditi... a. Define the term "deadlock". There are four conditions that must hold before deadlock is possible. Name them. b. Outline an algorithm that detects whether there is a deadlock.

Convert erd to rdm model, Regional Gardens has many nurseries, including Wa... Regional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively. Additi

What is the state machine engine, What is the State Machine Engine The... What is the State Machine Engine The straightest approach to implement control is to have any way of explicitly representing and executing state machines. With the help of thi