25 pts You've been assigned to do an IT audit on the Johnson Company's database. After interviewing the CEO, CFO and end-user employees, you have developed the following business rules: 1. The company is divided into several branches, each of which has a specific city as well as its own assets that the company keeps track of. For each branch, Johnson Company tracks a unique branch identifier (Branchid) as well as the assets and city. The company employees are assigned to jobs, and can work multiple jobs at a time. For their employees, outside of an assigned employee identification number (EmplD), they keep track of their names (they had a very poor database designer and the Name is only one field!), addresses, their HireDate and the id of their manager (mgrID) - managers are also employees. 3. At the time of Assignment, the assignDate is tracked. 4. Each branch can have multiple jobs occurring, and multiple employees assigned to those jobs. From the business rules, you draw the following ERD: B Define Aas Branch with keys and attributes. Write it like it would look in a schema Instead of underlines put PK or FK SF Define B as Job with keys and attributes. Write it like it would look in a schema. Instead of underlines, put PK or FK. Define C as Work with keys and attributes. Write it like it would look in a schema. Instead of underlines, put PK or FK Define D as Employee with keys and attributes. Write it like it would look in a schema. Instead of underlines, put PK or FK Define E-one word for what is missing from the diagram. 25 pts You've been assigned to do an IT audit on the Johnson Company's database. After interviewing the CEO, CFO and end-user employees, you have developed the following business rules: 1. The company is divided into several branches, each of which has a specific city as well as its own assets that the company keeps track of. For each branch, Johnson Company tracks a unique branch identifier (Branchid) as well as the assets and city. The company employees are assigned to jobs, and can work multiple jobs at a time. For their employees, outside of an assigned employee identification number (EmplD), they keep track of their names (they had a very poor database designer and the Name is only one field!), addresses, their HireDate and the id of their manager (mgrID) - managers are also employees. 3. At the time of Assignment, the assignDate is tracked. 4. Each branch can have multiple jobs occurring, and multiple employees assigned to those jobs. From the business rules, you draw the following ERD: B Define Aas Branch with keys and attributes. Write it like it would look in a schema Instead of underlines put PK or FK SF Define B as Job with keys and attributes. Write it like it would look in a schema. Instead of underlines, put PK or FK. Define C as Work with keys and attributes. Write it like it would look in a schema. Instead of underlines, put PK or FK Define D as Employee with keys and attributes. Write it like it would look in a schema. Instead of underlines, put PK or FK Define E-one word for what is missing from the diagram