Preview

Evaluation Form for Arcade Games

Powerful Essays
Open Document
Open Document
4933 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Evaluation Form for Arcade Games
Answers to Review Questions
1. Explain the following statement: a transaction is a logical unit of work. A transaction is a logical unit of work that must be entirely completed of aborted; no intermediate states are accepted. In other words, a transaction, composed of several database requests, is treated by the DBMS as a unit of work in which all transaction steps must be fully completed if the transaction is to be accepted by the DBMS. Acceptance of an incomplete transaction will yield an inconsistent database state. To avoid such a state, the DBMS ensures that all of a transaction's database operations are completed before they are committed to the database. For example, a credit sale requires a minimum of three database operations: 1. An invoice is created for the sold product. 2. The product's inventory quantity on hand is reduced. 3. The customer accounts payable balance is increased by the amount listed on the invoice. If only parts 1 and 2 are completed, the database will be left in an inconsistent state. Unless all three parts (1, 2, and 3) are completed, the entire sales transaction is canceled.

2. What is a consistent database state, and how is it achieved? A consistent database state is one in which all data integrity constraints are satisfied. To achieve a consistent database state, a transaction must take the database from one consistent state to another. (See the answer to question 1.) 3. The DBMS does not guarantee that the semantic meaning of the transaction truly represents the real-world event. What are the possible consequences of that limitation? Give an example. The database is designed to verify the syntactic accuracy of the database commands given by the user to be executed by the DBMS. The DBMS will check that the database exists, that the referenced attributes exist in the selected tables, that the attribute data types are correct, and so on. Unfortunately, the DBMS is not designed to guarantee that the syntactically correct transaction

You May Also Find These Documents Helpful

  • Good Essays

    DBM380 Week 2

    • 837 Words
    • 3 Pages

    The database environment refers to the type of configuration used to populate and create the application. A database includes items such as text, images and graphics associated with a record. The main purpose of a database is to collect and organize that data. The environment to be designed is one to store and retrieve data in a way it can be easily organized. For the purpose of this assignment the database environment will be a series of tables which store customer, sales order, purchase order and various status point information. This data will then be used for a series of reports to demonstrate status of the purchase order as it flows through the system. The overall goal is to be able to provide the customer an accurate status of their purchase order that is submitted electronically.…

    • 837 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Steps one through three are performed frequently throughout the accounting period. As transactions occur they are constantly being updated.…

    • 549 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    - Any action that a database takes, creating objects, adding rows, changing data in rows, removing rows, and so on.…

    • 327 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Klinger, L. J., Hamilton, J. A., & Cantrell, P. J. (2001). Children's perceptions of aggressive and gender-specific content…

    • 772 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    5) Transactional selling is a strategically developed, high-quality, longterm relationship that focuses on solving the customer's buying problems.…

    • 4576 Words
    • 19 Pages
    Powerful Essays
  • Satisfactory Essays

    Evaluation

    • 688 Words
    • 3 Pages

    I bet if you ask any guy in this country if they like Hooters, they would give that look saying did you seriously just ask that question. Hooters is a sports bar mostly for guys, and is famous for its wings and waitress attire. This restaurant is a perfect place to have some wings and a few beers, watch the game, and have a great scenery while you’re there. I like to go there once in a while with some friends whenever a good game is on, but it comes with some consequences between me and my girlfriend. By evaluating the Hooters on I-17 and Peoria, I believe that this is good place to if you’re a guy and a sports fan for its service, food, and environment, but does has some flaws to these attributes.…

    • 688 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Acct 555 HW Week 6

    • 3582 Words
    • 14 Pages

    a. The accounting system will not post a sales transaction to the sales journal without a valid bill of lading number. This control is most relevant to which transaction-related objective for sales?…

    • 3582 Words
    • 14 Pages
    Good Essays
  • Satisfactory Essays

    Evaluation Questions

    • 841 Words
    • 4 Pages

    4. Discussion topic: “Why do men hold the most powerful economic and political positions across the globe?” “How would functionalist, conflict theorist, symbolic interactionist, and feminist answer to the above question?”…

    • 841 Words
    • 4 Pages
    Satisfactory Essays
  • Better Essays

    Some of the best practices to follow is to review and update signature authorizations periodically, obtain pre-approval of consultant agreements by purchasing, verify receipt of goods and services to contract/ purchase order and invoice information, reconcile ledgers for accuracy of recorded transactions, and monitor that invoices are paid in a timely manner.…

    • 2178 Words
    • 9 Pages
    Better Essays
  • Good Essays

    15. For a merchandising business, an increase in sales will probably also result in a higher…

    • 2935 Words
    • 12 Pages
    Good Essays
  • Good Essays

    For companies that produce to open stock, the sale is the critical event for revenue recognition. Even though value is added to goods through the production process, these companies face considerable uncertainty about who the customer will be and about the amount and timing of the sale. It is necessary to have an arm’s length transaction, in which the customer is legally obligated to pay for the merchandise or service. Such factors as the signing of a sales contract and the delivery of the product provide evidence that the sale has been made. At the time of the sale, revenue is recognized and the amount due from the customer is reflected as an asset such as accounts receivable. However, some uncertainty still remains about cash receipt. Companies that use the sales method must also be able to estimate bad debts or doubtful accounts at the time of the sale so that the sales amounts and accounts receivable balances can be adjusted to reflect the expected cash receipts.…

    • 465 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    It is an interactional process that consists of an action of sending information, receiving and exchanging the information between the sender and receiver. While many people think of communication primarily in oral or written form, communication is much more. Communication can be done in many forms either as verbal or non-verbal, such as body language, sign language, touch and eye-contact.…

    • 1535 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    The business will use transaction processing system for payroll, sales, ordering, and inventory. The business will also use this processing system for purchasing, receiving, shipping, accounts payable, and receivables.…

    • 1028 Words
    • 5 Pages
    Good Essays
  • Good Essays

    “Databases are a mean for storing information in such a way that information can be retrieved from it. In simplest terms, a relational database is one that presents information in tables with rows and columns.” “A table is referred to as a relation in the sense that it is a collection of objects of the same type (rows).” “Data in a table can be related according to common keys or concepts, and the ability to retrieve related data from a table is the basis for the term relational database.” “A Database Management System (DBMS) handles the way data is stored, maintained, and retrieved.” “In the case of a relational database, a Relational Database Management System (RDBMS) performs these tasks. Oracle, 2014)”…

    • 672 Words
    • 3 Pages
    Good Essays
  • Good Essays

    In the fields of computer science and information technology there are often transactions, operations or jobs that are executed to gather a result. In most cases these results come in bunches and many separate transactions may have to occur at the same time. The process of managing simultaneous execution of transactions while ensuring the serializability of transactions in a database is known as concurrency control.…

    • 597 Words
    • 3 Pages
    Good Essays