Question: A company database needs to store information about employees ( SSN , with salary and phone, identified by SSN ) , departments ( dno ,

A company database needs to store information about employees (SSN, with salary and phone,
identified by SSN), departments (dno, dname, and budget, identified by dno), and children of
employees (with name and date of birth). Each employee can work in one and only one
department; a department can have one or more employees. Each department is managed by an
employee; an employee can only manage one department. A child must be identified by name
when the parent (who is an employee; assume that only one parent works for the company) is
known. We are not interested in information about a child after the parent leaves the company

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 Programming Questions!