Chapter 23, Problem 2RE

Explanation of Solution

Database table design for storing library books and patrons:

Query 1:

Consider the below SQL statement, creates a table called “LibraryBookData”.

/* Create a table called LibraryBookData */

CREATE TABLE LibraryBookData

(

Library_ID_Card INTEGER,

ISBN_No CHAR(20),

Patron_ID_No INTEGER

);

Explanation:

In the above query,

• A table “LibraryBookData” has been created using “CREATE TABLE” statement.
• The “LibraryBookData” table contains three columns:
  • The “ Library_ID_Card” column is used to save the identify of each user. The datatype of this column is “INTEGER”.
  • The “ISBN_No” column is a unique ID for searching a book. The datatype of this column is “CHAR()” and the size is “20”.
  • The “Patron_ID_No” column is used for checking books out of the library. The datatype of this column is “INTEGER”.

Query 2:

Consider the below SQL statement, creates a table called “BookDetails”.

/* Create a table called BookDetails */

CREATE TABLE BookDetails

(

ISBN_No CHAR(20),

Author_Name VARCHAR(50),

Title_Name VARCHAR(40)

);

Explanation:

In the above query,

• A table “BookDetails” has been created using “CREATE TABLE” statement.
• The “BookDetails” table contains three columns:
  • The “ISBN_No” column is a unique ID for searching a book...