Question: theres a mistake on the code and correct it using mysql client CREATE TABLE Book B BID int AUTO INCREMENT, ISBN varchar(15), Bname varchar(100), Author
CREATE TABLE Book B BID int AUTO INCREMENT, ISBN varchar(15), Bname varchar(100), Author varchar(40), LoanPer int(2) Rate double (2,2). CONSTRAINT Book PK PRIMARY KEY (BID) -2 33 CREATE TABLE Borrow El CID int, BID int, Due Date ADDDATE (CURDATE(), INTERVAL expr unit), CONSTRAINT Borrow PK PRIMARY KEY (CID), CONSTRAINT Borrow FKL FOREIGN KEY (CID) REFERENCES Customer (CID), CONSTRAINT Borrow_FK2 FOREIGN KEY (BID) REFERENCES Book (BID), 39 10 42 43 CONSTRAINT Borrow CH1 IF (DATEDIFF (CURDATE(), DueDate) > 0, LateBook AS true, LateBook AS false). CONSTRAINT Borrow CH2 IF (Returned = true, Fine AS (DATEDIFF (CURDATE(). DueDate) + Rate), Fine AS NULL) ) length : 1,063 lines : 43 In: 4 Col : 3 Sel: 010 wuctured Query Language file 1 Type here to search Oete 9
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
