A potential key exists for a composite primary key's property. How do you feel about this news?

A candidate key is a characteristic that is part of a composite primary key.

What is a primary key?

. Students(stulD, lastName, firstName, major, credits) Faculty (facID, name, deptName, rank) • Classes(classNumber, facID, schedule, room) • Enrolls(stulD, classNumber, grade) The primary keys are underlined. The referential integrity constraints are as follows: . the column facID of relation Classes that references table Faculty, . the column stulD of relation Enrolls that references table Students, and the column classNumber of relation Enrolls that references table Classes. The following query is intended to retrieve the number of all classes taught by John Smith in the CST department. However, this query does not work properly. There are at least two faculty members who share the name, John Smith. Briefly explain and show the corrected SQL query_ why. SELECT classNumber FROM Classes WHERE facID= (SELECT facID FROM Faculty WHERE name='John Smith' AND deptName='CST');