FoductID, Description, Cost); SUPPLIER (SupplierID, ContactName, Phone Number, ProductID) O d. PRODUCT (ProductID, Description, Cost); SUPPLIER (SupplierID, ContactName, PhoneNumber) Question 23 Not yet answered Marked out of 5.00 Flag question Given the relations, STUDENT (SID, StudentName, Major, AdvisorID), ADVISOR (AdvisorID, AdvisorName, Office, Phone), such that each student is assigned to one advisor, which of the following is true? O a. Phone is a candidate key. O b. Major is a primary key. O c. SID is both a primary key and a foreign key. d. AdvisorName is a determinant. O e. AdvisorID is a foreign key. Question 24 Not yet answered Marked out of 5.00 Given the tables, LECTURER (LecID, LecName), COURSE (CourseNo, CourseTitle), If the relationship between LECTURER and COURSE is 1:1, which of the following would represent the correct placement of foreign keys? O a. LECTURER (LecID, LecName); COURSE (CourseNo, CourseTitle)