You are asked to assist in the design of the database. Sketch the Entity-Relationship diagram for each of the following business needs.
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