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

XSGDWHFRXUVH
VHW SUHBE\ VHOHFWIURPSUHUHTXLVLWHZKHUHFRXUVH Μ,6¶
ZKHUHSUHUHTXLVLWH Μ,6¶
XSGDWHSUHUHTXLVLWH
VHW SUHUHT VHOHFWIURPFRXUVHZKHUHFRXUVH Μ,6¶
ZKHUHSUHUHTXLVLWH Μ,6¶

The content of file F k after third substep are:

update graduate_student
set student_name = (select * from student where student# =
'012888')
set sex = (select * from student where student# = '012888')
where student# = '012888'

update graduate_student
set student_name = (select * from student where student# =
'120008')
set sex = (select * from student where student# = '1200008')
where student# = '1200008'

Step 3—(Optional). Transfer sequential files to target computer.
Not applied in this case study.
Step 4—Upload sequential files into object-oriented database
The three files F i , F j and F k are then uploaded into an object-oriented database to
fill in the classes and their attributes' values.
Step 5—(optional). Normalize the translated object-oriented schema
Since there is no redundant data in the object-oriented schema, this step can be
skipped.
As a result, the converted object-oriented database is
Class Course

OID Course Course_title Location

001 CS101 Intro to Computer Science Lecture Theatre 1

002 IS201 System Analysis Lecture Theatre 2

003 IS301 Decision Support System Room P7818

Class Prerequisite

OID Stored_OID Course# Prerequisite Prereq_title

014 003 IS301 IS201 System Analysis