At what point do you outgrow access

Assignment Help Basic Computer Science
Reference no: EM131091809

For your current assumptions about the users, the functions that they want to accomplish, etc., what do you see as the most critical performance requirements you have to meet? Can you express that in either volumes of data, or numbers of users, for example? Or in terms of transactions (create/update/delete operations on data) per day, hour, minute, or second? Do transactions have to be processed in a specific maximum amount of time?

How do you see those user-level performance requirements translating into physical database design implementations? Does this drive you to consider simpler ways of structuring or representing the data or how you use the various kinds of keys? What about indexing?

Suppose your database project is a roaring success, and you scale it up big-time! (Example: you have been building a Bed & Breakfast reservations and management system, and now dozens of B&B operators all over your resort destination area want to cooperatively use it to manage bookings, referrals, billing, etc.) What "multipliers" would it take to stretch your system to the breaking point - much larger files, many more users, more transactions per unit time? How might you cope with those? At what point do you "outgrow Access?"

Consider the restrictions that a typical database project might need to impose, either on the way users use the system, the kinds of data they put into the system, or the constraints the system is expected to enforce "naturally" (as if it read their minds during the design phase). What are these? How do you allocate which restrictions to which part of the finished system (people, business process using the database, tables and relationships, other DBMS features, or?).

How might "massive multipliers" on demand for your system, such as in (3), affect your thoughts about which parts of the physical design to enforce the constraints you identify in (4)?

Reference no: EM131091809

Questions Cloud

Finding common denominator : What career uses finding common denominator and provide a real life example . Show work
Based on the number of units he sells : Adrian receives an hourly wage of $12 per hour plus commission. His commission is based on the number of units he sells. He works a normal 40-hour week, gets paid bi-weekly, and has a commission rate of 20%.
Find the maximum compression : Find the Maximum compression
Computing the canadian dollars : A car is priced at 37,000 Canadian dollars (CAN) and the same car in Switzerland is priced at 38,500 Swiss Francs (CHF). In Canadian dollars, which would be the better deal if 1 CAN = 1.08 CHF? By how much?
At what point do you outgrow access : How might "massive multipliers" on demand for your system, such as in (3), affect your thoughts about which parts of the physical design to enforce the constraints you identify in (4)?
Demonstrates the appropriate time : Provide at least one (1) example of a scenario that demonstrates the appropriate time / situation to use a recovery option to return a Windows 8 system to a functional state. Identify the recovery option you would use for your provided example, an..
Controversy in the nursing profession for essay : Choose a controversy in the nursing profession for Essay - Identify your topic and your position on it. Identify two sources that you plan to use to support your argument.
Describe any potential legal or ethical considerations : Calculate the financial information (including forecasting demand, break-even analysis, sales, promotional budget, and marketing expenses for three years by quarter).
Proprietary nature of the apple platform : What are the benefits of apps? The disadvantages? Are there any benefits/disadvantages to the proprietary nature of theApple platform?

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd