The following information is stored in two relational database files: Employee Master File Social Security number Name
Question:
The following information is stored in two relational database files:
Employee Master File
Social Security number
Name
Address
Date hired
Hourly wage rate
Marital status
Number of exempt ions
Weekly Payroll File
Social Security number
Hours worked
Deductions
Bonuses
Required
a. Bogey works in personnel and Bacall works in payroll. Prepare a database authorization table that you think is appropriate for Bogey and Bacall for these two files.
b. Discuss any potential exposure if the right prevention devices are not in place or if Bogey and Bacall collude.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 65% (20 reviews)
a DEPARTMENT Personnel Personnel Payroll Payroll USER Bogey Bacal...View the full answer
Answered By
Ajeet Singh
Professional, Experienced, and Expert tutor who will provide speedy and to-the-point solutions.
I have been teaching students for 5 years now in different subjects and it's truly been one of the most rewarding experiences of my life.
I have also done one-to-one tutoring with 100+ students and help them achieve great subject knowledge.
I have expertise in computer subjects like C++, C, Java, and Python programming and other computer Science related fields.
Many of my student's parents message me that your lessons improved their children's grades and this is the best only thing you want as a teacher. I have done plenty of studying and lots of learning on many exciting and challenging topics. All these experiences have influenced my decision to take on the teaching role in various capacities. As a tutor, I am looking forward to getting to understand your needs and helping you achieve your academic goals. I'm highly flexible and contactable. I am available to work on short notice since I only prefer to work with very small and select groups of students.
4.90+
7+ Reviews
15+ Question Solved
Related Book For
Question Posted:
Students also viewed these Accounting questions
-
The following information is stored in two relational database files: Employee Master File Social Security number Name Address Date hired Hourly wage rate Marital status Number of exemptions Weekly...
-
The following information is obtained from two independent samples. Test at 1% significance level that the median for sample 1 is less than the median for sample 2 and interpret the meaning of your...
-
The following information is for Filimonov Industries, Inc: Determine the contribution margin for(a) Cake hand-held video games and (b) West Region East West Sales volume (units): 19,000 Sea 22,500...
-
Olena Mirrors records bad debt using the allowance, income statement method. They recorded $343,160 in accounts receivable for the year and $577,930 in credit sales. The uncollectible percentage is...
-
A bird is perched on a high-voltage power line whose potential varies between 100 kV and + 100 kV. Why is the bird not electrocuted?
-
Is it true that the following expression can be used to find the value of a constant growth stock?AppendixLO1 P Do k+g
-
3. When should the unrealized profit or loss from inventory be realized in intercompany sales transactions?
-
Ronald Naquin, an employee of Air Engineered Systems & Services, Inc., owned one-third of its outstanding shares. After six years, he was fired and an offer was made to buy out his interest in Air...
-
On Dec. 1 , 2 0 2 1 , a dealer sells a car for $ 1 6 , 0 0 0 with a maximum one - year or 1 2 , 0 0 0 mile warranty covering parts. Experience indicates warranty expenses average 4 % of a car's...
-
Accounting Today identified the top accounting firms in 10 geographic regions across the United States. Even though all 10 regions reported growth in 2011, the Southeast and Gulf Coast regions...
-
Listed here are five scenarios. For each scenario, discuss the potential consequences and give a prevention technique. a. The systems operator opened a bag of burned microwave popcorn directly under...
-
Brew Bottle Company (BBC) is in the process of planning a more advanced computer-based information system. Slavish & Moore, LLP, BBCs consulting firm, have recently been provided with an overview of...
-
Solve the inequalities in Problems 1740. 4 a +2
-
Indicate whether each of the following types of transactions will either (a) increase stockholders' equity or (b) decrease stockholders' equity: 1. expenses 2. revenues 3. stockholders' investments...
-
The following selected transactions were completed by Lindbergh Delivery Service during October: 1. Received cash from issuing capital stock, \($75,000\). 2. Paid rent for October, \($4,200\). 3....
-
Murray Kiser operates his own catering service. Summary financial data for February are presented in equation form as follows. Each line designated by a number indicates the effect of a transaction...
-
A. Given that y = e 2x + 1 complete the table of values of y corresponding to x = 0.5, 1 and 1.5. B. Use the trapezium rule, with all the values of y in the completed table, to obtain an estimate for...
-
Draw a schematic using NFETs and PFETs for a restoring logic gate that implements the function = 0 if zero or two of inputs cba are true. Assume that all inputs and their complements are available.
-
Ethics Guidelines. Why is there a need for an ethics guideline for professional accountants? Explain. In what ways should the ethics code for accountants be different from that of other groups such...
-
Continuation of Exercise 4-83. (a) What is the probability that the first major crack occurs between 12 and 15 miles of the start of inspection? (b) What is the probability that there are no major...
-
A priority queue of strings is implemented using a heap. The heap contains the following elements: 1. What feature of these strings is used to determine their priority in the priority queue? 2. Show...
-
Distinguish between the various service organization controls (SOC) reporting options available to auditors who evaluate cloud computing service providers.
-
In order to preserve auditor independence, the Sarbanes-Oxley Act of 2002 restricts the types of nonaudit services that auditors can perform for their public-company audit clients. The list includes...
-
Internal Controls and CAATs for a Wholesale client. a. What tests of controls would be effective in helping Draker determine whether Palitts vendor database was susceptible to fraud? b. What...
-
Regarding Enron, this was a company that resulted in the creation of the Sarbanes-Oxley Act and many reforms to the accounting profession. Research the company and answer the following...
-
Clayton received a $140,000 distribution from his 401(k) account this year. Assuming Clayton's marginal tax rate is 25 percent, what is the total amount of tax and penalty Shauna will be required to...
-
Mass LLp developed software that helps farmers to plow their fiels in a mannyue sthat precvents erosion and maimizes the effoctiveness of irrigation. Suny dale paid a licesnsing fee of $23000 for a...
Study smarter with the SolutionInn App