Suppliers & Parts database · 5 questions · 25 points
Enter your name to begin.
| s — suppliers | |
| s#pk | text |
| sname | text |
| status | int |
| city | text |
| p — parts | |
| p#pk | text |
| pname | text |
| color | text |
| weight | int |
| city | text |
| sp — shipments | |
| s#fk | text |
| p#fk | text |
| qty | int |
| s# | sname | st | city |
|---|---|---|---|
| S1 | Smith | 20 | London |
| S2 | Jones | 10 | Paris |
| S3 | Blake | 30 | Paris |
| S4 | Clark | 20 | London |
| S5 | Adams | 30 | Athens |
| p# | pname | color | wt | 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 |
| s# | p# | qty |
|---|---|---|
| S1 | P1 | 300 |
| S1 | P2 | 200 |
| S1 | P3 | 400 |
| S1 | P4 | 200 |
| S1 | P5 | 100 |
| S1 | P6 | 100 |
| S2 | P1 | 300 |
| S2 | P2 | 400 |
| S3 | P2 | 200 |
| S4 | P2 | 200 |
| S4 | P4 | 300 |
| S4 | P5 | 400 |