Specify Primary Key for each table below, also specify foreign keys, if any. For each foreign key, please indicate that foreign key references to which table.

S SNO SNAME STATUS CITY SPJ SNO PNO JNO QTY 20 S1 $2 S3 S4 S5 Smith Jones Blake Clark Adams 10 30 20 30 London Paris Paris London Athens P1 P1 P3 P3 P3 P3 J1 J4 J1 J2 J3 J4 J5 J6 J7 P ? PNO PNAME COLOR WEIGHT CITY J1 P1 P2 P3 P4 P5 P6 Nut Bolt Screw Screw Cog Red Green Blue Red Blue Red 12.0 17.0 17.0 14.0 12.0 19.0 London Paris Rome London Paris London S1 Si S2 S2 S2 S2 S2 S2 S2 S2 S3 S3 54 S4 S5 S5 S5 S5 S5. 55 S5 S5 SS S5 P3 P3 P5 P3 P4 P6 P6 P2 P2 P5 P5 P6 P1 P3 P4 P5 P6 200 700 400 200 200 500 600 400 800 100 200 500 300 300 200 100 500 100 200 100 200 800 400 500 a J2 J4 J5 J7 J2 J4 J4 J4 J4 J4 JNO JNAME CITY J2 J3 J4 J5 J6 J7 Sorter Display OCR Console RAID EDS Tape Paris Rome Athens Athens London Oslo London