Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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, Building, 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 entities 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 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

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, Building, 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 entities 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 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

Database System Concepts
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
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, Building, 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 entities 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 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 entities referencing are "employee".
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, Building, 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 entities 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 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 entities referencing are "employee".
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Enhanced ER Model
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS