Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

What is GL _ REPEAT used for? Select one.

Answered: 1 week ago

Question

Which are non projected Teaching aids in advance learning system?

Answered: 1 week ago