contestada

For each of the following entities in a college, indicate whether (under typical circumstances) there is a one-to-one, one-to-many or many-to-many relationship.
STUDENT and COURSE (for example Joe Smith and COP3703, would be MANY to ONE since many students can sign up for COP3703)

i. BOOK and BOOK COPY
ii. COURSE and COURSE-SECTION
iii. COURSE-SECTION and ROOM
iv. INSTRUCTOR and COURSE
v. ROOM and INSTRUCTOR

Respuesta :

Answer:

i. BOOK and BOOK COPY :  one to many

ii. COURSE and COURSE-SECTION : one to many

iii. COURSE-SECTION and ROOM : many to many

iv. INSTRUCTOR and COURSE : many to many

v. ROOM and INSTRUCTOR: many to many

Explanation:

i. BOOK and BOOK COPY : one to many because a book can have many copies

ii. COURSE and COURSE-SECTION : one to many because a course has many section as many student can signup for course and in one section maximum 50 student allowed maybe then there can more than one section if student exceeds 50.

iii. COURSE-SECTION and ROOM : many to many course section can be taught in different rooms on different days and also a room can be used for more than one course

iv. INSTRUCTOR and COURSE : many to many because an instructor can teach many courses and a course may be has many section and each section is taught by different instructor

v. ROOM and INSTRUCTOR: many to many because a room can host many instructor and an instructor can teach at different rooms at different time.

Otras preguntas

Q&A Education