use a program to draw your eer diagram. please don't copy your answer from outside sources. if you don't know how to solve, please skip. 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). 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). 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

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
icon
Related questions
Question

don't COPY from outside sources. dont use AI

use a program to draw your eer diagram. please don't copy your answer from outside sources. if you don't know how
to solve, please skip.
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).
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).
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.
1
Transcribed Image Text:use a program to draw your eer diagram. please don't copy your answer from outside sources. if you don't know how to solve, please skip. 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). 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). 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. 1
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 1 images

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