Data Conversion - Information Systems Reengineering, Integration and Normalization - page 154

Step 3—Upload the unloaded sequential files into the relational Database.
Relational schema will be created with one create statement for each relation.
For example, the following is a create statement for the relation table DEPART-
MENT. Each unloaded sequential file is loaded to a relation.

CREATE TABLEDEPARTMENT
(DEPARTMENT CHAR(2),

DEPARTMENT_NAME CHAR(20))

CREATE TABLECOURSE
(COURSE# CHAR(5),

COUSE_LOCATION CHAR (20))

CREATE TABLEPREREQUISITE
(PREREQUISITE# CHAR(5),
PREREQUISITE_TITLE HAR (20),
COURSE#

CHAR(5))

CREATE TABLEINSTRUCTOR
(DEPARTMENT CHAR(2),

INSTRUCTOR_NAME

CHAR(20),

INSTRUCTOR_ADDRESS CHAR(40))
CREATE TABLESECTION
(DEPARTMENT CHAR(2),

COURSE# CHAR(5),

INSTRUCTOR_NAME

CHAR(20),

SECTION# CHAR(10))

CREATE TABLESTUDENT
(STUDENT#

INTEGER(5),

STUDENT_NAME CHAR (40))

CREATE TABLEGRADE
(DEPARTMENT CHAR(2),

INSTRUCTOR_NAME CHAR(20),

COURSE# CHAR(5),

STUDENT# INTEGER(5),

SECTION# CHAR(8),

GRADE CHAR(1))