Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started