Question: Draw an ERD that captures the information below. A university database needs to store information about faculty members ( identified by faclD, with department and
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 attributesdepartments identified by dname,with facNum as an attributeand students of faculty with name and age as attributesFaculty 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 facultyis known.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
