Bert the Payroll Guy is about to retire after 40 years and it's time to replace...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Bert the Payroll Guy is about to retire after 40 years and it's time to replace his manual time card system with some sort of computerized database. You have been asked to come up with the database design. As best we can tell, the time card system has the following properties: • A timecard contains hours worked and date submitted • Each timecard is associated with exactly one employee Each timecard has a unique id • Each timecard has a status: approved, not approved, or pending (not examined yet) • Each employee has a name, address, and a unique id Each employee submits a time card every pay period. i.e. In 1 year, they will submit multiple time cards • Each employee is associated with exactly one manager • Each manager is also an employee • Each manager is in charge of one or more employees • Each manager approves time cards for one or more employees Draw an ER diagram that captures this information. Bert the Payroll Guy is about to retire after 40 years and it's time to replace his manual time card system with some sort of computerized database. You have been asked to come up with the database design. As best we can tell, the time card system has the following properties: • A timecard contains hours worked and date submitted • Each timecard is associated with exactly one employee Each timecard has a unique id • Each timecard has a status: approved, not approved, or pending (not examined yet) • Each employee has a name, address, and a unique id Each employee submits a time card every pay period. i.e. In 1 year, they will submit multiple time cards • Each employee is associated with exactly one manager • Each manager is also an employee • Each manager is in charge of one or more employees • Each manager approves time cards for one or more employees Draw an ER diagram that captures this information.
Expert Answer:
Answer rating: 100% (QA)
According to the given information the ERDiagram for TIMECARD SYSTEM is drawn below In the above E... View the full answer
Related Book For
Investment Analysis and Portfolio Management
ISBN: 978-0538482387
10th Edition
Authors: Frank K. Reilly, Keith C. Brown
Posted Date:
Students also viewed these databases questions
-
What are the advantages of having an RDBMS provide complex data types?
-
In what scenarios can Hadoop and RDBMS coexist?
-
When RDBMS processes the following SQL SELECT statement: 1. What tables are accessed? 2. What fields are retrieved when the query is run? 3. What is the search criterion? SELECT Customer No, Customer...
-
Energy of the emitted photon when an L-electron drops into the k-state in copper (z = 29) is -1 use R=109737 cm, cm =1.23910eV] 7994.6 eV 1094.6 eV 1293.6 eV 1097.3 eV
-
Suppose that natural real GDP is constant. For every 1 percent increase in the rate of inflation above its expected level, firms are willing to increase real GDP by 4 percent. The purpose of this...
-
Evaluate the definite integrals in Problem. 5 41 dx
-
The Form 941 tax deposit includes which of the following types of taxes withheld from the employee and paid by the employer? (a) Federal income tax and FUTA tax (b) Federal income tax and Social...
-
Stephen King, D.D.S., opened a dental practice on January 1, 2012. During the first month of operations, the following transactions occurred. 1. Performed services for patients who had dental plan...
-
Can someone help explain this please:. Self-Supporting Growth Rate Maggie's Muf?ns Bakery generated $2 million in sales during 2019, and its year-end total assets were $1.3 million. Also, at...
-
Kicking It Corp. is planning to open a football camp in Arizona, which will require a land purchase and facilities development that includes fields, sleeping and dining facilities, maintenance...
-
An insurer's ability to absorb higher than expected losses, or a catastrophe event, is largely dependent on its Available answer options Select only one option A Written premium. B Surplus. C Loss...
-
Leslie suggested that the companys audit committee should be involved in the setting of the tolerable error. Discuss the merits of this proposal.
-
Is it dishonest for an auditor to suggest improvements to a clients credit control system if he is doing so to reduce the level of audit risk and not out of a desire to reduce the cost of bad debt...
-
Discuss the weaknesses of break-even analysis.
-
How can accounting firms overcome the dangers associated with interrelated aspects of the audit being completed in isolation?
-
Demonstrate the way in which marginal analysis can be used when making short-term decisions.
-
Regina Corporation reported the following items on its year end date of November 30, 2021: Savings account at First National Bank $ 45,878 Bank overdraft at Second Provincial Bank 10,499 Post-da...
-
The cost curve for the city water supply is C(Q) = 16 + 1/4 Q2, where Q is the amount of water supplied and C(Q) is the cost of providing Q acre-feet of water. (An acre-foot is the amount of water...
-
Exhibit demonstrated how the Fama-French three-factor and four-factor models could be used to estimate the expected excess returns for three stocks (MSFT, CSX, and XRX). Specifically, using return...
-
Closed-end funds generally invest in securities and financial instruments that are relatively illiquid, whereas most mutual funds invest in widely traded stocks and bonds. Explain the difference...
-
You are currently managing a stock portfolio worth $55 million and you are concerned that over the next four months equity values will be flat and may even fall. Consequently, you are considering two...
-
Sketch (by hand) the graphs of each of the following functions over four periods. Then sketch the extensions of each of the functions as both an even and odd periodic function. Determine the...
-
Consider the function \(f(x)=x,-\pi
-
Differentiate the Fourier sine series term by term in Problem 18. Show that the result is not true. Why not? Data from Problem 18 Consider the function \(f(x)=x, 0
Study smarter with the SolutionInn App