Information Systems Test 3c

Card Set Information

Information Systems Test 3c
2013-12-02 20:59:18

Show Answers:

  1. A ___________ is a logically organized collection of related data designed and built for a specific purpose.
  2. The data hierarchy consists of the level of data stored in a computer in this order:
    • Bits
    • Character
    • Field
    • Record
    • File
    • Database
  3. A character is made up of ______.
  4. A _____ _______ is a field that is chosen to uniquely identify a record so that it can be easily retrieved.
    key field
  5. Program files are files containing ________ _________.
    software instructions
  6. Two types of program files are a ________ program and an ________ (executable) program.
    • source
    • object
  7. _______ ____________ is a method of removing repetitive elements from the file so that the file requires less storage space and sends faster.
    Data compression
  8. Two data file types are:
    • Master File
    • Transaction File
  9. A ________ file contains relative permanent records that are generally updated periodically by the transaction file.
  10. A ________ file is a temporary holding file that holds all the changes to be made to the master file.
  11. _______ _______ methods are the methods or way that a file or database allows access to the records stored within it.
    Data access
  12. This type of data access method is slow because you always have to start with the first record and move through the file in sequence to find the record you want:
  13. This type of data access file is the one that means the computer can go straight to the location where record is stored:
  14. Four types of databases:
    • Individual
    • Shared
    • Distributed
    • Public
  15. Five types of database organization:
    • Hierarchical
    • Network
    • Object Oriented
    • Multidimensional
    • Relational
  16. A data _________ is a special database of cleaned up data.
  17. Data _________ is the computer assisted process of shifting through and analyzing large volumes of data in order to extract meaning and discover new knowledge.
  18. ________ _________takes a particular set of numerical data and develops a mathematical formula that fits the data, and then applies that formula to future data to predict future situations.
    Regression analysis
  19. ________ ________ is a statistics pattern recognition process that is applied to data with more than just numerical data.
    Classification analysis
  20. A Database Management System (DBMS) consist of programs that ________ the _______ of a database and the ________ to the data.
    • control
    • structure
    • access
  21. 6 features of a DBMS are:
    • File Sharing
    • Reduced data Redundancy
    • Improved Data Integrity
    • Increased Security
    • Data Dictionary
    • System Recovery
  22. A ___________ __________ coordinates all the related activities for an organization's database.
    Database Administrator (DBA)
  23. _______ ________ is a feature of DBMS that means all authorized users can shore or work on the same set of files.
    file sharing
  24. _________ data _______ is a feature of DBMS that reduces the occurrence of the same data appearing in multiple files.
    reduced redundancy
  25. Improved ________ ________ is a feature of DBMS that helps to insure that data is accurate, up to date and consistent.
    data integrity
  26. Increased __________ is a feature of DBMS that means access to specific information can be limited to specific users.
  27. A ______ ___________ is a feature of DBMS that contains definitions for the individual data fields.
    data dictionary
  28. __________ __________ is a feature of DBMS that allows the database administrator the ability to recover contents of a database in the event of a hardware or software failure.
    system recovery
  29. An ___________ database is a collection of integrated files used by one person.
  30. A ________ database is one that is shared by individuals at one company or organization.
  31. A _________ database is one that is stored on different computers in different locations connected by a network.
  32. A __________ database is one that is available to the general public.
  33. In ____________ database organization, fields or records are arranged in related groups resembling a family tree, with child (lower level) records subordinate to a parent (higher level) record.
  34. In _________ database organization, each child record can have more than one parent.
  35. With __________ ___________ database organization, software is written in small reusable chunks, as elements within the database.
    object oriented
  36. With ______________ database organization, data is modeled as facts, dimensions, or numerical measures for use in interactive analysis of large amounts of data.
  37. With _________ database organization, data is connected in different files through the use of a key field or common data element