onsider the below scenario and identify the entities and their relationships and then draw and ER diagram and then its physical design: Consider the following environment of a university. There are academic departments. Each department is identified by a 4 letter code, and has a name, a chairperson, an office and a telephone extension. Each department offers a set of courses. Each course is identified by the department code and a 3 digit number, and has a title and number of units; each course may require any number of prerequisite courses. Certain courses are currently offered; an offering of a course is called a class. A class is identified by a 9 digit class number, is taught by a particular faculty, and meets 1-3 times a week at the particular location. Each faculty is assigned to a single department. Each faculty is identified by a social security number, and has a name, a rank (e.g., assistant professor, associate professor, full professor), and a telephone extension and a set of office hours. The chairperson of a department is always assigned to that department. Each student is identified by a SSN, and has a name, a major department, and an academic status (e.g., undergraduate, graduate, non-degree). Each student is currently enrolled in a number of classes. For each course that the student had taken in the past, a letter grade is available. All locations and office consist of a 3 lette
Consider the below scenario and identify the entities and their relationships and then draw and ER diagram and then its physical design:
Consider the following environment of a university. There are academic departments. Each department is identified by a 4 letter code, and has a name, a chairperson, an office and a telephone extension. Each department offers a set of courses. Each course is identified by the department code and a 3 digit number, and has a title and number of units; each course may require any number of prerequisite courses. Certain courses are currently offered; an offering of a course is called a class. A class is identified by a 9 digit class number, is taught by a particular faculty, and meets 1-3 times a week at the particular location. Each faculty is assigned to a single department. Each faculty is identified by a social security number, and has a name, a rank (e.g., assistant professor, associate professor, full professor), and a telephone extension and a set of office hours. The chairperson of a department is always assigned to that department. Each student is identified by a SSN, and has a name, a major department, and an academic status (e.g., undergraduate, graduate, non-degree). Each student is currently enrolled in a number of classes. For each course that the student had taken in the past, a letter grade is available. All locations and office consist of a 3 letter building code and a 3 digit room number. All telephone extensions are 4 digits.
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)