Compression (Breadth-First)

BB TT000001 3

Supplier SU /*a supplier of some items we buy */

Warehouse WH /* where vendor stores items */

Item IT /* an item supplied by a vendor */

EB TT 3

BB TA000001 TT000001 3

SUid NA c24 0 /* unique pkey of SUpplier */

name NA c24 0 /* name of company we buy from */

expDate NA c10 0 /* last date price quotes are */

EB TA 3

BB TA000004 TT000002 4

WHid NA c24 0 /* unique pkey of WareHouse */

SUid NA c24 0 /* unique fkey(xref to SUpplier */

phone NA c10 0 /*warehouse phone number */

address NA t80 0 /* address of warehouse */

EB TA 4

BB TA000008 TT000003 7

ITid NA c24 0 /* unique pkey of ITem */

WHid NA c24 0 /* unique fkey (xref to WareHou */

ourItemNo NA i4 0 /* our integer part identi */

vendorCode NA c12 0 /* vendor’s item code */

unitPrice NA i4 0 /* vendor price in $/100 */

unitQuantity NA i4 0 /* quantity in packag */

itemDesc NA i4 0 /* item description */

EB TA 7

*/

Previous slide

Next slide

Back to first slide

View graphic version