Computer Science Assignment - SQL

suppliers sno sname status city S1 Smith 20 London S2 Jones 10 Paris S3 Blake 30 Paris S4 Clark 20 London S5 Adams 30 Athens

parts pno pname color weight city P1 Nut Red 12 London P2 Bolt Green 17 Paris P3 Screw Blue 17 Rome P4 Screw Red 14 London P5 Cam Blue 12 Paris P6 Cog Red 19 London

jobs jno jname city J1 Sorter Paris J2 Punch Rome J3 Reader Athens J4 Console Athens J5 Collator London J6 Terminal Oslo J7 Tape London

spj sno pno jno shipDate qty S1 P1 J1 3/3/1999 200 S1 P1 J4 4/4/1988 700 S2 P3 J1 6/6/1988 100 S2 P3 J2 8/8/1999 200 S2 P3 J3 7/7/1977 200 S2 P3 J4 8/9/1999 500 S2 P3 J5 8/7/1999 600 S2 P3 J6 8/7/1998 400 S2 P3 J7 8/8/1988 800 S2 P5 J2 9/9/1999 100 S3 P3 J1 9/9/1999 200 S3 P4 J2 9/8/1999 500 S4 P6 J3 9/9/1999 400 S4 P6 J7 9/8/1988 300 S5 P2 J2 9/9/1999 200 S5 P2 J4 8/8/1988 100 S5 P5 J5 7/8/1999 500 S5 P5 J7 8/8/1999 100 S5 P6 J2 7/8/1999 200 S5 P1 J4 6/8/1999 100 S5 P3 J4 6/6/2000 200 S5 P4 J4 9/7/2000 800 S5 P5 J4 7/7/1999 400 S5 P6 J4 7/8/2000 500

SPJ Data Sheet