Answered step by step
Verified Expert Solution
Question
1 Approved Answer
120 Points) A university database needs to store information about professors (identified by p_id, with title, office, and phone as attributes), departments (identified by d_id,
120 Points) A university database needs to store information about professors (identified by p_id, with title, office, and phone as attributes), departments (identified by d_id, with d_name, and building as attributes), and children (with c_name and age as attributes). Every professor works in only one department; every department is managed by only one professor; the children of the same professor can be distinguished by their c_name (assuming only one parent of a child works for the university). We do not maintain the information of a child once his/her parent leaves the university. Draw an ER Diagram for the university database application described above
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started