Chapter 12, Problem 63E

Explanation of Solution

Student table:

Table creation:

CREATE TABLE STUDENT (StudentID int primary key, StudentName varchar2(10), Department varchar2(5));

The above query is used to create a table named “STUDENT” with columns named “StudentID”, “StudentName” and “Department”.

Inserting values:

INSERT INTO STUDENT VALUES(101, 'Adams', 'CSE');

INSERT INTO STUDENT VALUES(102, 'Charles', 'IT');

INSERT INTO STUDENT VALUES(103, 'Bekki', 'MECH');

The above queries are used to insert values into the table named “STUDENT”.

After creating and inserting values, view the table by executing the query “SELECT * FROM STUDENT”.

Screenshot of the table “STUDENT”

Books table:

Table creation:

CREATE TABLE BOOKS (BookID int primary key, Author varchar2(10), Title varchar2(5));

The above query is used to create a table named “BOOKS” with columns named “BookID”, “Author” and “Title”.

Inserting values:

INSERT INTO BOOKS VALUES(1011, 'AAA', 'Computer Science');

INSERT INTO BOOKS VALUES(1012, 'ZZZ', 'Mangement of Information Systems');

INSERT INTO BOOKS VALUES(1013, 'BBB', 'Automation');

The above queries are used to insert values into the table named “BOOKS”.

After creating and inserting values, view the table by executing the query “SELECT * FROM BOOKS”.

Screenshot of the table “BOOKS”

CheckOut table:

Table creation:

CREATE TABLE CHECKOUT (StudentID int references STUDENT, BookID int references BOOKS, DueDate date);

The above query is used to create a table named “CHECKOUT” with columns named “StudentID”, “BookID” and “DueDate”...