Image transcription text INSERT INTO Member VALUES (12231,'Clement@gmail.com','Dr Clement', 'Staff,'Computing', 1, 'Active); INSERT INTO Member VALUES (34521, TanRT@gmail.com','Tan', 'Student','Business', 0,'Inactive); INSER... Show more Image transcription

Image transcription text

INSERT INTO Member VALUES (12231,'Clement@gmail.com','Dr Clement',
'Staff,'Computing', 1, 'Active"); INSERT INTO Member VALUES (34521,
"TanRT@gmail.com','Tan', 'Student','Business', 0,'Inactive"); INSER... 

Image transcription text

INSERT INTO MemberType VALUES ('Staff, 10); INSERT INTO MemberType VALUES
('Student', 5); INSERT INTO Loan VALUES ( 11, 12231, 1,'12/8/2022','17/8/2022','DONE','A1',
'18/8/2022', 0); INSERT INTO Loan VALUES ( 22, 12231, 2,'12/8/2022','17/8/... 

 

The images above are all the code that i've used to create my database in SQL. With this database, i need to use DML(Data Manipulation Language) to answer these 3 questions that are in the image below. What are the code that i should type in to get these answers? 

  
 
 
 
 
 
 

--Creating Database CREATE DATABASE TestUPA; --UPA Library Management System --Activate Database USE TestUPA; --Creating Tables CREATE TABLE Book (BookID INTEGER NOT NULL PRIMARY KEY, BookISBN VARCHAR(50) NOT NULL FOREIGN KEY REFERENCES Book Description (Book ISBN). BType VARCHAR(50) NOT NULL FOREIGN KEY REFERENCES BookType (BType), Quantity INTEGER NOT NULL FOREIGN KEY REFERENCES Book Availability(Quantity), Category VARCHAR(50) NOT NULL FOREIGN KEY REFERENCES Book Category (Category), ); CREATE TABLE Book Description (BookISBN VARCHAR(50) NOT NULL PRIMARY KEY, Book Title VARCHAR(50) NOT NULL, Volume INTEGER NOT NULL, Publisher VARCHAR (50) NOT NULL, Author VARCHAR(50) NOT NULL, PageNumber INTEGER NOT NULL, Publication Year VARCHAR (10) NOT NULL, SubjectArea VARCHAR(50) NOT NULL, BookEdition INTEGER NOT NULL, Language VARCHAR (50) NOT NULL, Binding VARCHAR (10) NOT NULL, ); CREATE TABLE BookCategory (Category VARCHAR(50) NOT NULL PRIMARY KEY, MaxLoanDays INTEGER NOT NULL, FineRate INTEGER NOT NULL, );