A)CREATE TABLE equipment ( equipmentid int NOT NULL, equipmentDesc varchar(30) N

Question

A)CREATE TABLE equipment ( equipmentid int NOT NULL, equipmentDesc varchar(30) NULL, equipmentprice int NOT NULL, PRIMARY KEY(equipmentid, equipmentDesc) ) ENGINE = InnoDB;

CREATE TABLE rental( rentalid int NOT NULL AUTO_INCREMENT, rentaldate date NOT NULL, fk_equipmentid int NULL, fk_equipmentprice int NULL, primary key (rentalid, rentaldate), FOREIGN KEY fk_eqid(fk_equipmentid) REFERENCES equipment(equipmentid) ON UPDATE CASCADE ON DELETE RESTRICT, FOREIGN KEY fk_eqpr(fk_equipmentprice) REFERENCES equipment(equipmentprice) ON UPDATE CASCADE ON DELETE RESTRICT ) ENGINE = InnoDB;

Question: Using this, Now create a query, which will show the equipment rented out with status.

Explanation / Answer

SELECT equipmentid, equipmentDesc FROM equipment WHERE equipmentid IN (SELECT fk_equipmentid FROM rental);

This query will show the equipment id and description which was rented out.

Regarding "status" it is not clear what kind of status you are looking for.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects