Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the attributes that a building contractor has identified for her business, the following relation was defined. Building ( sitenum , address, contractprice, compl -
Using the attributes that a building contractor has identified for her business, the following relation was defined. Building sitenum address, contractprice, compldate, itemno, itemname, qty price, subcontractor, jobname, subprice, owner, ownertele The functional dependencies that relate to the attributes are: Sitenum address, contractprice, compldate, owner Itemno itemname Sitenum, itemno qty price, itemname Sitenum, subcontractor subprice, address Subcontractor jobname Owner ownertele In answering the following questions, please make no assumptions other than those provided by the functional dependencies.
Using the attributes that a building contractor has identified for her business, the following relation was defined.
Building sitenum address, contractprice, compldate, itemno, itemname, qty price, subcontractor, jobname, subprice, owner, ownertele
The functional dependencies that relate to the attributes are:
Sitenum address, contractprice, compldate, owner
Itemno itemname
Sitenum, itemno qty price, itemname
Sitenum, subcontractor subprice, address
Subcontractor jobname
Owner ownertele
In answering the following questions, please make no assumptions other than those provided by the functional dependencies.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started