Produce an entity relationship diagram for a relational database that will be able to address the case study. It is your task to design a database that will adhere to good design principles.
Produce an entity relationship diagram for a relational database that will be able to address the case study. It is your task to design a database that will adhere to good design principles.
Information Technology Project Management
9th Edition
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Kathy Schwalbe
Chapter9: Project Resource Management
Section: Chapter Questions
Problem 5QQ
Related questions
Question
Produce an entity relationship diagram for a relational database that will be able to address the case study. It is your task to design a database that will adhere to good design principles.
![Case Study
Priority University is a large institution with several campuses. Each campus
has a different name, address, distance to the city center and the only bus
running to the campus. Each campus has one club. The name of the club, the
building in which the club is located, the phone number of the club and the
multiple sports which club offers, should all be recorded.
The University consists of a number of faculties, such as the Art Faculty, the
Science Faculty, and so on. Each faculty has a name, dean and building. A
faculty may be divided into a number of schools, for example, the Science
Faculty has a School of Physics and a School of Chemistry. Each school
belongs to one faculty only and is located on just one campus, but one
campus maybe the location of many schools.
Every school has name and a building assigned to. Each school offers different
programmes and each programme can be offered by only one school. Each
programme has a unique code, title, level and duration. Each programme
comprises several courses, different programmes have different courses.
Each course has a unique code and course title. Some courses may have one
or more prerequisite courses and one course can be the prerequisite course of
some other courses.
Each of the students is enrolled in a single programme of study which involves
a fixed core of courses specific to that programme as well as a number of
electives taken from other programmes. Students work on courses and are
awarded a grade in any course if he/she passes the course. Otherwise the
student has to re-take the failed course. The system needs to record the year
and term in which the course was taken and the grade awarded to the](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F808e938a-aad7-4c1c-902c-ab4bac371e25%2Fdb545d78-acde-4742-a699-ce3d0cd3be49%2F93013u8_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Case Study
Priority University is a large institution with several campuses. Each campus
has a different name, address, distance to the city center and the only bus
running to the campus. Each campus has one club. The name of the club, the
building in which the club is located, the phone number of the club and the
multiple sports which club offers, should all be recorded.
The University consists of a number of faculties, such as the Art Faculty, the
Science Faculty, and so on. Each faculty has a name, dean and building. A
faculty may be divided into a number of schools, for example, the Science
Faculty has a School of Physics and a School of Chemistry. Each school
belongs to one faculty only and is located on just one campus, but one
campus maybe the location of many schools.
Every school has name and a building assigned to. Each school offers different
programmes and each programme can be offered by only one school. Each
programme has a unique code, title, level and duration. Each programme
comprises several courses, different programmes have different courses.
Each course has a unique code and course title. Some courses may have one
or more prerequisite courses and one course can be the prerequisite course of
some other courses.
Each of the students is enrolled in a single programme of study which involves
a fixed core of courses specific to that programme as well as a number of
electives taken from other programmes. Students work on courses and are
awarded a grade in any course if he/she passes the course. Otherwise the
student has to re-take the failed course. The system needs to record the year
and term in which the course was taken and the grade awarded to the
![student. Every student has a unique ID. The system also keeps the student
name, birthday and the year he/she enrolled in the course.
The school employs lecturers to teach the students. A lecturer is allowed to
work for one school only. Each lecturer is assigned an ID which is unique
across the whole university. The system keeps the lecturer's name, title and
the office room. A supervisor maybe in charge of several lecturers, but a
lecturer, however reports to only one supervisor. A lecturer can teach many
different courses. A course may also have been taught by many different
lecturers.
The university is operated by committees. Each faculty has to have a number
of committees with the same titles across the university, such as the Faculty
Executive, the Post Graduate Studies Committee, the Health and Sanity
Committee, and so on. The committees meet regularly, such as weekly or
monthly. The frequency is determined by the faculty involved. A committee's
members are all lecturers. A lecturer may be a member of several committees.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F808e938a-aad7-4c1c-902c-ab4bac371e25%2Fdb545d78-acde-4742-a699-ce3d0cd3be49%2Feneraaa_processed.jpeg&w=3840&q=75)
Transcribed Image Text:student. Every student has a unique ID. The system also keeps the student
name, birthday and the year he/she enrolled in the course.
The school employs lecturers to teach the students. A lecturer is allowed to
work for one school only. Each lecturer is assigned an ID which is unique
across the whole university. The system keeps the lecturer's name, title and
the office room. A supervisor maybe in charge of several lecturers, but a
lecturer, however reports to only one supervisor. A lecturer can teach many
different courses. A course may also have been taught by many different
lecturers.
The university is operated by committees. Each faculty has to have a number
of committees with the same titles across the university, such as the Faculty
Executive, the Post Graduate Studies Committee, the Health and Sanity
Committee, and so on. The committees meet regularly, such as weekly or
monthly. The frequency is determined by the faculty involved. A committee's
members are all lecturers. A lecturer may be a member of several committees.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Information Technology Project Management](https://www.bartleby.com/isbn_cover_images/9781337101356/9781337101356_smallCoverImage.jpg)
Information Technology Project Management
Computer Science
ISBN:
9781337101356
Author:
Kathy Schwalbe
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Information Technology Project Management](https://www.bartleby.com/isbn_cover_images/9781337101356/9781337101356_smallCoverImage.jpg)
Information Technology Project Management
Computer Science
ISBN:
9781337101356
Author:
Kathy Schwalbe
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)