Supplier Parts Projects Database
Supplier Parts Projects DatabaseThis is a simple database that is frequently used by Chris Date & Hugh Darwen in their books (e.g., AnIntroductionToDatabaseSystems and TheThirdManifesto) for examples. It's handy to have this as a reference for discussing database software. They also use an even simpler SupplierPartsDatabase as a basis for many of their examples. Tables S and P, and their typical contents, are the same in both databases.
There are only four tables:
Table name Purpose Key ------------------------------------------------------------------- S Suppliers (S#) P Parts (P#) J Jobs (J#) SPJ Parts supplied by Suppliers for Jobs (S#, P#, J#)The full column set of each table, and the data they typically contain for example uses, are shown below. This version was taken from the eighth edition of AnIntroductionToDatabaseSystems.
S S# SNAME STATUS CITY ---------------------------- S1 Smith 20 London S2 Jones 10 Paris S3 Blake 30 Paris S4 Clark 20 London S5 Adams 30 Athens P P# PNAME COLOR WEIGHT CITY ---------------------------------- P1 Nut Red 12.0 London P2 Bolt Green 17.0 Paris P3 Screw Blue 17.0 Oslo P4 Screw Red 14.0 London P5 Cam Blue 12.0 Paris P6 Cog Red 19.0 London J J# JNAME CITY ---------------------- J1 Sorter Paris J2 Display Rome J3 OCR Athens J4 Console Athens J5 RAID London J6 EDS Oslo J7 Tape London SPJ S# P# J# QTY ----------------- S1 P1 J1 200 S1 P1 J4 700 S2 P3 J1 400 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 300 S4 P6 J7 300 S5 P2 J2 200 S5 P2 J4 100 S5 P5 J5 500 S5 P5 J7 100 S5 P6 J2 200 S5 P1 J4 100 S5 P3 J4 200 S5 P4 J4 800 S5 P5 J4 400 S5 P6 J4 500
EditText of this page
(last edited February 20, 2009)
or FindPage with title or text search