1.
|
<Last_Name>Widom</Last_Name> <Last_Name>Horowitz</Last_Name> <Last_Name>Levin</Last_Name>
|
2.
|
<Title>Computer Science</Title> <Title>Programming Methodology</Title> <Title>Programming Abstractions</Title> <Title>Computer Organization and Systems</Title> <Title>Introduction to Probability for Computer Scientists</Title> <Title>From Languages to Information</Title> <Title>Compilers</Title> <Title>Introduction to Databases</Title>
<Title>Artificial Intelligence: Principles and Techniques</Title> <Title>Structured Probabilistic Models: Principles and Techniques</Title> <Title>Machine Learning</Title> <Title>Electrical Engineering</Title> <Title>Digital Systems I</Title> <Title>Digital Systems II</Title> <Title>Linguistics</Title> <Title>From Languages to Information</Title>
|
3.
|
<Title>Programming Methodology</Title> <Title>Programming Abstractions</Title>
|
4.
|
<Title>Computer Science</Title> <Title>Electrical Engineering</Title>
|
5.
|
CS124
|
6.
|
<Last_Name>Aiken</Last_Name> <Last_Name>Cain</Last_Name> <Last_Name>Dally</Last_Name> <Last_Name>Horowitz</Last_Name>
|
7.
|
CS124 LING180
|
8.
|
CS107 CS228
|
9.
|
2
|
10.
|
10
|
11.
|
<Title>Introduction to Databases</Title>
|
12.
|
<Last_Name>Zelenski</Last_Name> <Last_Name>Widom</Last_nName>
|
13. |
<Title>Programming Methodology</Title> <Title>Programming Abstractions</Title>
|
14.
|
<Title>Machine Learning</Title>
|
15.
|
CS106B CS107 CS109 EE108B
|
16.
|
336
|
17.
|
<Title>Programming Methodology</Title>
|
18.
|
<Summary> <Course Enrollment="60"> <Title>From Languages to Information</Title> </Course> <Course Enrollment="90"> <Title>Compilers</Title> </Course> <Course Enrollment="110"> <Title>Structured Probabilistic Models: Principles and Techniques</Title> </Course> ... </Summary>
|
19.
|
<Professors> <Professor> <First_Name>Alex</First_Name> <Middle_Initial>S.</Middle_Initial> <Last_Name>Aiken</Last_Name> </Professor> ... <Professor> <First_Name>Jennifer</First_Name> <Last_Name>Widom</Last_Name> </Professor> ... </Professors>
|
20.
|
<Inverted_Course_Catalog> <Professor> <First_Name>Alex</First_Name> <Middle_Initial>S.</Middle_Initial> <Last_Name>Aiken</Last_Name> <Courses> <Course>CS143</Course> </Courses> </Professor> ... <Professor> <First_Name>Mark</First_Name> <Middle_Initial>A.</Middle-_Initial> <Last_Name>Horowitz</Last_Name> <Courses/> </Professor> <Professor> <First_Name>Dan</First_Name> <Last_Name>Jurafsky</Last_Name> <Courses> <Course>CS124</Course> <Course>LING180</Course> </Courses> </Professor> ... </Inverted_Course_Catalog>
For the extra challenge, the Professor elements for Mark
A. Horowitz and Beth Levin should be as follows:
<Professor> <First_Name>Mark</First_Name> <Middle_Initial>A.</Middle_Initial> <Last_Name>Horowitz</Last_Name> </Professor> ... <Professor> <First_Name>Beth</First_Name> <Last_Name>Levin</Last_Name> </Professor>
|
21.
|
<Title>Computer Science</Title> <Title>Electrical Engineering</Title> <Title>Linguistics</Title>
|
22.
|
<Department> <Title>Computer Science</Title> <Last_Name>Widom</Last_Name> </Department> <Department> <Title>Electrical Engineering</Title> <Last_Name>Horowitz</Last_Name> </Department> <Department> <Title>Linguistics</Title> <Last_Name>Levin</Last_Name> </Department>
|
23.
|
<Department> <Title>Computer Science</Title> <Chair> <Professor> <First_Name>Jennifer</First_Name> <Last_Name>Widom</Last_Name> </Professor> </Chair> </Department> <Department> <Title>Electrical Engineering</Title> <Chair> <Professor> <First_Name>Mark</First_Name> <Middle_Initial>A.</Middle_Initial> <Last_Name>Horowitz</Last_Name> </Professor> </Chair> </Department> <Department> <Title>Linguistics</Title> <Chair> <Professor> <First_Name>Beth</First_Name> <Last_Name>Levin</Last_Name> </Professor> </Chair> </Department>
|
24.
|
<Course Number="CS124" Enrollment="60"> <Title>From Languages to Information</Title> <Description>Natural language processing. Cross-listed as LING180.</Description> <Instructors> <Professor> <First_Name>Dan</First_Name> <Last_Name>Jurafsky</Last_Name> </Professor> </Instructors> <Prerequisites> <Prereq>CS107</Prereq> <Prereq>CS109</Prereq> </Prerequisites> </Course> <Course Number="CS143" Enrollment="90"> ... </Course> <Course Number="LING180" Enrollment="60"> ... </Course>
|
25.
|
The result should be the
same as the original data, except that courses CS124,
CS143, EE108A, EE108B, and LING180 no longer exist.
|
26.
|
<Course_Catalog> <Department Code="CS"> <Course Number="CS106A" Title="Programming Methodology"> <Enrollment>1070</Enrollment> <Description>Introduction to the engineering of computer app...</Description> </Course> <Course Number="CS106B" Title="Programming Abstractions"> <Enrollment>620</Enrollment> <Description>Abstraction and its relation to programming.</Description> </Course> ... </Department> <Department Code="EE"> <Course Number="EE108A" Title="Digital Systems I"> <Description>Digital circuit, logic, and system design.</Description> </Course> ... </Department> ... </Course_Catalog>
|
27.
|
<html> <table border="1"> <tr> <td><i>CS221</i></td> <td><b>Artificial Intelligence: Principles and Techniques</b></td> <td>180</td> </tr> <tr> <td><i>CS107</i></td> <td><b>Computer Organization and Systems</b></td> <td>500</td> </tr> ... </table> </html>
Full table:
CS221 |
Artificial Intelligence: Principles and
Techniques |
180 |
CS107 |
Computer Organization and Systems |
500 |
CS145 |
Introduction to Databases |
130 |
CS109 |
Introduction to Probability for Computer
Scientists |
280 |
CS229 |
Machine Learning |
320 |
CS106B |
Programming Abstractions |
620 |
CS106A |
Programming Methodology |
1070 |
CS228 |
Structured Probabilistic Models: Principles
and Techniques |
110 |
|