c$.$ Assumptions. Includes how to calculate the expected storage space needed for the database. Remember an estimate is a ballpark size. Estimates are not exact. Remember to include the size of indexes needed for high performance. Use the business information provided, determine the size of the new database. List what you will need to do to ensure the new database can accommodate the data described below. Do not use page sizes in your calculations. Use the row size and number of rows.

$80\%$ of the data for the database is going to be $80\%$ of the data for the database is going to be broken up into three main tables: products, customers, and invoices.

$$ There will be $1,000$ products in the products table with each row being $5,000$ characters. Each character is $2$ bytes.

$$ There will be $1$ million customers in the customer table with each row being $10,000$ characters. Each character is $2$ bytes. The company plans to expand their customer base by $10\%$ each year.

$$ Invoices will likely include $5$ products. The invoice table includes a primary key, invoice key, product key, and customer key. There are four columns$/$keys$.$ Assume each key is $20$ bytes in length.

$$ A customer will be invoiced $10$ times per year.

$$ Reporting requires there to be an index on invoices for sorting by products. Indexes are $10$ to $20$ bytes in size for each column value indexed.

$$ Assume the database will be used for $10$ years when determining your estimate.

$$ System requires $5000$ concurrent users

Specify the size requirements in GB required for the tablespace all three tables $($plus $20\%).$ Size of a table is estimated as $($Size of Row$)$ x $($Number of Rows$).$ Record the information using the table on the next page. You will need to add multiple rows.

Please Note:

GiB is $1024$ MiB

MiB is $1024$ KB

KiB is $1024$ Bytes