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)

Question

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)

Quizplus · Accepted Answer

The Answer of 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)

Student Table Course Table