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

insert into instructor (inst_name, ss#, inst_addr) values

('J.S.Fink', 613557642, 'Brooklyn')

insert into instructor (inst_name, ss#, inst_addr) values

('A.M.Jones', 452113641, 'Long Island')

insert into course (course, course_title, location, pre-by ), values
('IS101', 'Introduction to Computer Science', 'Lecture Theatre 1',
null)

insert into course (course, course_title, location, pre-by ), values
('IS201', 'System Analysis', 'Lecture Theatre 2', null)

insert into course(course, course_title, location, pre-by ), values
('IS301', 'Decision Support System', 'Room P7818', null)

insert into prerequisite (prerequisite, prereq_title, pre ) values
('IS201', 'System Analysis', null)

The content of file F j after second substep are:

XSGDWHVHFWLRQ
VHW WDXJKWBE\ VHOHFWIURPLQVWUXFWRUZKHUHVV
VHW GLYLGHGBE\ VHOHFWIURPFRXUVHZKHUHFRXUVH Μ,6¶
ZKHUHVV DQGFRXUVH Μ,6¶DQGVHFWLRQ
XSGDWHVHFWLRQ
VHW WDXJKWBE\ VHOHFWIURPLQVWUXFWRUZKHUHVV
VHW GLYLGHGBE\ VHOHFWIURPFRXUVHZKHUHFRXUVH Μ,6¶
ZKHUHVV DQGFRXUVH 6¶DQGVHFWLRQ
XSGDWHHQUROO
VHW UHJLVWHUBE\ VHOHFWIURPJUDGXDWHBVWXGHQWZKHUHVWXGHQW
Μ¶
VHW SURYLGHBE\ VHOHFWIURPVHFWLRQZKHUHVV
DQGFRXUVH Μ,6¶DQGVHFWLRQ
ZKHUHVV DQGFRXUVH 6¶DQGVHFWLRQ DQG
\HDU

XSGDWHHQUROO
VHW UHJLVWHUBE\ VHOHFWIURPJUDGXDWHBVWXGHQWZKHUHVWXGHQW
Μ¶
VHW SURYLGHBE\ VHOHFWIURPVHFWLRQZKHUHVV
DQGFRXUVH Μ,6¶DQGVHFWLRQ
ZKHUHVV DQGFRXUVH Μ,6¶DQGVHFWLRQ DQG
\HDU