Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. advance math
  3. in the new system under development for benny's us

In the new system under development for Benny's Used Cars, seven tables will be implemented in...

50.1K

Verified Solution

Question

Advance Math

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 Vehicle5510,000
Trade-in Vehicle387,500
Sales Invoice6616,000
Customer5113,000
Salesperson24100
Installed Option625,000
Option18500


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.

Answer & Explanation Solved by verified expert
3.8 Ratings (431 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Chemistry
1.2K views

How many air molecules are in a 11.5×12.0×10.0 ft room? Assume atmospheric pressure of 1.00 atm...

Biology
1.2K views

Given the idea that male expressed drive systems like sex-ratio X chromosomes, though favored by gametic...

Mechanical Engineering
1.2K views

Why do we use angled drafts in casting

Physics
1.2K views

1)An object experiences a force in the direction opposite its motion. This means the work vector points...

Accounting
1.2K views

Jim Sandalwood has recently opened The Sandal Hut in Brisbane, Australia, a store that specializes in...

Biology
1.2K views

What is a similarity between the following two main ideas? 1. Stem cell research is...

Biology
1.2K views

Which type of motor units are activated for the longest time during low to moderate...

Basic Math
1.2K views

5 Your investment of 18 100 at 13 6 compounded quarterly for 71 2 years...

Basic Math
1.2K views

6 13 points Ben walks at a rate of 3 miles per hour He runs...

Statistics
1.2K views

ording to flightstats com American Airlines flights from Dallas to Chicago are on tir me...

Accounting
1.2K views

The January 1st inventory of finished units for Ryan and Son's Company is 6,000. During...

Accounting
1.2K views

1. Calculate the (preliminary) unadjusted net income for the year ended December 31, 2020. 5-a....