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. Assignment No Date Employee No Employee Section Section N Building Start End Supervisor No Building N 8 22/08/2013 2111 B. Johns G1 Canteen G Willis 12h00 19h00 2321 2 9 23/08/2013 2111 B. Johns F3 Office Flora 11h00 14h00 2321 3 10 23/08/2013 2121 M. Janes G2 Copiers G Willis 08h00 13h00 2215 2 11 24/08/2013 2215 K. Joes G1 Canteen G Willis 13h00 16h30 2215 2 12 25/08/2013 2215 K. Joes F3 Office Flora 09h00 12h00 2215 3 13 25/08/2013 2121 M. Janes K2 Bathroom Komanche 13h00 14h00 2215 5 14 26/08/2013 2111 B. Johns F5 Foyer Flora 16h00 18h00 2321 3 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.

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. Assignment No Date Employee No Employee Section Section N Building Start End Supervisor No Building N 8 22/08/2013 2111 B. Johns G1 Canteen G Willis 12h00 19h00 2321 2 9 23/08/2013 2111 B. Johns F3 Office Flora 11h00 14h00 2321 3 10 23/08/2013 2121 M. Janes G2 Copiers G Willis 08h00 13h00 2215 2 11 24/08/2013 2215 K. Joes G1 Canteen G Willis 13h00 16h30 2215 2 12 25/08/2013 2215 K. Joes F3 Office Flora 09h00 12h00 2215 3 13 25/08/2013 2121 M. Janes K2 Bathroom Komanche 13h00 14h00 2215 5 14 26/08/2013 2111 B. Johns F5 Foyer Flora 16h00 18h00 2321 3 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.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

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.

Assignment No	Date	Employee No	Employee	Section	Section N	Building	Start	End	Supervisor No	Building N
8	22/08/2013	2111	B. Johns	G1	Canteen	G Willis	12h00	19h00	2321	2
9	23/08/2013	2111	B. Johns	F3	Office	Flora	11h00	14h00	2321	3
10	23/08/2013	2121	M. Janes	G2	Copiers	G Willis	08h00	13h00	2215	2
11	24/08/2013	2215	K. Joes	G1	Canteen	G Willis	13h00	16h30	2215	2
12	25/08/2013	2215	K. Joes	F3	Office	Flora	09h00	12h00	2215	3
13	25/08/2013	2121	M. Janes	K2	Bathroom	Komanche	13h00	14h00	2215	5
14	26/08/2013	2111	B. Johns	F5	Foyer	Flora	16h00	18h00	2321	3

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.

Expert Solution

Step by step

Solved in 4 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.