Need ER diagram for this database

The database to be built contains four major categories of data: personal information about students and faculty members, academic records of students, information about courses and course offerings, and teaching records of faculty members. Information about classrooms and other auxiliary data is also stored in the system.

A. Personal Records. The system shall contain a name, an Id number, and a password for each student and faculty member allowed to use the system. The password and the id together authenticate the user. Id numbers are unique. It is assumed that at least one faculty member has been initialized as a user at startup time.

B. Academic Records. The system shall contain the academic record of each student. a. Each course the student has completed, the semester the student took the course, and the grade the student received (A, B, C, D, F, I). b. Each course for which the student is enrolled this semester. c. Each course for which the student has registered next semester.

C. Course Information. Independent of students and faculty, the system shall contain information about courses offered. More specifically, for each course, the system shall contain a. The course name, the course number (must be unique), the department offering the course, the textbook, and the credit hours, b. Whether the course is offered in Fall, Spring, summer, or any combinations. c. The prerequisite courses (there can be an arbitrary number of prerequisites for each course). d. The maximum allowed enrollment, the number of students who are enrolled (unspecified if the course is not offered this semester). The maximum allowed registration (for the next semester), the number of students who are registered (unspecified if the course is not offered next semester). e. If the course is offered this semester, the days and times it is offered. If the course is offered next semester, the days and times it will be offered next semester. The possible values will be selected from a fixed list of weekly slots (e.g., MWF10am-10:50am). f. The Id of the instructor teaching the course this semester and next semester (Id is unspecified if unknown). g. The classroom assignment of the course for this semester and next semester (unspecified if not known).

D. Teaching Information. The system shall contain a record of all courses that have been taught previously or are being taught currently, including the semester in which they were taught and the Id of the instructor.

E. Classroom Information. The system shall contain a list of classroom identifiers and the corresponding number of seats. A classroom identifier is a three digit letter (for the building) followed by a three digit integer (for room number).

F. Auxiliary Information. The system shall contain the identity of the current semester and the next semester (e.g., Fall2010).