What should be the primary key in these two tables? (SQL)?

Primary keys should be (must be) unique. So it's course_no in the courses table, and fac_no in the faculty table. (The latter is given by its use in the course table.) think about all the otheer variables; they could all have more than one occurence -- for example course_room would be the same for every course held in that room.