Entity Relationship Modelling

Question

You are asked to assist in the design of the database. Sketch the Entity-Relationship diagram for each of the following business needs.

Solution

Title: Entity Relationship Modelling
Length: 1 pages (275 Words)
Style: APA

Preview

Case I: The University

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.

The university is divided into several schools: business, arts and sciences, education, and applied sciences. Each school is administered by a dean who is also 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. Data of interest regarding the school includes: school code and school name. Data of interest regarding the professor includes: ID number, specialty, rank, name, and email address.

School	1..1 Administrated by 1..*	Professor
School Code {PK}		Professor ID Number {PK}
School Name		Professor Specialty
		Professor Rank
		Professor Name
		Professor E-mail Address

* Once your purchase is processed by paypal you will be redirected back to this page and you'll have the option to download the paper. We'll also send the paper to your paypal email address as proof of purchase.

Download Paper