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

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Applications

Section5.7: Information Systems @ Work: Brandwatch: Applying Business Intelligence To Social Media Data To Make Advertising Decisions

Problem 1CTQ

See similar textbooks