Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create ONE E-R diagram for a college, modeling the relationships among entities DEPARTMENT (DEPT for entity name), FACULTY, COURSE, and STUDENT: a. DEPT has at

Create ONE E-R diagram for a college, modeling the relationships among entities DEPARTMENT (DEPT for entity name), FACULTY, COURSE, and STUDENT: 


a. DEPT has at least four FACULTY members; each faculty member only works for one department; 


b. DEPT has at least 10 COURSEs; a course only belongs to one department; 


c. A faculty member can be assigned to teach up to four courses, but may not work in the current semester (“on sabbatical leave”); each course may be taught by at least one and up to three faculty members; 


d. A course may be enrolled by at least 20, up to 50 STUDENTs; a student may be enrolled in not more than 5 courses, but may be enrolled in no course for the current semester. In the E-R diagram, please include the following attributes for the entities involved: DEPT: DeptName, Chair; COURSE: C-ID, Title; STUDENT: S-ID, Major FACULTY: F-ID, Rank. Add proper foreign key(s) as the relationship(s) necessitate(s)

Step by Step Solution

3.32 Rating (149 Votes )

There are 3 Steps involved in it

Step: 1

Here is an ER diagram for a college modeling the relationships among entities DEPARTMENT DEPT for entity name FACULTY COURSE and STUDENT with the attributes and foreign keys as specified ERD Entities ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Programming questions