Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
You've Identified the following entities: Assignment, Employee, Section, Bullding. Job. No others. Use the information below to Inter which entities have relationships with each other, as well as the types of those relationships, and constraints if any. All that you should submit is a set of the relevant business rules. Once again, remember that entitles don't necessarily directly connect, unless the information collected specifies that they are connected. 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

You've Identified the following entities: Assignment, Employee, Section, Bullding. Job. No others. Use the information below to Inter which entities have relationships with each other, as well as the types of those relationships, and constraints if any. All that you should submit is a set of the relevant business rules. Once again, remember that entitles don't necessarily directly connect, unless the information collected specifies that they are connected. 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

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
Below is a sample of an assignment roster of employees working in a company. An assignment Involves a specific job given to a specific employee, on a specific date and time, and in a specific section of a specific building. Very specific. You've Identified the following entities: Assignment, Employee, Section, Bullding. Job. No others. Use the information below to Infer which entities have relationships with each other, as well as the types of those relationships, and constraints if any. All that you should submit is a set of the relevant business rules. Once again, remember that entitles don't necessarily directly connect, unless the information collected specifies that they are connected. 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 • • • • MEO Each employee has a single 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 Hint: Since the Supervisor is actually just an Employee, the relationship Supervises" is a relationship between employee and another employee I.e. a business rule in which both entitles referencing are "employee". Employee ON 22/08/2013 2111 Johns 23/08/2013 2111 23/08/2013 2121 M 24/08/2013 2215 25/08/2013 2215 25/08/2013 2121 Employee 26/08/2013 2111 Johna Janes Joes Joes M. Janes 8. Johns Section Section N G1 Canteen Dun F5 Foyer G Willis Flore 12h00 19:00 21 F3 Office 11h00 14h00 33 02 Copiers 08h00 13h00 21 GWills G Willis G1 Canteen 13h00 16h30 72 F3 Office Flore 09h00 12h00 72 K2 Bathroom Komanche 13h00 14h00 21 Start Flora End Catego 16h00 18h00 55 gor Cleaning Maintenance Cleaning Moving Moving Cleaning Security Supervisor 2321 2321 2215 2215 2215 2215 2321 Building N 2 NNG 3 2 2 3 5 3
Transcribed Image Text:Below is a sample of an assignment roster of employees working in a company. An assignment Involves a specific job given to a specific employee, on a specific date and time, and in a specific section of a specific building. Very specific. You've Identified the following entities: Assignment, Employee, Section, Bullding. Job. No others. Use the information below to Infer which entities have relationships with each other, as well as the types of those relationships, and constraints if any. All that you should submit is a set of the relevant business rules. Once again, remember that entitles don't necessarily directly connect, unless the information collected specifies that they are connected. 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 • • • • MEO Each employee has a single 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 Hint: Since the Supervisor is actually just an Employee, the relationship Supervises" is a relationship between employee and another employee I.e. a business rule in which both entitles referencing are "employee". Employee ON 22/08/2013 2111 Johns 23/08/2013 2111 23/08/2013 2121 M 24/08/2013 2215 25/08/2013 2215 25/08/2013 2121 Employee 26/08/2013 2111 Johna Janes Joes Joes M. Janes 8. Johns Section Section N G1 Canteen Dun F5 Foyer G Willis Flore 12h00 19:00 21 F3 Office 11h00 14h00 33 02 Copiers 08h00 13h00 21 GWills G Willis G1 Canteen 13h00 16h30 72 F3 Office Flore 09h00 12h00 72 K2 Bathroom Komanche 13h00 14h00 21 Start Flora End Catego 16h00 18h00 55 gor Cleaning Maintenance Cleaning Moving Moving Cleaning Security Supervisor 2321 2321 2215 2215 2215 2215 2321 Building N 2 NNG 3 2 2 3 5 3
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

did not resolve the relationship between the entities(Building ,section ,Assignment ,Employee,Job)

eg Building and Section

1 Building has many Sections

1 Section is in only 1 Building

The relationship is : One-to-Many

Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS