1. Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students academic records. Create an ER diagram for the database using Chen notation. Specify all key attributes of each entity type and all relevant constraints; identify any derived attributes. Explain any assumptions you make, and identify any constraints which cannot be captured with the ER diagram.

(a) The university keeps track of each students name, student number, Social Security Number, current address and phone number, permanent address and phone number, birth date, class standing (freshman, sophomore, junior, senior, or graduate student), major department, minor department (if any), and degree program (BA, BS, masters, or PhD). Some applications need to refer to the city, state, and ZIP Code of the students permanent address and to the students last name. Class standing can be determined by the total number of credits the student has completed.

(b) Each department is described by a name, department code, and office phone number. Both name and department code have unique values.

(c) Each course has a course name, description, course number, number of credits (which can be 0, 0.5, 1. 1.5, etc.), and offering department. The combined values of the course number and offering department are unique, but two different courses may have the same number: e.g., CSCI 101 and PSYC 101.

(d) Each section has an instructor, semester, year, course, section number, and enrollment capacity. The section number distinguishes sections of the same course that are taught during the same semester and year; its values are 1, 2, 3, .

(e) A student can enroll in a section of a course if the course is not full. But a student is not allowed to enroll in two sections of the same course during the same semester.

(f) After the end of each semester, each student enrolled in a section of a course receives both a letter grade and a numeric grade based on a 4-point grade scale.

2. Consider the following ER diagram to answer the questions below with one of the answers True, False, or Maybe. Base your answers ONLY on the information contained in the diagram.

Every actor has acted in at least one movie.

There is at least one actor who has acted in two or more movies.

Every movie has exactly two leading roles.

Every actor has had exactly two leading roles.

Some movies have no actors in them.

Every director has directed at least one movie.

Some movies have at least two producers.

No actor is also a director.