Which of the following completes the CREATE TABLE statement…
Which of the following completes the CREATE TABLE statement for the Trade table? CREATE TABLE Trade ( TradeNo CHAR(4), CustNo _______, EmpNo _______, AssetNo CHAR(2) NOT NULL, Qty INTEGER, Price DOUBLE, TDate DATE NOT NULL Type VARCHAR(10) NOT NULL, Status VARCHAR(10) NOT NULL, CONSTRAINT PKTrade PRIMARY KEY (TradeNo) CONSTRAINT FKCustomer FOREIGN KEY (CustNo) REFERENCES Customer (CustNo) CONSTRAINT FKAsset FOREIGN KEY (AssetNo) REFERENCES _____ (AssetNo) CONSTRAINT FKEmployee FOREIGN KEY (____) REFERENCES Employee (____))
Read DetailsThe data model shown below, and repeated in each of the rema…
The data model shown below, and repeated in each of the remaining questions, describes “Adventure Services, LLC”, a business of taking customers on adventure tours and/or renting the necessary gear (biking, hiking, kayaking) for self-guided tours. Note that both the tours (services) and the necessary gear are considered to be the “products” in this business.
Read Details