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

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 5MC

See similar textbooks