In the new system under development for Benny's Used Cars, seventables will be implemented in the new relational database. Thesetables are New Vehicle, Trade-in Vehicle, Sales Invoice, Customer,Salesperson, Installed Option, and Option. The expected averagerecord size in characters for these tables and the initial recordcount per table are given next.
New Vehicle | 55 | 10,000 |
Trade-in Vehicle | 38 | 7,500 |
Sales Invoice | 66 | 16,000 |
Customer | 51 | 13,000 |
Salesperson | 24 | 100 |
Installed Option | 6 | 25,000 |
Option | 18 | 500 |
Perform a volumetrics analysis for the system. Assume that the DBMSthat will be used to implement the system requires 35% overhead tobe factored into the estimates. Also, assume a growth rate for thecompany of 10% per year. The systems development team wants toensure that adequate hardware is obtained for the next 3 years.