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

The template file is shown below with record name, existing record keys, record
identifier type ('F' = fully internally identified, 'P' = partially internally identified,
and 'I' = internally unidentified), derived record identifier, and attributes for each
record type.

Record name Record key Identifier type Record identifier Attributes

course course# F course# course#

course_location

prerequisite prerequisite# F prerequisite# prerequisite#

prerequisite_title

department department# F department# department#

department_name

instructor instructor_name P department#

instructor_name

instructor_name
instructor_
address

section P department#

course#
instructor_name
section#

student student# F student# student#

student_name

grade P department#

instructor_name
course#
student#
section#

grade

The Set Linkage template file is shown below:

Owner Member Set Linkage Name

COURSE PREREQUISITE Course_Prerequisite

COURSE SECTION Course_Section

DEPARTMENT INSTRUCTOR Department_Instructor

INSTRUCTOR SECTION Instructor_section

STUDENT GRADE Student_grade

SECTION GRADE Section_grade

Step 2—Unload records of each record type in the network database, with the re-
cord identifier into a sequential file.
Record COURSE

COURSE# COURSE_LOCATION

CS101 LECTURE THEATRE 1

IS201 LECTURE THEATRE 2

IS301 ROOM P7818