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
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
Related questions
Question
don't COPY from outside sources. dont use
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 1 images
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.Recommended textbooks for you
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education