Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the course registration system at School of Management, Loyola University. Each department offers one or more courses and assigns only one of its instructors

Consider the course registration system at School of Management, Loyola University. Each department offers one or more courses and assigns only one of its instructors to teach each course. Each course is offered by only one department. The system shows the course number, name, and meeting time for each course, and the department number and name for each department. Each student can register for one or more courses, and at least one student is registered for each course. Also, each professor can teach one or more courses and works for only one department at SoM. However, if a professor is on the sabbatical leave, he/she will not teach any courses. For students, the registration system keeps track of the students ID, first name, last name, and email address, and for professors, the system keeps track of the professors ID, first name, last name, office location, and phone number.

What are the entities and the attributes of each entity?

Draw the entity-relationship (E-R) diagram in diagrams.net. Show the primary keys (PKs) as well as min/max cardinalities.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management

Authors: Stephen P. Robbins, Mary A. Coulter

14th Global Edition

978-0134527604

More Books

Students also viewed these General Management questions