Scenario : Snodsdale University is divided into several schools such as business, arts and sciences, education, computer systems, and applied sciences. Each school is headed by a dean who is a professor. Each professor can be the dean of only one school, and a professor is not required to be the dean of any school. A professor is one type of employee of the University and is associated with one department. The University broadly classifies employees as administrators, professors, and general staff (staff). The University classifies staff according to levels ranging from 1 to 10 (Level I, Level II, etc., based on seniority, competence, rank, etc.). For professors, in addition to the typical data associated with employees, the University also tracks the degrees that professors have earned.

Each school comprises several departments. A school can have multiple departments, but a school must have at least one department. For example, the school of business has an accounting department, a management/marketing department, an economics/ finance department, and a computer information systems department. A department is chaired by a professor.

Each department may offer courses. For example, the management/marketing department offers courses such as Introduction to Management, Principles of Marketing, and Production Management. Most departments offer courses, but several departments conduct research only and therefore do not offer courses. Courses may, but need not have, prerequisite courses.

A class is a section of a course. For example, a department may offer several sections (classes) of the same database course. Not every course is offered in a class during a given semester and therefore the course is not reflected in the class offerings for the semester. The University does not offer classes until and unless they class is reflected in the course catalog. Each class is taught by a professor at a given time on one or more days in a specific building and room.

A department has one or more professors assigned to it. One of those professors chairs the department, but no professor is required to accept the chair position.

Each professor may teach up to four classes; each class is a section of a course. A professor may also be on a research contract and teach no classes at all. Page 2 of 3

A student may enroll in several classes but takes a specific class only once during any given enrollment period. For example, a single student cannot enroll in BCS120 PM1 five times; he or she is only enrolled once. Each student may enroll in up to six classes, and each class may have up to 35 students.

Each department has several (or many) students whose major is offered by that department. Although each student has only one major and is associated with a single department in the University environment, it is possible at least for a while for a student not to declare a major field of study.

Each student has an advisor in his or her department; each advisor counsels several students. The advisor is a professor in the student's assigned department but not all professors advise students.

A class is held in a single room in a particular building on campus. A room must exist in single building, but some buildings on campus may not house any rooms suitable for classes (classrooms) at all, like those storage buildings or garages.

Task: Create an Entity-Relationship diagram [VISIO] with entities and relationships (e.g., 1:1, 1:M). Show strong/weak (solid vs. dotted line) and whether optional or mandatory. Note: The scenario above is a general description. It will be up to you to supply any needed assumptions about the data you will work with. State these assumptions either on a Word document to accompany Deliverable I's Visio file or directly as comments on the Visio file.