Answer questions 1-5

JOB PLAN Job Code Description Plan Code Description Clerical Technical Managerial Custodial Term Life Insurance Stock Purchase Plan Long-Term Disability Dental Insurance BENEFIT EMPLOYEE Emp Code Plan Code Emp Code Last Name Jb Code 15 15 16 17 17 17 20 15 16 17 20 Rudell McDade Ruellardo Smith Smith 4 1. Identify the primary and foreign keys for each of the tables above. Answer "none" if a 2. Do the tables above have entity integrity? If not, explain why and how you could fix 3. Do the tables above have referential integrity? If not, explain why and how you could table has no foreign key the tables so that they do fix the tables so that they do. Note: If a table has no foreign key columns, referential integrity is not applicable; answer with "N/A - no foreign keys" for tables like that Create business rules that accurately and completely describe the entities represented by the tables. Using the primary and foreign keys in the tables, determine how they are related and include those relationships within your business rules. Your business rules should not mention attributes or contain any specific examples 4. 5. Create a Conceptual Model ERD using your the business rules