Chapter 05 Homework

Chapter 05 Homework - your employees so you will need to...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 5 Homework – Database Processing Enter your answers to the questions below in a word processor. Then copy your answers into the appropriate web page accessed from the Course Assignments, Homework, Concept Homework links. Bring your printout to class for discussion and save it until you see your grade in OPE. Identify whether you should use a spreadsheet or a database to meet each of the following needs and explain why your selection is the better application. 1. You run a small business. You need a system that can produce one report your administrative assistant can use to get the information needed to write paychecks and file quarterly taxes. Spreadsheet would be a better application because all you need is one report or spreadsheet to supply all of the information you need. 2. You run a small business. You need a system that can produce paychecks to give to employees and quarterly tax forms to send to the IRS. Database because you need more than one table to produce all of this information, and it will be different for all
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: your employees so you will need to produce different tables for all of them. Refer to the ERD below to answer the next set of questions. ID F i r s t N a m e L a s t N a m e D e p a r t m e n t E m p l o y e d S i n c e H o u r l y W a g e E m p l o y e e C h e c k N u m b e r C h e c k D a t e ID H o u r s W o r k e d N e t P a y P a y c h e c k 3. What is the primary key of each entity? Employee and Paycheck 4. What is the foreign key of each entity? Last name connects to check date and ID 5. How many paycheck records can an employee record be related to? 5 6. How many employee records can a paycheck record be related to? 6 7. When do we count a person as an employee? The day they start working or the day their first paycheck is produced? The day they start working because that is when they are providing a service for your company and helping your company create revenue....
View Full Document

Page1 / 2

Chapter 05 Homework - your employees so you will need to...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online