Zicklin School of Business - Baruch College
City University of New York

Database Management Systems

Review for Mid Term Exam

Your Test 2 will be held on Thursday November 5, 2009 in our regular classroom at the regular class time period.

  • For your review, we have covered:

    Topic Week (notes) Book Chapters
    Structured Query Language - DDL
    SQL Data types.
    Data Definition Language (CREATE, DROP, ALTER) for Schemas, Tables, Views and Indexes.
    - What is the purpose of a PRIMARY KEY constraint?
    - What is the purpose of a FOREIGN KEY constraint?
    - What is the purpose of a NOT NULL constraint?
    		SQL Notes Appendix E

    Structured Query Language - DML
    Data Manipulation Language
    - INSERT, SELECT, DELETE, UPDATE statements
    - Recursive queries using Table Aliases
    - Subqueries and inline queries (using the results of a query as a table for another query).
    - Multiple table queries with joins (but no semi-joins or outer joins).
    - Column Aliases
    - SQL Aggregate Functions. Using GROUP BY and HAVING
    - Not included: Query by example (QBE)     		SQL Notes Chapter 3 Chapter 3 PowerPoint Slides
    File Implementation Issues.
    - Data organization for files: Unordered list (heap), ordered list, indexed data
    - Speed/Efficiency of operations (Select, Insert, Update, Delete) on each data organization
    - Construction and Use of an index
    - Not Included: Hashing
    		File Organization notes
    Database Administration and Security
    - Role and Tasks of the Database Administrator (DBA) in an organization.
    - Role and Tasks of the Data Administrator (DA) in an organization.
    - Threats to databases and countermeasures
    - Database Security and Countermeasures including:
        authorization
        views
        backup and recovery
        integrity
        encryption
        redundant array of independent disks (RAID)
    - Not included: Network security
    		Role of DBA and DA, DB Security Notes 12 Chapter 12 PowerPoint Slides

    Reminders

    File: test2.html Date: 9:34 PM 11/2/2009
    All materials Copyright, 1997-2009 Richard Holowczak