Question

Refer to the illustration below to answer the following questions. Use the drop-down menus to make your selections. Left: A table titled Table 1: Students with entries Student I D Number, Name, Grade. Right: A table titled Table 2: Courses with entries Course I D Number, Course Name, Student I D Number. What is the primary key in Table 1? What is the primary key in Table 2? What does Student ID Number refer to in Table 2? What forms the link between Table 1 and Table 2?

Answer 1

Refer to the illustration below to answer the following questions. Use the drop-down menus to make your selections.

Left: A table titled Table 1: Students with entries Student I D Number, Name, Grade. Right: A table titled Table 2: Courses with entries Course I D Number, Course Name, Student I D Number.

What is the primary key in Table 1?

✔ Student ID Number

What is the primary key in Table 2?

✔ Course ID Number

What does Student ID Number refer to in Table 2?

✔ the foreign key

What forms the link between Table 1 and Table 2?

✔ Student ID Number

Step-by-step explanation: