This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full 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