$2.$ In the new system under development for Holiday

Travel Vehicles, seven tables will be implemented in

the new relational database. Th ese tables are: New

Vehicle, Trade$-$in Vehicle, Sales Invoice, Customer,

Salesperson, Installed Option, and Option. Th e

expected average record size for these tables and the

initial record count per table are given here.

Average Initial Table

Table Name Record Size Size $($records$)$

New Vehicle $65$ characters $10,000$

Trade$-$in Vehicle $48$ characters $7,500$

Sales Invoice $76$ characters $16,000$

Customer $61$ characters $13,000$

Salesperson $34$ characters $100$

Installed Option $16$ characters $25,000$

Option $28$ characters $500$

Perform a volumetrics analysis for the Holiday

Travel Vehicle system. Assume that the DBMS that

will be used to implement the system requires $35$ percent overhead to be factored into the estimates. Also,

assume a growth rate for the company of $10$ percent

per year. Th e systems development team wants to

ensure that adequate hardware is obtained for the next

three years.