In the scenario from Tables 4-4, 4-5, and 4-6, how big should you make the Accounting data file?

In the scenario from Tables 4-4, 4-5, and 4-6, how big should you make the Accounting data file?


Answer – 230 MB

(This is a simple calculation. Just add the estimated size of the tables (in bytes) like this: 171,000,000 + 212,000 + 100,000 = 171,312,000. Now add about 35 percent of the size of the tables with nonclustered indexes, which is 35 percent of 171,000,000, or 59,850,000, and you get 171,000,000 + 59,850,000 = 230,850,000, or about 230 MB.)