Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
We need to create a database ER design based on the following (simplified) requirements of the COMPANY Database: The company is organized into DEPARTMENTS. Each department has a name, number, and an employee who manages the department. We keep track of the start date of the department manager. A department may have several locations. Each department controls a number of PROJECTS. Each project has a unique name, unique number, and a brief description. We store each EMPLOYEE's social security number, address, salary, sex, and birthdate. Each employee works for one department but may work on several projects, which are not necessarily controlled by the same department. We keep track of the number of hours per week that an employee currently works on each project. We also keep track of the direct supervisor of each employee. Each employee may have a number of DEPENDENTS. For each dependent, we keep track of their name, sex, birthdate, and relationship to the employee. We assume each dependent only has one parent who works for the company.

We need to create a database ER design based on the following (simplified) requirements of the COMPANY Database: The company is organized into DEPARTMENTS. Each department has a name, number, and an employee who manages the department. We keep track of the start date of the department manager. A department may have several locations. Each department controls a number of PROJECTS. Each project has a unique name, unique number, and a brief description. We store each EMPLOYEE's social security number, address, salary, sex, and birthdate. Each employee works for one department but may work on several projects, which are not necessarily controlled by the same department. We keep track of the number of hours per week that an employee currently works on each project. We also keep track of the direct supervisor of each employee. Each employee may have a number of DEPENDENTS. For each dependent, we keep track of their name, sex, birthdate, and relationship to the employee. We assume each dependent only has one parent who works for the company.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

 

ER Design Exercise

We need to create a database ER design based on the following (simplified) requirements of the COMPANY Database: The company is organized into DEPARTMENTS. Each department has a name, number, and an employee who manages the department. We keep track of the start date of the department manager. A department may have several locations. Each department controls a number of PROJECTS. Each project has a unique name, unique number, and a brief description. We store each EMPLOYEE's social security number, address, salary, sex, and birthdate. Each employee works for one department but may work on several projects, which are not necessarily controlled by the same department. We keep track of the number of hours per week that an employee currently works on each project. We also keep track of the direct supervisor of each employee. Each employee may have a number of DEPENDENTS. For each dependent, we keep track of their name, sex, birthdate, and relationship to the employee. We assume each dependent only has one parent who works for the company.
Transcribed Image Text:We need to create a database ER design based on the following (simplified) requirements of the COMPANY Database: The company is organized into DEPARTMENTS. Each department has a name, number, and an employee who manages the department. We keep track of the start date of the department manager. A department may have several locations. Each department controls a number of PROJECTS. Each project has a unique name, unique number, and a brief description. We store each EMPLOYEE's social security number, address, salary, sex, and birthdate. Each employee works for one department but may work on several projects, which are not necessarily controlled by the same department. We keep track of the number of hours per week that an employee currently works on each project. We also keep track of the direct supervisor of each employee. Each employee may have a number of DEPENDENTS. For each dependent, we keep track of their name, sex, birthdate, and relationship to the employee. We assume each dependent only has one parent who works for the company.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Structure chart
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS