No Additional Storage Needed

Solution:

New Size:

PART

PartKey 4

Name 55

Mfgr 25

Brand 10

Type 25

Size 4

Others... 41

164

200,000

CUSTOMER

CustKey 4

Name 25

Address 40

Nation 25

Region 25

Phone 15

AcctBal 8

MktSegment 10

Comment 117

269

150,000

SUPPLIER

SuppKey 4

Name 25

Address 40

Nation 25

Region 25

Phone 15

AcctBal 8

Comment 101

243

10,000

TIME

TimeKey 2

Alpha 10

Year 4

Month 4

Week 4

Day 4

28

2,557

SALES

Quantity 8

ExtPrice 8

Discount 8

Tax 8

RetFlag 1

Status 1

ShipInstruct 25

ShipMode 10

Comment 44

119

6,000,000

CustKey

PartKey

ReceiptDate

CommitDate

ShipDate

SuppKey

6 M

4

6 M

4

6 M

4

2

2

2

6 M

6 M

6 M

Previous slide Next slide Back to first slide View graphic version