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

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

Similar questions

Explain software structure review through examples.
How does the use of design patterns, such as the Singleton or Factory pattern, improve software development practices?
What is the distinction between a process-oriented and a structure-oriented design rationale technique? Would you classify psychological design ra tionale as process- or structure-oriented? Why?
In what ways does one conduct a thorough evaluation of software structures, and what are some examples?
Can you outline the procedures for software structure review?
List the several design models that we use throughout the software development lifecycle's analysis phase.
Describe the many Design models we use in our software analysis.
What are the problems faced by designer in physical design?
Explain universal design principle.
How do design patterns such as Singleton, Factory, and Observer contribute to software development, and when should they be used?
Draw Design Sequence Diagram for the library system.
Describe the many Design models we use in our software analysis.