Question: Use the following table definitions to answer the question below. customer(custno, name, address, city, state, zip, phone, income) asset(assetno, assetdesc, assettype service(servno, servdesc, servrate) employee(empno,
Use the following table definitions to answer the question below. customer(custno, name, address, city, state, zip, phone, income) asset(assetno, assetdesc, assettype service(servno, servdesc, servrate) employee(empno, empname, emptitle) pricehistory(assetno, date, price) FOREIGN KEY assetno REFERENCES asset charge(chargeno, custno, servno, starttime, endtime, empno, billed, amtpaid) FOREIGN KEY custno REFERENCES customer FOREIGN KEY servno REFERENCES service FOREIGN KEY empno REFERENCES employee holding(custno, assetno, qty) FOREIGN KEY custno REFERENCES customer FOREIGN KEY assetno REFERENCES asset trade(tradeno, custno, assetno, qty, price, date, type, status) FOREIGN KEY custno REFERENCES customer FOREIGN KEY assetno REFERENCES asset
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
