Question: Please draw it clear. Draw an ERD that captures the information below. A university database needs to store information about faculty members ( identified by

Please draw it clear. Draw an ERD that captures
the information below.
A university database needs to store information about faculty members (identified by
faclD, with department and phone as attributes), departments (identified by dname,
with facNum as an attribute), and students of faculty (with name and age as attributes).
Faculty work in departments; each department is managed by at most a department
head (who is a faculty); a student must be identified uniquely by name when the
advisor (who is a faculty) is known.Draw an ERD that captures
the information below.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!