Data representations Sequential file, single record type, fixed format Sequentia

Question

Data representations

Sequential file, single record type, fixed format
Sequential file, single record type, delimited format
Sequential file, multiple record type, fixed format
EDI-style file
XML file

1. Diagram the course schedules in each of the data representations listed. The same instructor name represents the same person.

Course Schedule:
Dept: Math
Class 101 Basic Math
Instructor: A. Smith
Class 201 Algebra
Instructor: J.Jones
Class: 301 Calculus
Instructur: A.Smith
Dept: Chemistry
Class: 101 Basic Chemistry
Instructor: M. Fields
Dept: English
Class: 101 Writing
Instructor: R. Milton
Class: 201 Shakespeare
Instructor: M. Fields

Explanation / Answer

1) Sequential file, single record type, delimited format

dept,class,Instructor
MAth,Class 101 Basic MAth,A.smith
Math,Class 201 ALgebra,J.jones
Math,Class 301 Calculus,A.smith
Chemistry,Class 101 Baisc Chemestry,M.Fields
English,Class 101 Writing,R.MIlton
English,Class 201 Shakespeare,M.Fields

2) Sequential file, single record type, fixed format

MAth Class 101 Basic MAth A.smith
Math Class 201 ALgebra J.jones
Math Class 301 Calculus A.smith
Chemistry Class 101 Baisc Chemestry M.Fields
English Class 101 Writing R.MIlton
English Class 201 Shakespeare M.Fields

3)

Sequential file, multiple record type, fixed format

MAth Class 101 Basic MAth A.smith
Math Class 201 ALgebra J.jones
Math Class 301 Calculus A.smith
Chemistry Class 101 Baisc Chemestry M.Fields
English Class 101 Writing R.MIlton
English Class 201 Shakespeare M.Fields

4) xml

<?xml version="1.0" encoding="UTF-8"?>
<Courses>
<classes>
<dept>MAth</dept>
<class>Class 101 Basic MAth</class>
<Instructor>A.smith</Instructor>
</classes>
<classes>
<dept>Math</dept>
<class>Class 201 ALgebra</class>
<Instructor>J.jones</Instructor>
</classes>
<classes>
<dept>Math</dept>
<class>Class 301 Calculus</class>
<Instructor>A.smith</Instructor>
</classes>
<classes>
<dept>Chemistry</dept>
<class>Class 101 Baisc Chemestry</class>
<Instructor>M.Fields</Instructor>
</classes>
<classes>
<dept>English</dept>
<class>Class 101 Writing</class>
<Instructor>R.MIlton</Instructor>
</classes>
<classes>
<dept>English</dept>
<class>Class 201 Shakespeare</class>
<Instructor>M.Fields</Instructor>
</classes>
</Courses>

5)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.