Question 2 [10 marks] Following on your job in modelling the employee assignments from the previous...

   

Transcribed Image Text:

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. 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.

Answer rating: 100% (QA)

Question In the above scenario the main three entities may be 1 Empl... View the full answer