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

In the new system under development for Benny's Used Cars, 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	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 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.

Expert Solution

Colby Messinger answered 3 years ago

There are seven stages in the new-product development processthat businesses must perform in order to...

There are seven stages in the new-product development process that businesses must perform in order to ensure a better chance of success in their new product launches. (a) Identify (list out) each stage in the 7 new-product development processes in the correct order or sequence. (b) Briefly describe what a business organization would often do in the second stage of their new-product development process.

The Federal Reserve System operates under a seven-member Board of Governors. The term of a governor...

The Federal Reserve System operates under a seven-member Board of Governors. The term of a governor is fourteen years, and governors usually cannot serve more than one term (except for an additional partial term to fill a vacancy). Terms are staggered, so that one governor’s term expires every other year. Governors can only be removed from office “for cause”—that is, for abuse of their office and not just for policy disagreements. In what way do the long terms and secure...

The persistent under development in Caribbean economies is attributed to the plantation system. A. Explain in...

The persistent under development in Caribbean economies is attributed to the plantation system. A. Explain in about a page long do you agree or disagree?

1. Development of new housing tracts in New Mexico is counted in GDP under: (a) personal...

1. Development of new housing tracts in New Mexico is counted in GDP under: (a) personal consumption expenditures for durable goods; (b) personal consumption expenditures on housing services; (c) gross private domestic investment; (d) business fixed investment. 2. . The possibility that even a relatively or seemingly minor event somewhere in the world could spread and disrupt the entire real economy is known as: (a) operational risk; (b) credit risk; (c) a liquidity trap; (d) systemic risk. 3. The Federal...

Describe System Development Life Cycle (SDLC) and how it is used.

A new system has been implemented with the purpose of reducing transaction time historically at 10...

A new system has been implemented with the purpose of reducing transaction time historically at 10 minutes. A random sample of 80 transactions obtained after the implementation of the new system showed an average time of 9.5 minutes with a standard deviation of 1.5 minutes. Would you say that there has been a reduction of processing time occurred after the implementation of the new system? Formulate the hypothesis: A. Ho: µ≥9.5 . Ha: µ<9.5 B. Ho: µ>10 . Ha: µ≤10...

A university has implemented a new enrollment system. The scenario below outlines the steps to enroll...

A university has implemented a new enrollment system. The scenario below outlines the steps to enroll a new student in the university. Perform a system analysis based on the scenario and respond to the questions below. Note-some requirements might not be explicitly stated in the scenario. List all assumptions used for this analysis. Scenario: Enroll new student in the University An applicant wants to enroll in the university. The applicant hands a filled-out copy of University Application Form to the...

There are 3 ways to acquire a new system: custom development (the company develops the system...

There are 3 ways to acquire a new system: custom development (the company develops the system in house using corporate resources), packaged systems (purchasing a system off the shelf), and outsourcing (hiring an external developer, vendor or application service provider to create or supply the system). Assume you are the Business Systems Analyst for a company that adopts a mix of these three acquisition strategies. What would be your role in each of these acquisition activities as a Business Systems...

The SDLC (software/system development life cycle) framework is a common development methodology used by organizations to...

The SDLC (software/system development life cycle) framework is a common development methodology used by organizations to build systems and software. Security is often an afterthought or only addressed late in the development process. How can threat modeling be includes during the entire development effort? At what points of the lifecycle would you include threat identification, testing and analysis? Why have you chosen those points in the development cycle?

Summarize the cost flow methoda used under each system.

Question