Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

15 2. Suppose you have been assigned to design a database for your company. The design consists -following specifications- For each department the database contains

image text in transcribed

15 2. Suppose you have been assigned to design a database for your company. The design consists -following specifications- For each department the database contains a department number (unique), a budget value, and the department manager's employee number (unique). For each department the database also contains information about all employees working in the department, all projects assigned to the department, and all offices occupied by the department. The employee information consists of employee number (unique), the number of the project on which he or she is working, and his or her office number and phone number; the project information consists of project number (unique) and a budget value; and the office information consists of an office number (unique) and the area of the office in square feet. Also, for each employee the database contains the title of each job the employee has held, together with date and salary for distinct salary received in that job; and for each office it contains the numbers (unique) of all phones in that office. There can be different kind of employees in your company. There can be software engineer whose task is to develop different applications, there can be manager whose task is to manage a team, there can be human resource employees whose job is to fire people. Each project will be led by a project manager. Project manager can assign some of the employees from the team to supervise the project. Design the whole system with an appropriate ER diagram. Make all the necessary assumptions. Show at least one derived attribute, a multivalued attribute and a composite attribute

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Cost Accounting For Health Care Organizations

Authors: Steven Finkler, Judith Baker, David Ward

3rd Edition

0810235447, 9780763738136

More Books

Students also viewed these Accounting questions

Question

How often do you meet with your graduate students?

Answered: 1 week ago

Question

16.3 Describe the purpose of Canadian labour laws.

Answered: 1 week ago

Question

16.6 Outline the three waysto obtain union recognition.

Answered: 1 week ago

Question

16.5 Describe the five steps in a union organizing campaign.

Answered: 1 week ago