A company database needs to store information about employees (identified by SSN, with salary and phone as attributes), departments (identified by DNO, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely 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 once the parent leaves the company. Draw an ER diagram to capture this information. Consider the scenario from Problem where you designed an ER diagram for a company database. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints, explain why.

A company database needs to store information about employees (identified by SSN, with salary and phone as attributes), departments (identified by DNO, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely 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 once the parent leaves the company. Draw an ER diagram to capture this information. Consider the scenario from Problem where you designed an ER diagram for a company database. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints, explain why.

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Applications

Section: Chapter Questions

Problem 4PSE: Using a graphics program, develop an entity-relationship diagram for a database application for an...

See similar textbooks

Similar questions

A new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spread-sheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.
Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBN
Data modeling is most often accomplished through the use of a(n) __________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagram
The ______________ model is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.
Data modelling is most often accomplished through the use of a(an) ________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagram
In the hierarchy of data, what is the difference between a data attribute and a data item? What is the domain of an attribute?