• Table Size = Sum of Column Lengths
• Index = Column Length of Primary & Foreign Keys
• Secondary Index = Customer Name (assume 25 bytes)
• Blocking Factor of 90%
• 40% Overhead (logging etc.)
• Then:
• N*(Table size + Index Size) * 1.1 Blocking * 1.4 Overhead
• Assume: 10,000 Customers, 10 order per customers/mo, 3 lines per order, 20,000 Product SKU's
• Calc Storage for 12 months activity
• Calc Next Year # Customers Grow 20% (frequency or orders & lines the same)

Table Layout: Numbers Integers Dates mm/dd/yyyy . . Logically Relating Tables Names, Title 25 Character strings Phone 10 char $=32 bit float Primary key Foreign Primary lory CUSTOMER Customer Number ORDER 1111 0505 Order Number LINE ITEM ITEM 1000 1001 1002 Order Number Systems Architecture, Seventh Edition 1000 1001 1002 1002 Hem Number 9244 9250 9255 Sam Jane First Name Foreign key Customer Number 1111 0505 Foreign key her Number Iron Man 2 Twilight Zone Anasay 9244 9244 9250 9255 Tele Last Name Smith Cook Qusnsty 1 1 1 Order Date 11/1/2011 11/10/2011 12/11/2011 Distributor Number Phone 555-555-5555 002 002 004 Shipped? Y Y Y Y Price 4.95 4.55