Question 2 [10 marks] Following on your job in modelling the employee assignments from the previous...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 2 [10 marks] Following on your job in modelling the employee assignments from the previous practical, you've now obtained the following business rules: One Employee supervises Many Employees, and possibly none, and a max of 20. One Employee is supervised by One Employee, and not none. One Employee takes on Many Assignments, and possibly none. • One Assignment is taken on by One Employee, and not none. • One Assignment takes place in One Section, and not none. • One Section appears in Many Assignments, and possibly none. • One Section belongs to One Building, and not none. • One Building has Many Sections, and possibly none, and a max of 20. You have also been given a small sample of their records, in case this may prove useful. It is below. 8 Assignment 9 10 11 12 13 14 No Date Employee ON 22/08/2013 2111 23/08/2013 2111 23/08/2013 2121 24/08/2013 2215 25/08/2013 2215 25/08/2013 2121 26/08/2013 2111 Employee B. Johns B. Johns M. Janes K. Joes K. Joes M. Janes B. Johns Section Section N G1 Canteen F3 Office G2 Copiers G1 Canteen F3 Office K2 Bathroom F5 Foyer Building G Willis Flora G Willis G Willis Flora Komanche Flora Start End Supervisor No 12h00 19h00 2321 11h00 14h00 2321 08h00 13h00 2215 13h00 16h30 2215 09h00 12h00 13h00 14h00 16h00 18h00 2215 2215 2321 2 3 2 2 3 5 نیا Building N In case you need extra info: • Section is a kind of code given to a section in a specific building. Each section has a completely unique code (across all buildings) e.g. F3 only exists in building "Flora", not any other building. • Section N is short for "section name"; it's the name of the section • Each employee has a specific supervisor, regardless of where/what they are assigned. Building N is a unique number given to a specific building. • Supervisor No is actually just the Employee No of the Employee that supervises a given Employee Use these business rules to draw a nice neat ERD. Remember that if you encounter any Many- to-Many relationships in the business rules, you will need to first break down and resolve these relationships into a set of business rules in which a bridge entity is created as discussed in class. Clearly show your new business rules if this should be the case. Question 2 [10 marks] Following on your job in modelling the employee assignments from the previous practical, you've now obtained the following business rules: One Employee supervises Many Employees, and possibly none, and a max of 20. One Employee is supervised by One Employee, and not none. One Employee takes on Many Assignments, and possibly none. • One Assignment is taken on by One Employee, and not none. • One Assignment takes place in One Section, and not none. • One Section appears in Many Assignments, and possibly none. • One Section belongs to One Building, and not none. • One Building has Many Sections, and possibly none, and a max of 20. You have also been given a small sample of their records, in case this may prove useful. It is below. 8 Assignment 9 10 11 12 13 14 No Date Employee ON 22/08/2013 2111 23/08/2013 2111 23/08/2013 2121 24/08/2013 2215 25/08/2013 2215 25/08/2013 2121 26/08/2013 2111 Employee B. Johns B. Johns M. Janes K. Joes K. Joes M. Janes B. Johns Section Section N G1 Canteen F3 Office G2 Copiers G1 Canteen F3 Office K2 Bathroom F5 Foyer Building G Willis Flora G Willis G Willis Flora Komanche Flora Start End Supervisor No 12h00 19h00 2321 11h00 14h00 2321 08h00 13h00 2215 13h00 16h30 2215 09h00 12h00 13h00 14h00 16h00 18h00 2215 2215 2321 2 3 2 2 3 5 نیا Building N In case you need extra info: • Section is a kind of code given to a section in a specific building. Each section has a completely unique code (across all buildings) e.g. F3 only exists in building "Flora", not any other building. • Section N is short for "section name"; it's the name of the section • Each employee has a specific supervisor, regardless of where/what they are assigned. Building N is a unique number given to a specific building. • Supervisor No is actually just the Employee No of the Employee that supervises a given Employee Use these business rules to draw a nice neat ERD. Remember that if you encounter any Many- to-Many relationships in the business rules, you will need to first break down and resolve these relationships into a set of business rules in which a bridge entity is created as discussed in class. Clearly show your new business rules if this should be the case.
Expert Answer:
Answer rating: 100% (QA)
Question In the above scenario the main three entities may be 1 Empl... View the full answer
Related Book For
Corporate Finance
ISBN: 978-0077861759
10th edition
Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe
Posted Date:
Students also viewed these finance questions
-
A firm is considering an investment in a new machine with a price of $18 million to replace its existing machine. The current machine has a book value of $6 million and a market value of $4.5...
-
A firm is considering an investment in a new machine with a price of $11.5 million to replace its existing machine. The current machine has a book value of $3 million, and a market value of $5.2...
-
A company is considering an investment in a machine that it believes will speed up production of a product. The machine will cost the company $2,000,000. Products produced using the machine will sell...
-
One reason you might choose to sync a SharePoint library to your computer is to Select an answer: have a separate copy that your colleagues can't affect have a separate copy in case SharePoint breaks...
-
Why do audit partners struggle with making tough accounting decisions that may be contrary to their client's position on an issue? What changes should the profession make to eliminate these obstacles?
-
Explain the concept of bounded rationality as it relates to social shopping.
-
In a first system of pulleys, there are 4 movable pulleys. If the efficiency of the system is 80%, find the effort required to lift a load of 5 kN.
-
Your friend, Diana Wood, recently completed the second year of her business and just received annual financial statements from her accountant. Wood finds the income statement and balance sheet...
-
What replacement behavior could be taught to a student as part of a behavior intervention plan and what type of generalization could be used to help the student apply that behavior to a different...
-
Go to the Structural Styles section and create a style rule that sets the background color of the browser window to rgb(173, 189, 227). Create a style rule for the body element that sets the...
-
Your client has the following properties which they have disposed of in 2020. ACB Proceeds Boat $ 1,000 $ 1,800 Jewelry $ 600 $ 1,300 Sculpture $ 3,600 $ 700 Freezer $ 250 $ 650 Shares - public...
-
Calculate the beta of an investment considering that the risk free rate is 1,5%, the expected market return is 4% and the capital asset pricing model (CAPM) is 11%
-
Ms. Deepika has been supervising eight accounting clerks in the budget and planning department of a paper company, namely ABC Paper Mills. Assam. Though none of the clerks had earned certificate in...
-
A payment of $20800 is to be made every year for 15 years. The first payment occurring is one year's time. The interest rate is 7%. What is the PV of the annuity?
-
Part A: Seasonal changes in freeze tolerance and cryoprotectants The wood frog, Rana sylvatica, is a largely terrestrial frog species that is found from the Southern Appalachians to the Arctic...
-
An Owner approaches you for help in deciding on buying property (land) for a new building. He's not sure if the idea is economically feasible. What sort of estimate could you prepare for him? How...
-
Evaluate the z and express the final answer in polar form. (5-j7)(4235)-6e-j7 Z 5(cos30+j sin30)
-
Suppose that you could invest in the following projects but have only $30,000 to invest. How would you make your decision and which projects would you invest in? Project Cost $ 8,000 11,000 9,000...
-
An investment in a foreign subsidiary is estimated to have a positive NPV after the discount rate used in the calculations is adjusted for political risk and any advantages from diversification. Does...
-
Siblings, Inc., is expected to maintain a constant 6.4 percent growth rate in its dividends, indefinitely. If the company has a dividend yield of 4.3 percent, what is the required return on the...
-
Hoobastink Mfg. is considering a rights offer. The company has determined that the ex-rights price will be $61. The current price is $68 per share, and there are 10 million shares outstanding. The...
-
Speeds of bullet trains. Determine whether the data are qualitative or quantitative. Explain your reasoning.
-
Widths of veins in different species of leaves. Determine whether the data are qualitative or quantitative. Explain your reasoning.
-
American Standard Code for Information Interchange (ASCII) codes. Determine whether the data are qualitative or quantitative. Explain your reasoning.
Study smarter with the SolutionInn App