Maricopa Community Colleges  CIS262   19906-19925 
Official Course Description: MCCCD Approval: 04/24/90
CIS262 19906-19925 L+L 3 Credit(s) 4 Period(s)
Database Management Systems
Database design, implementation, evaluation, maintenance and management. Prerequisites: CIS111, or CIS155, or CIS158, or permission of instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS262   19906-19925 Database Management Systems
1. Describe the major types of databases and their strengths and limitations. (I)
2. Define various terms related to databases. (I)
3. Define and use rules for database design to plan a database. (II)
4. Use a database to create and manipulate an application of student's own design. (III)
5. Identify database evaluation criteria, and apply them to one or more database systems, and to one or more database schemas. (IV)
6. Identify tools for database maintenance, and describe their uses. (V)
7. Describe the uses of software tools available for managing databases. (VI)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS262   19906-19925 Database Management Systems
    I. Types of databases and elementary terminology
        A. Types
          1. Hierarchical
          2. Network
          3. Relational
        B. Terminology
          1. Schema
          2. Query language
          3. User interface
          4. Application
      II. Database design
          A. Rules for good design
          B. Design review
          C. Design modification
        III. Database usage
            A. Using an instructor-provided database
            B. Implementing a student-designed database
            C. Creating an application using the database
          IV. Database evaluation
              A. Criteria for evaluation
              B. Applying the criteria
              C. Practice with evaluation
            V. Database maintenance
                A. Backup
                B. Logging and recovery
                C. Checkpoints, journals, audits
                D. Performance criteria
              VI. Software tools for database management
                  A. Data dictionary
                  B. CASE tools
                  C. Vendor-provided tools
              Go to Description    Go to top of Competencies    Go to top of Outline