This test concerns database design, including both the logical design via the Entity Relationship (E - R) model and the physical model via relational database tables. The subject of the model is the registration of students in college classes, and there may be multiple classes for each course. The college model should include: courses (for example the CBU catalog), the current classes (or course-sections) given for courses (for example the CBU schedule for a term), the faculty qualified to teach courses, the scheduling of classes (to buildings/rooms, times, and faculty members), the assignment of faculty to students for advising (1 advisor per student), and the scheduling of students to classes. For unique identifiers you can use the following abbreviations: SID Student ID CID Course ID (ie MIS 471, …) SEC Course Section (ie A, B, C, …) BID Building ID (ie BU, BH, K, …) RID Room Number FID Faculty ID TID Timeslot ID (ie TR 9:30, MWF 8am, …) CRN Course Record Number (an auto key for each class) It is suggested that you draw the full E-R diagram before answering any questions. What are the foreign key(s) of the student table ? Group of answer choices FID RID None of these CID TID No hand written and fast answer with explanation
This test concerns
For unique identifiers you can use the following abbreviations:
SID Student ID
CID Course ID (ie MIS 471, …)
SEC Course Section (ie A, B, C, …)
BID Building ID (ie BU, BH, K, …)
RID Room Number
FID Faculty ID
TID Timeslot ID (ie TR 9:30, MWF 8am, …)
CRN Course Record Number (an auto key for each class)
It is suggested that you draw the full E-R diagram before answering any questions.
What are the foreign key(s) of the student table ?
Group of answer choices
FID
RID
None of these
CID
TID
No hand written and fast answer with explanation
Step by step
Solved in 3 steps
