(a) Structure the following data elements into a relational database structure. Name the primary key(s), foreign key(s), and other attributes (excluding primary and foreign keys) for each table you define (6 mat Hint: If you don't think an answer blank should have anything in it then just put a dash -- Employee Number Employee Name Department Phone No. Manager Name Pay Date Pay Rate Number Employee Address Ordinary time rate Department Location Hours Worked Overtime rate A B DPrimary Keys: Foreign Keys: Other Attributes: Employee employee address Employee Number Department: Department Phone No Payroll-Employee: Payroll: (b) Indicate which of these table names (Employee, Department, Payroll, Payroll-Employee) should appear in each of the squares in the Entity Relationship Map e.g. Student - A [4 marks) Employee: Department