Multiple Choice
Student Table
Course Table
The Course_ID in the student table is best described as:
-Examine the database tables in Q44.Given that the relationship between the student and the course is 1:1,which of the following statement is correct? (i) Only the Course_ID should be added to the student table (ii) Only the Student_ID should be added to the student table (iii) Course_ID should be added to the student table and Student_ID should be added to the course table.
A) Either (i) or (ii)
B) Both (i) and (ii)
C) Both (ii) and (iii)
D) Both (i) and (iii)
Correct Answer:
Verified
Correct Answer:
Verified
Q6: When all data are stored in a
Q7: Data redundancy:<br>A)can lead to a number of
Q8: In relational database,a connected set of fields
Q9: Data redundancy occurs when:<br>A)we keep data that
Q10: If data are captured and stored at
Q12: Data anomalies:<br>A)are inconsistencies or errors that exist
Q13: Which of the following is not a
Q14: Which of the following statement regarding normalisation
Q15: Data or facts that are processed in
Q16: An entity relationship diagram is a method