- What is the primary key for the students table?
- What are the two foreign keys in the takes_course table?
- How are the foreign and primary keys related in the table?
- They link together different tables so they have a relationship. This is seen with the primary of students, id, and the primary key from courses, classid, being used in classes_taken as forigne keys to link the tables together.
- What is the schema of the courses table?
- classid, name, course_num, cred_hour