Dbms Function

952 words 4 pages
Show More
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…

Statistical databases are great for when you need statistical information however there is a problem with the sparseness that can occur inside them, sometimes 40% to 50%, while there are ways to deal with this it still remains a valid issue. A pro of statistical databases is that they support analysis techniques that go beyond whets offers. While they are great for analysis purpose, they have little other functionalities which provides for compromise in many situations that can create unneeded troubles.

5. The DBA at Premiere Products wants out to investigate biometric identification techniques for potential use at the company for computer authentication purposes. Use books, articles, and/or the Internet to research these techniques, then write a report that describes the advantages and disadvantages of each of these techniques. In addition, recommend one technique and provide a justification for your recommendation.
Biometric identification techniques include using characteristics of a person like fingerprints, DNA, and behavior to identify them, thus creating security for the computer use. As far as identifying by behavior, typing speed, gait, and voice can be used to identify the individuals. It is not easily forge where as with many authentication systems are. Companies with good authentication systems can protect

Related

  • Review Questions: Chapter 1
    2505 words | 11 pages

    Chapter 1 1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. • Data – known facts that can be recorded and that have implicit meaning. • Database – a collection of related data with an implicit meaning. • DBMS – a collection of programs that enables users to create and maintain….

    Show More
  • Mis Laudon 12th Ed Chapter 5 Answer
    7123 words | 29 pages

    your university as an example. Have your students prepare a logical design for the enrollment process. Discuss the three operations of a relational DBMS: select, project, and join. A database management system is comprised of three components: a data definition language, data dictionary, and data manipulation language. If you have access to a relational DBMS during class time, you can demonstrate several of the concepts presented in this section. The concept of using databases stored in cloud computing….

    Show More
  • Acs Assignment 2, University of Winnipeg
    1451 words | 6 pages

    Setting schemas. Installing and using a large database involves “telling” the DBMS the logical and physical structure of the data and the relationships among the data for each user. 2. Establishing a data dictionary. In this case, the data dictionary should contain the following information: patient No., patient name, patient….

    Show More
  • Sports Day Database System
    9455 words | 38 pages

    Systems (Authors: Thomas Connolly, Carolyn Begg, Richard Holowczak), the database management system means: The database management system is the software that interacts with the users, database application, and the database. Among other things, the DBMS allows users to insert, update, delete and retrieve data from database The large amount of data will formed into a database. From Wikipedia (http://en.wikipedia.org/), database means: A database is an integrated collection of logically related records….

    Show More
  • Object Oriented Database
    5365 words | 22 pages

    Introduction “Choosing the right OODB architecture can mean orders of magnitude difference in performance and scalability characteristics rather than a few percentage points as found in relational implementations.” To achieve maximum performance and scalability the most important thing is choosing the right application architecture. OODBs give applications much more direct access to the persistent data, so application architecture has much more impact on performance than is the case with an RDB….

    Show More
  • Outline Informative Speech
    1513 words | 7 pages

    NAME : Syifa Fadhilah Hamid CLASS : 12 DBM SUBJECT : Outline Informative Speech SPECIFIC PURPOSE : to inform my audience about Deja Vu CENTRAL IDEA : to inform my audience about the theory of Deja Vu. Including what, how and the effect about Deja Vu . INTODUCTION: Attention Getter : I can’t remember any things well while I thought something happened to me, I feel like I ever seen something but I don’t know when it was or where it was. And I also feel like I’ve been somewhere but I don’t know when….

    Show More
  • Clinical Decision Support System
    4731 words | 19 pages

    Abstract Clinical decision-support systems (CDSS) apply best-known medical knowledge to patient data for the purpose of generating case-specific decision-support advice. CDSS forms the cornerstone of health informatics research and practice. It is an embedded concept in almost all major clinical information systems and plays an instrumental role in helping health care achieve its ultimate goal: providing high quality patient care while, at the same time, assuring patient safety and reducing….

    Show More
  • Cases
    2020 words | 9 pages

    CASE QUESTIONS Abercrombie & #Fitchthehomeless 1) Why did this crisis occur? Why did Jeffries’s comments trigger such a large response? 2) Evaluate A&F’s response. What could the company have done better? 3) What changes should A&F make? Autobytel.com 1) How does the internet change traditional channel structures? Does the internet facilitate disintermediation, re-intermediation or can it do both? 2) Can an intermediary serving two customers avoid alienating….

    Show More
  • Data Encryption
    3747 words | 15 pages

    ENCRYPTION Introduction Often there has been a need to protect information from 'prying eyes'. In the electronic age, information that could otherwise benefit or educate a group or individual can also be used against such groups or individuals. Industrial espionage among highly competitive businesses often requires that extensive security measures be put into place. And, those who wish to exercise their personal freedom, outside of the oppressive nature of governments, may also wish to encrypt….

    Show More
  • "Hi Tech Corp" Case Study
    9389 words | 38 pages

    2013 SOFTWARE QUALITY ENGINEERING (SQE) - CE00231-7 Individual Assignment “Hi Tech Corp” Case Study NAME : TEW SHEAU WEI STUDENT ID : TP024267 INTAKE CODE : UCMF1210SE HAND-OUT DATE : 6th November 2012 HAND-IN DATE : 15th March 2013 LECTURER : MR. KESAVA PILLAI A/L RAJADORAI RAJOO ASIA PACIFIC UNIVERSITY OF TECHNOLOGY AND INNOVATION Table of Contents 1. Introduction 4 2. Company Background 4 3. Assumptions 5 4. Company Problem Statements 6 5. Objectives 7 6. Organizational….

    Show More

Popular Essays