S
Stargazer980
OK I have four table and this is how they are laid out:
Students Table
WID (PRIMARY KEY)
LAST NAME
FIRST NAME
CLASS
GRADES TABLE
WID (COMPSITE KEY)
CRN (COMPSITE KEY)
GRADE
COURSES
CRN (PRIMARY KEY)
TITLE
CREDIT HOURS
TEACHER E-MAIL
TEACHERS
LAST NAME
FIRST NAME
TEACHER E-MAIL (PRIMARY KEY)
RANK
DEPARTMENT
I can get a relationship between all but I am unable to enforce referential
integrity between all and the book I am using to learn this program says I
can do it. Unfortunately the book does not detail this process step by step.
Any help would be greatly appreciated.
Students Table
WID (PRIMARY KEY)
LAST NAME
FIRST NAME
CLASS
GRADES TABLE
WID (COMPSITE KEY)
CRN (COMPSITE KEY)
GRADE
COURSES
CRN (PRIMARY KEY)
TITLE
CREDIT HOURS
TEACHER E-MAIL
TEACHERS
LAST NAME
FIRST NAME
TEACHER E-MAIL (PRIMARY KEY)
RANK
DEPARTMENT
I can get a relationship between all but I am unable to enforce referential
integrity between all and the book I am using to learn this program says I
can do it. Unfortunately the book does not detail this process step by step.
Any help would be greatly appreciated.