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

theres a mistake on the code and correct it using mysql client 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 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!