Database Could you help me to solve the problem? Thank you very much! Which of t

Question

Database
Could you help me to solve the problem? Thank you very much! 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? (b) CLASS and DEPARTMENT (a) COURSE and DEPARTMENT (d) none of above (c) CLASS and ENROLLMENT 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 above

Explanation / Answer

4. Course has Department-ID as Foreign key
class has Course# as Foreign key
Department does not has any foreign key
So the answer is C

5. A Strong relationship can be shown only when two tables have common columns among them.
COURSE and DEPARTMENT has Department-ID as common one
So the answer will be a

6. In the class table Grade is a multi-valued attribute as it can be any value any number of times.

Please check the code. If you have any doubts comment below and i am happy to help :)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.