Question 2 [10 marks] Following on your job in modelling the employee assignments from the previous practical, you've now obtained the following business rules: One Employee supervises Many Employees, and possibly none, and a max of 20. One Employee is supervised by One Employee, and not none. One Employee takes on Many Assignments, and possibly none. One Assignment is taken on by One Employee, and not none. One Assignment takes place in One Section, and not none. One Section appears in Many Assignments, and possibly none. One Section belongs to One Building, and not none. One Building has Many Sections, and possibly none, and a max of 20. You have also been given a small sample of their records, in case this may prove useful. It is below. 8 Assignment 9 10 11 12 13 14 No Date Employee ON 22/08/2013 2111 23/08/2013 2111 23/08/2013 2121 24/08/2013 2215 25/08/2013 2215 25/08/2013 2121 26/08/2013 2111 Employee B. Johns B. Johns M. Janes K. Joes K. Joes M. Janes B. Johns Section Section N G1 Canteen F3 Office G2 Copiers G1 Canteen F3 Office K2 Bathroom F5 Foyer Building G Willis Flora G Willis G Willis Flora Komanche Flora Start End Supervisor No 12h00 19h00 2321 11h00 14h00 2321 08h00 13h00 2215 13h00 16h30 2215 09h00 12h00 13h00 14h00 16h00 18h00 2215 2215 2321 2 3 2 2 3 5 Building N In case you need extra info: Section is a kind of code given to a section in a specific building. Each section has a completely unique code (across all buildings) e.g. F3 only exists in building "Flora", not any other building. Section N is short for "section name"; it's the name of the section Each employee has a specific supervisor, regardless of where/what they are assigned. Building N is a unique number given to a specific building. Supervisor No is actually just the Employee No of the Employee that supervises a given Employee Use these business rules to draw a nice neat ERD. Remember that if you encounter any Many- to-Many relationships in the business rules, you will need to first break down and resolve these relationships into a set of business rules in which a bridge entity is created as discussed in class. Clearly show your new business rules if this should be the case.