In the new system under development for Holiday Travel Vehicles, seven tables will be implemented in the new relational database. These tables are New Vehicle, Trade-in Vehicle, Sales Invoice, Customer, Salesperson, Installed Option, and Option. The expected average record size in characters for these tables and the initial record count per table are given next.
| New Vehicle |
65 |
10,000 |
| Trade-in Vehicle |
48 |
7,500 |
| Sales Invoice |
76 |
16,000 |
| Customer |
61 |
13,000 |
| Salesperson |
34 |
100 |
| Installed Option |
16 |
25,000 |
| Option |
28 |
500 |
Perform a volumetrics analysis for the Holiday Travel Vehicles system.
Assume that the DBMS that will be used to implement the system requires 35% overhead to be factored into the estimates.
Also, assume a growth rate for the company of 10% per year. The systems development team wants to ensure that adequate hardware is obtained for the next 3 years.