Question

What’s A Matter University (good old Whatsamatter U) is developing a database to manage academic issues. You are asked to assist in the design of the database. Sketch the Entity-Relationship diagram for each of the following business needs. Your answer must adhere to the following guidelines:

a)    You need to provide a separate E-R diagram for each of the questions, not a single diagram that addresses all five questions;

b)    Although each question is to be answered with a separate E-R diagram, the business rules do remain consistent throughout the question set so, an entity you identified in one question might well be used as part of an answer to a second question;

c)     Your model should follow the “crows foot” notation, as described in Chapter 4 (pp 253-255) of the text.

d)   Grading points:

a.     All necessary entities identified and appropriately named.

b.     All attributes described for each entity included in the diagram.

c.      Primary key clearly identified for each entity.

d.     Both maximum and minimum cardinality clearly identified

e.      Any many-to-many relationships resolved.

f.      No unnecessary entities or attributes.

The question: The university is divided into several schools such as business, arts and sciences, education, applied sciences, etc. Each school is administered by a dean who is also a professor. Each professor can be the dean of only one school, but a professor is not required to be the dean of any school. Data of interest regarding the school includes: school code (which uniquely identifies each school) and school name. Data of interest regarding the professor includes: ID number (which uniquely identifies each professor), specialty, rank, name, and email address.

Each school is comprised of several departments. For example, the school of business has an accounting department, a management department, a marketing department, etc. A school has to have at least one department, and can consist of any number of departments. Each department belongs to only a single school. Data of interest regarding departments includes: department code (which uniquely identifies each department) and department name.

Answer 1