Active Outline

General Information

Course ID (CB01A and CB01B)
CIS D044A
Course Title (CB02)
Database Management Systems
Course Credit Status
Credit - Degree Applicable
Effective Term
Fall 2023
Course Description
This course covers the rudiments of database design, implementation and use. Students will gain a basic understanding of various data modeling techniques. An overview and comparison of database management systems will be given, along with an emphasis on relational databases; introduction to SQL.
Faculty Requirements
Course Family
Not Applicable

Course Justification

This course is transferable to all California State University campuses. Database Management is a fundamental course required as part of the Database Design for Developers (Oracle) Certificate of Achievement. This course covers rudiments of database design, implementation, and use; skills applied by Software Engineers, Business Analysts, Database Architects, Database Administrators, Database Designers, and Reporting Analysts.

Foothill Equivalency

Does the course have a Foothill equivalent?
No
Foothill Course ID

Course Philosophy

Formerly Statement

Formerly Statement
(Formerly CIS 064A.)

Course Development Options

Basic Skill Status (CB08)
Course is not a basic skills course.
Grade Options
  • Letter Grade
  • Pass/No Pass
Repeat Limit
0

Transferability & Gen. Ed. Options

Transferability
Transferable to both UC and CSU

Units and Hours

Summary

Minimum Credit Units
4.5
Maximum Credit Units
4.5

Weekly Student Hours

TypeIn ClassOut of Class
Lecture Hours4.08.0
Laboratory Hours1.50.0

Course Student Hours

Course Duration (Weeks)
12.0
Hours per unit divisor
36.0
Course In-Class (Contact) Hours
Lecture
48.0
Laboratory
18.0
Total
66.0
Course Out-of-Class Hours
Lecture
96.0
Laboratory
0.0
NA
0.0
Total
96.0

Prerequisite(s)

Corequisite(s)

Advisory(ies)

ESL D272. and ESL D273., or ESL D472. and ESL D473., or eligibility for EWRT D001A or EWRT D01AH or ESL D005.

CIS D003. or CIS D004.

Limitation(s) on Enrollment

Entrance Skill(s)

General Course Statement(s)

Methods of Instruction

Lecture and visual aids

Discussion and problem solving performed in class

Assignments

  1. Required reading from text
  2. Writing
    1. Project
      1. A guided assignment involving creation of an entity relationship model based on given application requirements, half completed in the computer lab, half completed as homework.
      2. A guided assignment involving implementation of the database using a relational database management system, half completed in the computer lab, half completed as homework.
    2. Exercises using SQL and/or an application language to access the database.
    3. Lab assignments requiring the use of a relational database management system, half completed in the computer lab, half completed as homework.

Methods of Evaluation

  1. One or more examinations requiring some programming demonstrating ability to develop an database schema, analyze requirement and/or write code using specific SQL constructs.
  2. In-class lab problems, group collaborative problems, exam questions and/or online assignments or tutorials demonstrating the ability to read and analyze code through debugging and/or writing snippets of code, and analyze requirements to produce database schema. The code will involve usage of SQL constructs.
  3. A final examination requiring some programming demonstrating ability to develop an algorithm and write code. The code will involve using create and alter table statements, implementation of database security concepts and database utilities.

Essential Student Materials/Essential College Facilities

Essential Student Materials: 
  • None.
Essential College Facilities:
  • Access to a computer with an operating database management system

Examples of Primary Texts and References

AuthorTitlePublisherDate/EditionISBN
Hoffer, Venkataraman and Topi, "Modern Database Management, 13th Edition." Pearson, 2017.
Pratt, Philip J. "A Guide to SQL, 9th Edition." Course Technology, 2014.

Examples of Supporting Texts and References

AuthorTitlePublisher
None.

Learning Outcomes and Objectives

Course Objectives

  • Evaluate the advantages and disadvantages of a database system vs. traditional files
  • Design logical data models and a physical database given application requirements
  • Implement a database design using a relational database management system (DBMS)
  • Describe means of protecting information and insuring confidentiality
  • Compare and contrast the design and capabilities of hierarchical, network and relational databases
  • Describe the current capabilities of common databases in mainframe, micro computing and distributed environments

CSLOs

  • Prepare database design using database normalization theory and appropriate database schema representation techniques.

  • Code, document, debug, and test introductory level SQL programs.

Outline

  1. Evaluate the advantages and disadvantages of a database system vs. traditional files
    1. The database environment
    2. The organization of stored data
    3. Primary storage review
    4. Secondary storage review
    5. Advantages and disadvantages of databases
    6. Databases in mainframe and microenvironments
  2. Design logical data models and a physical database given application requirements
    1. User requirements
    2. Entities
    3. Attributes
    4. Relationships
    5. Constraints
  3. Implement a database design using a relational database management system (DBMS)
    1. Basic characteristics
    2. Rules and definitions
    3. Table normalization
    4. Creating a relational design from entity relationship model
    5. SQL
    6. Programming language interfaces
  4. Describe means of protecting information and insuring confidentiality
    1. Database security
    2. Integrity
    3. Recovery
    4. Concurrency control
  5. Compare and contrast the design and capabilities of hierarchical, network and relational databases
    1. Hierarchical
    2. Network
  6. Describe the current capabilities of common databases in mainframe, micro computing and distributed environments
    1. Enterprise Applications
    2. Software-as-a-Service
    3. Web-Application integrated in distributed environments.

Lab Topics

  1. Implement RDBMS design process to create a database schema.
  2. Practice implementation of ER diagram with UML and Crow notation.
  3. Practice SQL Statement authoring for DML and DDL Operations
  4. Implementation of Set Theory in database design.
  5. Analyze customer requirements to produce a database design.
Back to Top