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 holdingcustno, 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
