Ch4 Relational Database

  1. Database
    A set of interrelated, centrally coordinated data files that are stored with as little data redundancy as possible
  2. Database Management System (DBMS)
    Program that manages and controls the data and the interfaces between the data and the application programs that use the data stored in the database
  3. Database system
    The database, the DBMS, and the application programs that access the database through the DBMS
  4. Database Administrator
    The person responsible for coordinating, controlling, and managing the database
  5. Data warehouse
    Very large database containing detailed and summarized data for a number of years that are used for analysis rather than transaction processing
  6. Business intelligence
    Analyzing large amounts of data for strategic decision making
  7. Online analytical processing (OLAP)
    Using queries to investigate hypothesized relationships among data
  8. Data mining
    Using sophisticated statistical analysis to "discover" unhypothesized relationships in the data
  9. Record layout
    Document that shows the items stored in a file, including the order and length of the data fields and the type of data stored
  10. Logical view
    How people conceptually organize, view, and understand the relationships among data items
  11. Physical view
    The way data are physically arranged and stored in the computer system
  12. Schema
    A description of the data elements in a database, the relationships among them, and the logical model used to organize and describe the data
  13. Conceptual-level schema
    The organization-wide view of the entire databse that lists all data elements and the relationships between them
  14. External-level schema
    An individual user's view of portions of a database; also called a subschema
  15. Subschema
    A subset of the schema; the way the user defines the data and the data relationships
  16. Internal-level schema
    A low-level view of the entire database describing how the data are actually stored and accessed
  17. Data dictionary
    Information about the structure of the database, including a description of each data element
  18. Data definition language (DDL)
    DBMS language that builds the data dictionary, creates the database, describes logical views, and specifies record or field security constraints
  19. Data manipulation language (DML)
    DBMS language that changes database content, including data element creations, updates, insertions, and deletions
  20. Data query language (DQL)
    High-level, English-like, DBMS language that contains powerful, easy-to-use commands that enable users to retrieve, sort, order, and display data
  21. Report writer
    DBMS language that simplifies report creation
  22. Data model
    An abstract representation of database contents
  23. Relational data model
    A two-dimensional table representation of data; each row represents a unique entity (record) and each column is a field where record attributes are stored.
  24. Tuple
    A row in a table that contains data about a specific item in a database table
  25. Primary key
    Database attribute, or combination of attributes, that uniquely identifies each row in a table
  26. Foreign key
    An attribute in a table that is also a primary key in another table; used to link the two tables
  27. Update anomaly
    Improper database organization where a non-primary key item is stored multiple times; updating the item in once location and not the others causes data inconsistencies
  28. Insert anomaly
    Improper database organization that results in the inability to add records to a database
  29. Delete anomally
    Improper organization of a database that results in the loss of all information about an entity when a row is deleted
  30. Relational database
    A database built using the relational data model
  31. Entity integrity rule
    A non-null primary key ensures that every row in a table represents something and that it can be identified
  32. Referential integrity rule
    Foreign keys which link rows in one table to rows in another table must have values that correspond to the value of a primary key in another table
  33. Normalization
    Following relational database creation rules to design a relational database that is free from delete, insert, and update anomalies
  34. Semantic data modeling
    Using knowledge of business processes and information needs to create a diagram that shows what to include in a fully normalized database (in 3NF)
Card Set
Ch4 Relational Database
ACC409 Exam 3