When turning in a homework problem, mark it with the exercise number shown in bold here. These will be the reference numbers I use in reporting back your standing on the homework.
4.1.x1: A college course catalog has the following structure:
Each department is identified by a three-character code and also has a full name which is at most 20 characters in length.
Each course is housed within a single department, is identified within that department by an integer in the range from 100 to 399, and has a full name which is at most 20 characters in length. Any number of courses can be housed in a department.
Each course can require any number of other courses, and each course can serve as a requirement for any number of other courses. Each time a course requires another course, the requirement must be of one of two types: "pre" or "co".
Draw an E-R diagram representing as much of the above information as possible using the features introduced in Section 4.1.
4.4.x1: Edit your E-R diagram for the college course catalog to incorporate as much additional information as possible using the notations from Sections 4.3 and 4.4.
4.5.x1: Write CREATE TABLE statements incorporating as much of your design as is possible with the techniques of Section 4.5. You should refer to the original course catalog description for relevant information that may not have been represented in the E-R diagrams.
4.6.x1: An interdepartmental program is treated as a special kind of department. The only relevant difference from ordinary departments is that each interdepartmental program has one or more departments that cooperate with it. Modify your E-R diagram to incorporate this additional feature of the course catalog and then use the technique of Section 4.6.1 to write the additional CREATE TABLE statements.
Instructor: Max Hailperin