A company database needs to store information about its employees (identified by ssn, with salary, phone...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company database needs to store information about its employees (identified by ssn, with salary, phone and title as attributes) and departments (identified by dno, with dname and budget as attributes), given the additional information below. Employees work in at least one department; each department is managed by exactly one employee and we want to know the date the manager started managing the department. An employee may be assigned at most one mentor, who is another employee, to get advice from on job and career development related issues. An employee may mentor several other employees (the mentees) but not all employees are required to serve as mentors. We want to store information about a mentor-mentee relationship and when it was established; we are not interested about such a relationship once either the mentor or the mentee leaves the company. Draw an ER diagram to capture the situation described above. Make sure you capture as many integrity constraints as possible and explicitly mention those that cannot be captured by the ER diagram (if any). Note: Make sure that your E/R diagrams are clear and unambiguous (e.g., your bold lines look unmistakably bold, your arrowheads look unmistakably like arrowheads, etc.). You will not receive the benefit of the doubt in the presence of ambiguity. A company database needs to store information about its employees (identified by ssn, with salary, phone and title as attributes) and departments (identified by dno, with dname and budget as attributes), given the additional information below. Employees work in at least one department; each department is managed by exactly one employee and we want to know the date the manager started managing the department. An employee may be assigned at most one mentor, who is another employee, to get advice from on job and career development related issues. An employee may mentor several other employees (the mentees) but not all employees are required to serve as mentors. We want to store information about a mentor-mentee relationship and when it was established; we are not interested about such a relationship once either the mentor or the mentee leaves the company. Draw an ER diagram to capture the situation described above. Make sure you capture as many integrity constraints as possible and explicitly mention those that cannot be captured by the ER diagram (if any). Note: Make sure that your E/R diagrams are clear and unambiguous (e.g., your bold lines look unmistakably bold, your arrowheads look unmistakably like arrowheads, etc.). You will not receive the benefit of the doubt in the presence of ambiguity.
Expert Answer:
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these databases questions
-
What is the difference between regarding businesses as development agents, and regarding them as development tools (Blow field & Murray, 2014)? Explain this in relation to at least one example you...
-
To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
1. Based on a simple, constant context, you will arrive at a stationary state for a unregulated, and then a regulated system. Assume that air resistance and friction for a car increase in the power...
-
For each of the following transactions, indicate how (a) net earnings and (b) cash flows are affected. For each, state whether there will be an increase, a decrease, or no effect, and the amount (if...
-
Suppose you have a large relation r(A, B, C) and a materialized view v = A sum (B)(r). View maintenance can be performed as part of each transaction that updates r, on a parallel/distributed storage...
-
Find the probability of randomly selecting an adult from the sample who does not prefer a science fiction movie or an action movie. SECTION 3.4 In Exercises 4144, perform the indicated calculation.
-
Ann Keeley and Susie Norton are partners in a business they started two years ago. The partnership agreement states that Keeley should receive a salary allowance of $40,000 and that Norton should...
-
$ 4.32 $ 4.55 13.68 Koontz Company manufactures a number of products. The standards relating to one of these products are shown below, along with actual cost data for May. Standard Actual Cost per...
-
In recent years, Jayme Company has purchased three machines. Because of frequent employee turnover in the accounting department, a different accountant was in charge of selecting the depreciation...
-
10. The size of a gear is usually specified by A. pressure angle B. circular pitch C. diametral pitch D. pitch circle diameter 11. When one of the links of a kinematic chain is fixed, the chain is...
-
(b) A cylindrical storage tank with base area 90 m is being filled with water through an entry duct with cross-section area 250 cm, as shown in Figure 3. Concurrently, water is being extracted from...
-
Po A cylinder/piston arrangement contains 5 kg of water at 100 C with x= 20%. Initially the piston of mass m, 75 kg rests on a set of stops (see figure). The outside pressure is 100 kPa, and the area...
-
TABLE 2 Present Value of an Annuity of $1 n 123456 8% 9% 0.925926 0.917431 4 7 8 9 10 11 12 13 14 15 16 17 11.652296 10.837770 10.105895 9.446649 12.165669 11.274066 10.477260 9.763223 18 19...
-
There are 4 suits (heart, diamond, clover, and spade) in a 52-card deck, and each suit has 13 cards. Suppose your experiment is to draw one card from a deck and observe what suit it is. Express the...
-
Write isotopic symbol of zirconium and how many neutrons are present in one atom of this isotope
-
Jefferson hired Jody, a general contractor, to install a pool and cabana at his home. The contract called fo Jody to pay all subcontractors personally. Although it was not called for in the contract,...
-
If a process has a six-sigma capability, what is the process capability index? a. 1 b. 2 c. 6 d. 12
-
Why must service companies, even more so than manufacturing companies, focus on customer costs and profitability?
-
How do the time frames for financial benefits for improvements in the different categories of processes typically vary?
-
Compute activity-based cost rate, time equations CAN Company sells multiple products and uses a time-driven ABC system. The companys products must be wrapped individually before shipping. The...
-
Unincorporated joint operation managed by one of the operators LO4 During 2018, discussions took place between Broken Bay Ltd, a company concerned with the design of specialised tools and...
-
ACCOUNTING FOR AN ASSET USED BY A NUMBER OF COMPANIES Raby Ltd and Bay Ltd are companies that have newly discovered oil wells in a MiddleEastern country. There is some distance to the nearest port...
-
Contribution of plant LO3, 4 On 1 July 2019, Tully Ltd and Cooktown Ltd signed a contractual agreement to form a joint operation for the manufacture of kitchen products. The agreement provided that...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App