Search results

After speaking with the prof i was told we don't need to use SSN as a primary, apparently a lot of people where having the same problem i was. Thanks for the help though, got everything working after removing ssn as a primary

Alright so i read the link and am attempting to use index's(though we where never told about them in class). I created primary index's for the patient table and the operation table, though i am still getting the same error? I assume there is something i am not understand about index's...

I have to create various tables using queries. The code for the first 2 tables is as follows CREATE TABLE patient( SSN char(9) NOT NULL, PID char(8) NOT NULL, Address char(60) NOT NULL, BirthDate DATE NOT NULL, Gender char(1) NOT NULL, Name char(20) NOT NULL, BloodType VARCHAR(2) NOT NULL...