Draw an Enhanced Entity Relationship (EER) Diagram for the following specifications. Each campus has a unique ID, name, address, city, state, country, and URL. A campus can have many colleges. ● ● ● ● ● ● ● Each college has a unique id, name, phone, email, and URL. A campus can have many units. Each unit has a unique id within the campus, name, phone, and type (academic or non-academic). An academic unit is associated to a college. A non-academic unit has a job description. A college may offer courses. Each course has code, number, credit, and title. Each course is uniquely identified by the code and number together. Each user of the system has a unique id, first name, last name, email, phone. A user may have several phones. A user is a faculty, student, or a combination. Faculty has a rank. Student can be undergraduate or graduate. A tutor is a user hired by a college and has a pay rate (dollars per hour) and a list of courses he/she can be responsible for. A tutor can tutor in more than one college. A college can have many tutors. A supervisor is a faculty member assigned to supervise tutors. A supervisor has office hours for supervising. Each tutor is supervised by one supervisor. A supervisor can supervise many tutors. An on-call is initiated by a faculty to ask a tutor to help in one specific course. The on- call has a unique id, location, date, start time, end time, task type (classroom assistance, lab assistance, or exam monitoring), and status (assigned, missed, or attended). Identify the entities, attributes, and relationships for the above set of requirements. For entities: identify the strong and weak entities. For attributes: identify key, multi-valued, composite, and derived attributes. For relationships: use (min, max) constraints List any assumptions you make. ● An appointment between a tutor and a student could be scheduled outside of the classroom and lab. An appointment has a unique id, location, date, start time, end time, list of courses, and status (scheduled, canceled, or attended).
Draw an Enhanced Entity Relationship (EER) Diagram for the following specifications. Each campus has a unique ID, name, address, city, state, country, and URL. A campus can have many colleges. ● ● ● ● ● ● ● Each college has a unique id, name, phone, email, and URL. A campus can have many units. Each unit has a unique id within the campus, name, phone, and type (academic or non-academic). An academic unit is associated to a college. A non-academic unit has a job description. A college may offer courses. Each course has code, number, credit, and title. Each course is uniquely identified by the code and number together. Each user of the system has a unique id, first name, last name, email, phone. A user may have several phones. A user is a faculty, student, or a combination. Faculty has a rank. Student can be undergraduate or graduate. A tutor is a user hired by a college and has a pay rate (dollars per hour) and a list of courses he/she can be responsible for. A tutor can tutor in more than one college. A college can have many tutors. A supervisor is a faculty member assigned to supervise tutors. A supervisor has office hours for supervising. Each tutor is supervised by one supervisor. A supervisor can supervise many tutors. An on-call is initiated by a faculty to ask a tutor to help in one specific course. The on- call has a unique id, location, date, start time, end time, task type (classroom assistance, lab assistance, or exam monitoring), and status (assigned, missed, or attended). Identify the entities, attributes, and relationships for the above set of requirements. For entities: identify the strong and weak entities. For attributes: identify key, multi-valued, composite, and derived attributes. For relationships: use (min, max) constraints List any assumptions you make. ● An appointment between a tutor and a student could be scheduled outside of the classroom and lab. An appointment has a unique id, location, date, start time, end time, list of courses, and status (scheduled, canceled, or attended).
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...
Related questions
Question
use a program to draw your eer diagram
Transcribed Image Text:Draw an Enhanced Entity Relationship (EER) Diagram for the following specifications.
Each campus has a unique ID, name, address, city, state, country, and URL. A campus
can have many colleges.
●
●
●
●
●
●
●
Each college has a unique id, name, phone, email, and URL.
A campus can have many units. Each unit has a unique id within the campus, name,
phone, and type (academic or non-academic). An academic unit is associated to a college.
A non-academic unit has a job description.
A college may offer courses. Each course has code, number, credit, and title. Each course
is uniquely identified by the code and number together.
Each user of the system has a unique id, first name, last name, email, phone. A user may
have several phones.
A user is a faculty, student, or a combination. Faculty has a rank. Student can be
undergraduate or graduate.
A tutor is a user hired by a college and has a pay rate (dollars per hour) and a list of
courses he/she can be responsible for. A tutor can tutor in more than one college. A
college can have many tutors.
A supervisor is a faculty member assigned to supervise tutors. A supervisor has office
hours for supervising. Each tutor is supervised by one supervisor. A supervisor can
supervise many tutors.
An on-call is initiated by a faculty to ask a tutor to help in one specific course. The on-
call has a unique id, location, date, start time, end time, task type (classroom assistance,
lab assistance, or exam monitoring), and status (assigned, missed, or attended).
Identify the entities, attributes, and relationships for the above set of requirements.
For entities: identify the strong and weak entities.
For attributes: identify key, multi-valued, composite, and derived attributes.
For relationships: use (min, max) constraints
List any assumptions you make.
●
An appointment between a tutor and a student could be scheduled outside of the
classroom and lab. An appointment has a unique id, location, date, start time, end time,
list of courses, and status (scheduled, canceled, or attended).
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 1 images
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY