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

SYSTEM

set set set

Course Department Student

Course#
coure-location

dept#
dept-name

student#
s-name

set set

Instructor Grade

set

set

grade

inst-name
inst-addr

set set

Prerequisite

Section

Prerequisite#
prerequisite-title

section#

Record Course Record Student

COURSE#
CS101
IS201
IS301

COURSE_LOCATION
LECTURE THEATRE1
LECTURE THEATRE2
ROOM P7818

STUDENT#
025056
312788
217228

STUDENT_NAME
JOHN F. SMITH
FRANK. H. FRAN
JANE E. BUNDY

Record Prerequisite Record Section

SECTION
SECTION1
SECTION2

PREREQUISITE#
IS201

PREREQUISITE_TITLE
SYSTEM ANALYSSIS

Record Department

Record Section

DEPARTMENT#
CS
IS

DEPARTMENT_NAME
COMPUTEER SCIENCE
INFORMATION SYSTEM

GRADE
A
B

Record Instructor

INSTRUCTOR_NAME
A.B.ADAMS
J.S. FINK
A.M. JONES

INSTRUCTOR_ADDRESS
WHITE PLAINS
BROOKLYN
LONG ISLAND

Fig. 4.8 A network database for university enrollment system