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