Question: 1 (40 Points) SCOPE: Designing Payroll System for Southwest Auto Services Southwest Auto services operates in south west region of US and it has 24 service center in various locations. HR department wants you to design data model for their payroll system. Brief overview of business requirement. Company has six categories of jobs and each has different pay structure. Company provides health plan for employees and dependents Salary should be paid as per state's and county rules and regulation. Extra hours should be stored and paid as per regulations of the state. Employee Identification should verified before on-boarding the employees. Data Must be stored for 7 years even employee leaves the company. Employee personal information, hours worked and health plan details should be collected. Expected Results in Assignment. Minimum 6 page of document contains following Section 1: Brief description of the problem. (What is being asked and its purpose) Section 2: Business Rules, Come up with minimum of 25 business rules/Questions. Section 3: Conceptual Design as per Chen's Model Section 4: Logical Model - ERD diagram with minimum of 10 entities and its relationship Section 5: Physical model script developed for MySQL (Use MySQL workbench) Each Entity should satisfy at least 2NF Each table should have primary key Relationship should have foreign key