"

"STUDENT INFORMATION TABLE" (

"STUDENT ID" CHARACTER (4) NOT NULL,

NAME CHARACTER (25) NOT NULL,

"STREET NUMBER" CHARACTER (10) NOT NULL,

"STREET NAME" CHARACTER (25) NOT NULL,

CITY CHARACTER (25) NOT NULL,

STATE CHARACTER (10) NOT NULL,

EMAIL CHARACTER (25) NOT NULL,

"PHONE NUMBER" CHARACTER (15) NOT NULL );

CONNECT RESET;

SQL FOR Book_Information

CONNECT TO LIBRARY;

CREATE TABLE "USER";

CREATE TABLE BookInformation (

"BookISBN" CHARACTER (10) NOT NULL;

"AUTHOR" CHARACTER (25) NOT NULL;

"TITLE" CHARACTER (50) NOT NULL;

"PRICE" CHARACTER (10) NOT NULL;

CONNECT RESET;

SQL STATEMENT FOR CD

CONNECT TO LIBRARY;

CREATE TABLE "USER";

CREATE TABLE CD (

"CD-Id" CHARACTER (25) NOT NULL;

"AUTHOR" CHARACTER (25) NOT NULL;

"TITLE" CHARACTER (25) NOT NULL;

"PRICE" CHARACTER (25) NOT NULL;

CONNECT RESET;

Experience Gained from this Assignment

The assignment has enhanced my greater understanding on the method to use IBM DB2 Express to develop database. Although, it takes me...
[ View Full Essay]