1. While users were updating the Premiere Products database, one of the transactions was interrupted. You need to explain to management what steps the DBMS will take to correct the database. Using the sample log in Figure 7-1 1, list and describe the updates that the DBMS will roll back if transaction 2 is interrupted at 8:10.
In transaction 2, the DBMS started it at 8:01, added an Orders table record at 8:02, and added an Order Line table record at8:05 and added an Order Line table record at 8:09. To roll back the transaction, the DBMS deletes the three added records.
2. Occasionally, users at Premiere Products obtain incorrect results when they run queries that include built-in (aggregate, summary, or statistical) functions. The DBA
…show more content…
b) The DBMSreduces the first customer’s $900 balance to $700 for Elena’s transaction. c) The DBMS read the second customer’s $750balance for Pat’s transaction. d) The DBMS increases the third customer’s $500 balance to $700 for Elena’s transactions) The DBMS reads the third customer’s $700 balance for Pat’s transaction. f) The DBMS calculates the total balance from Steps a, c, and e and displays the total customer balance of $2,350 for Pat the displayed total is $200 higher than the actual total.
3. You’ve explained replication to management, and some managers ask y out for examples of when replication. Could be useful to them. Describe two situations, other than the ones given in the text, when replication would be useful to an organization.
Replication could be useful for schools in which remote sites are used to update student information. Also, to keep track of menu items in a chain restaurant business, updated from the various locations.
4. The staff of the marketing department at Premiere Products is scheduled to receive some statistical databases, and they need you to explain these databases to them. (A statistical database is a database that is intended to supply only statistical information to users; a census database is an example of a statistical database.) Using statistical database, users should not be able to
The choice to have various copies of the information in case of loss and ease of transfer.
1.1 Describe the purpose and benefits of organising data so that it can be analysed
Compare and contrast an existing organization’s three major functions (i.e., finance, marketing, and operations), and then justify the interdependence that operations have to finance and marketing. Provide examples to support your rationale.
• Provide at least two examples or problem situations in which statistics was used or could be used.
* Describe the role of databases and database management systems in managing organizational data and information.
The goal of the analysis is to identify the trend. Retail, rent, for example, used statistical analysis to determine the type of customer data is unstructured and semi-Cola created that can be used to create a positive experience for customers and increase sales.
4. Nothing needs to be done for any transaction that has a ROLLBACK operation after the last checkpoint before the failure occurred, because the database was never updated
* Transaction Processing Systems (TPS): It is a type of information system. TPSs collect, store, modify, and retrieve the transactions of an organization. A transaction is an event that generates or modifies data that is eventually stored in an information system. To be considered a transaction processing system the computer must pass the ACID test. The essence of a transaction program is that it manages data that must be left in a consistent state (Wikipedia.com).
Name: ________________________________ Date: _________________ [1]BASIC BANK01 - BAT 003 Which of the following statements is true? A. An asset account is increased by a credit B. An expense account is increase by a credit C. A revenue account is decreased by a credit D. An equity account is decreased by a debit [2]BASIC BANK02 - BAT 010 The Income Summary account contains: A. Total revenues and total expenses for the year B. Total assets and total liabilities at year end C. Total revenues, expenses, assets, and liabilities
Statistics is a mathematical science pertaining to the collection, analysis, interpretation or explanation, and presentation of data. It is applicable to a wide variety of academic disciplines, from the physical and social sciences to the humanities. Statistics are also used for making informed decisions and misused for other reasons in all areas of business and government. Statistical methods can be used to summarize or describe a collection of data; this is called descriptive statistics. In addition, patterns in the data may be modeled in a way that accounts for randomness and uncertainty in the observations, and then used to draw inferences about the process or population being studied; this is called inferential statistics. Both
What kind of systems are described in this case? Identify and describe the business processes each supports. Describe the inputs, processes, and outputs of these systems.
b. Trace the line item “Balance per Bank Statement” – Accuracy and Existence (AU-C 315.A114 a-iii, b-i)
3. Give three business examples (not mentioned in the text) of data that must be processed to provide useful information.
A large number of physical locations that need to contain replicas of Active Directory data.
13. Janfer Book Store purchased a new automobile that cost $10,000, made a down payment of $3,000, and signed a note payable for the balance. The entry to record this transaction is: