THe CULu, TransactionID, is a foreign key D) The column, ustomerID, in the Custo

Question

THe CULu, TransactionID, is a foreign key D) The column, ustomerID, in the Customer-Service table is a forein key. Name Eric Gina Grade ID 1001 1002 1003 Dallas San Antonio Seattle San Antonio Eric Lauren 1004 Kathy 1005 Houston 7. Using the Student table, as shown below, to answer question 7 to 10 7. Which column is a primary key of the following table (Columns in the table (Points : 1) include Name, ID, Grade, and Hometown)? O A) Name B) Grade © D) Hometown 8. 8. which sQL statement can find student Lauren's ID, grade, and hometown? (Reminder: Table name is Student) (Points: 1) 0 A) select ID, Grade, Hometown from Student "Lauren B) select ID, Grade, Hometown from Student where Name

Explanation / Answer

Answer 7 ) In the Student table, ID is unique (in each row,Value of ID is unique ) while other column's values are repeating again ( i.e 'Eric' is repeating in Name column,,grade - 'A' and 'C' is repeating in the Grade column,,and 'San Antonio' is repeating in Hometown column),,and that's why ID column is a primary key.

So, option (c) is correct.

Answer 8 ) select ID,Grade, Hometown from Student where Name='Lauren' ;

Hence, option (b) is correct.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.