Which are not necessarily controlled by the same department

Assignment Help Database Management System

Reference no: EM133758052

Assignment: ER Design

We need to create a database ER design based on the following (simplified) requirements of the COMPANY Database:

1. The company is organized into DEPARTMENTs. Each department has a name, number, and an employee who manages the department. A department may have several locations.

2. Each department controls a number of PROJECTs. Each project has a unique name, unique number, budget, and a brief description.

3. We store each EMPLOYEE's employee number, name, address, phone number, and salary

4. Each employee works for one department but may work on several projects, which are not necessarily controlled by the same department.

5. We keep track of the start date of each employee working for their respective department.

6. We keep track of the number of hours per week that an employee currently works on each project.

7. We also keep track of the direct supervisor of each employee.

8. Each employee may have a number of DEPENDENTs.

9. Each employee may have a number of DEPENDENTs. For each dependent, we keep track of their name, age, birthdate, and relationship to the employee. We assume each dependent only has one parent who works for the company.

Reference no: EM133758052

Questions Cloud

Should the amusement park review the current policy : CONS 3250 OHIO UNIVERSITY- Should the amusement park review the current policy on providing refunds or credit? Why or why not?

Demonstrate an understanding business practice and research : HI5013 Managing Across Borders, Holmes Institute - Demonstrate an understanding business practice and research in the context of globalisation from a management

What was the initial problem statement or definition : What was the initial problem statement or definition? What key insights do you think were drawn from the research results that led to the creative strategy?

Provide a short summary of the main theme of the film : Provide a short summary of the main theme of the film. Acknowledge at least two scientific facts/evidence being presented in the film.

Which are not necessarily controlled by the same department : Each employee works for one department but may work on several projects, which are not necessarily controlled by the same department.

Enzyme measurements for assessment of myocardial infarction : Which information would the nurse be aware of when using cardiac enzyme measurements for assessment of myocardial infarction?

Difficulty voiding on his own so indwelling catheter : The elderly man who had a CVA is having difficulty voiding on his own so an indwelling catheter is inserted.

Statute deem appropriate for resolution by mediation : Which of the following offenses does Florida Statute deem appropriate for resolution by mediation? False, misleading or deceptive advertising.

What attributes or components of ems are displayed : What attributes or components of EMS are displayed and how so (be specific)? Which ones are missing? Make sure that you list all of the components.

User Account

All Pages