Hey guys, I'm having an issue understanding how to write a table that uses an id and another id which both have dual keys. What I mean by dual keys is they use primary key and foreign keys.
Example:
Table Name = Enrollment
Column Name = Sid, Csecid, Grade
Data Type = NUMBER, NUMBER, NUMBER
Lgth = w/e,w/e,w/e
PK = Sid, Csecid
FK = Sid, Csecid
Check = A,B,C,D,F,I
I'm having issues writing it out in SQL code such as Create Table Enrollment... etc