(Student-ID, First-Name, Last-Name) (Courset, Course-Name, Department-ID) (Class
ID: 3755908 • Letter: #
Question
(Student-ID, First-Name, Last-Name) (Courset, Course-Name, Department-ID) (Class-Code, Course#, Section # , Grade) STUDENT COURSE CASS DEPARTMENT (Department-ID, Department-Name) ENROLIMENT (Student-ID, Class-Code, Grade) Please review the list of tables given above and read the notes above the list of tables. Then answer the following question: What type of relationship is between CLASS and ENROLLMENT tables? (a) one-many (b) one-one (c) many-many (d) none of the above Please review the list of tables given above and read the notes above the list of tables. Then answer the following question: What type of relationship is between DEPARTMENT and ENROLLMENT tables? (a) one-many (b) one-one (c) many-many (d) none of the above Please read the notes written just above the tables listing and then answer the following question: What type of relationship is between STUDENT and ENROLLMENT tables? (a) one-many (b) one-one (c) many-many (d) none of the above Which of the following tables has no foreign key? If all have FK, select d (a) course (b) class (e) department (d) all of these three tables have foreign key columns Which of the following pairs of tables has a strong or identifying relationship? (a) COURSE and DEPARTMENT (b) CLASS and DEPARTMENT (c) CLASS and ENROLLMENT (d) none of above Which of the following is a multi-valued attribute in CLASS table? (a) Class-Code (b) Course# (c) Section# (d) Grade (e) none of the aboveExplanation / Answer
Dear Student ,
As per the requirement submitted above , kindly find the below solution.
Question 1:
Answer : (a) one- many
Explanation : Course and Enrollment is having one to many relationship because primary key of Course is Class-Code is foreign key in the table Enrollment. Also one class can have many enrollment for the students and many enrollments can be done by one class.Hence the answer.
*************************************
Question 2:
Answer : (d) None of the above
Explanation : As given schema in the question there is no direct relationship between department and enrollment but can have many to one relationship because many enrollments can be from one department.
**************************************
Question 3:
Answer : (b) one-one
Explanation :Table Student and Enrollment is having one to one relationship because Student-ID which is primary key in the table Student is foreign key in the table enrollment also one student can have one enrollment for one course and also one enrollment could be doneby one student for each course,
*******************************************
Question 4:
Answer :(c) department
Explanation : Here in case of table Department only two columns are there one is Department-ID which is primary key and another is Department-Name which stores department name of each department.Also course table is having course primary key and class table is having class-code as primary key.
***********************************
Question 6:
Answer : (c) Section#
Explanation : Because for one course can have multiple sections for each student hence Section# is mutlivalued attributes in Class table.
NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.