Return to Syllabus, Assignments, Menu.
Suppliers-Parts-Jobs-Shipments Database. Data in the spj.mdb database.
S (Suppliers) Go to parts, jobs, shipments.
|
sNo |
sName |
status |
city |
|
S1 |
Smith |
20 |
London |
|
S2 |
Jones |
10 |
Paris |
|
S3 |
Blake |
30 |
Paris |
|
S4 |
Clark |
20 |
London |
|
S5 |
Adams |
30 |
Athens |
P (Parts) Go suppliers, jobs, shipments.
|
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 |
J (Jobs or Projects) Go to suppliers, parts, shipments.
|
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 (Shipments) Suppliers ship parts to jobs. Go to suppliers, parts, jobs .
|
sNo |
pNo |
jNo |
qty |
|
S1 |
P1 |
J1 |
200 |
|
S1 |
P1 |
J4 |
700 |
|
S2 |
P3 |
J1 |
100 |
|
S2 |
P3 |
J2 |
200 |
|
S2 |
P3 |
J3 |
200 |
|
S2 |
P3 |
J4 |
500 |
|
S2 |
P3 |
J5 |
600 |
|
S2 |
P3 |
J6 |
400 |
|
S2 |
P3 |
J7 |
800 |
|
S2 |
P5 |
J2 |
100 |
|
S3 |
P3 |
J1 |
200 |
|
S3 |
P4 |
J2 |
500 |
|
S4 |
P6 |
J3 |
400 |
|
S4 |
P6 |
J7 |
300 |
|
S5 |
P2 |
J2 |
200 |
|
S5 |
P2 |
J4 |
100 |
|
S5 |
P5 |
J5 |
500 |
|
S5 |
P2 |
J7 |
100 |
|
S5 |
P6 |
J2 |
200 |
|
S5 |
P1 |
J4 |
100 |
|
S5 |
P3 |
J4 |
200 |
|
S5 |
P4 |
J4 |
800 |
|
S5 S5 |
P4 P6 |
J4 J4 |
400 500 |
Go to top of page.
Return to Syllabus, Assignments, Menu.