Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

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

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

Students also viewed these Databases questions