Question: Question 9 COURSE subj code course number course name course description credits For the COURSE entity, the following is known about its attributes ( none
Question
COURSE
subj code
course number
course name
course description
credits
For the COURSE entity, the following is known about its attributes none of which are NULL:
subj code is common for multiple courses for eg there are many courses with subj code MIS
course numbers are only unique for a given subj code for eg there can be only one MIS and only one ACCT
no two courses can share course names to avoid confusion
course descriptions are always unique
credits for courses are allowed to be only one the following values:
Based on the above information, select all choices that qualify as candidate keys.
course number
subj code and course number together
course description
subj code
credits
course name
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
