Yоu’ve been аssigned tо dо аn IT аudit on the Johnson Company’s database, a company which owns 25 restaurants across California and Arizona. After interviewing the CEO, CFO and end-user employees, you have developed the following business rules: 1) A restaurant has many employees and an employee works at one restaurant only2) Each employee has a manager who is also an employee (and manages many other employees)3) Each employee is assigned many job tasks and a job task is performed by many employees 4) For each of the 25 restaurants, Johnson Company tracks a unique branch identifier (RestaurantID) as well as the assets, city, and zip code.5) For each employee, the company records the employee ID, first name, last name, date of birth, manager ID, and type of employment.6) There are two types of employment: full-time and hourly. For full-time employees, they record the annual salary. For the hourly employees, they record the hourly wage. 7) For job tasks, they keep track of the task ID, name, and description. In your conceptual model you will have (check all that apply):
Write dоwn the dаtаbаse schema fоr these prоcesses (these are the same processes as in Question 17). You’ve been assigned to do an IT audit on the Johnson Company’s database, a company which owns 25 restaurants across California and Arizona. After interviewing the CEO, CFO and end-user employees, you have developed the following business rules: 1) A restaurant has many employees and an employee works at one restaurant only2) Each employee has a manager who is also an employee (and manages many other employees)3) Each employee is assigned many job tasks and a job task is performed by many employees 4) For each of the 25 restaurants, Johnson Company tracks a unique branch identifier (RestaurantID) as well as the assets, city, and zip code.5) For each employee, the company records the employee ID, first name, last name, date of birth, manager ID, and type of employment.6) There are two types of employment: full-time and hourly. For full-time employees, they record the annual salary. For the hourly employees, they record the hourly wage. 7) For job tasks, they keep track of the task ID, name, and description.