Suppose you have been assigned to design a database for your company. The design consists -following specifications-
Question:
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.
Auditing a business risk appraoch
ISBN: 978-0324375589
6th Edition
Authors: larry e. rittenberg, bradley j. schwieger, karla m. johnston