Active Outline

General Information

Course ID (CB01A and CB01B)
CIS D344A
Course Title (CB02)
Database Management Systems
Course Credit Status
Non-Credit
Effective Term
Fall 2024
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
Discipline 1
[Computer Information Systems (Computer network installation, microcomputer technology, computer applications)]
Discipline 3
[Computer Science]
FSA
[FHDA FSA - CIS]
Course Family
Not Applicable

Course Justification

This is a noncredit enhanced CTE course that is part of the certificate of completion in Database Development Practitioner. 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

Course Development Options

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

Transferability & Gen. Ed. Options

Transferability
Not transferable

Units and Hours

Summary

Minimum Credit Units
0.0
Maximum Credit Units
0.0

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)

NONCREDIT: (This is a noncredit enhanced, CTE course.)

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 TopiModern Database ManagementPearson2017. 13th edition9386873265
Mark Shellman, Hassan Afyouni, Philip J. Pratt, Mary Z. LastA Guide to SQLCengage Learning;2020, 10th Edition978-0357361689

Examples of Supporting Texts and References

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

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

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

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 an entity-relationship model
    5. SQL
    6. Programming language interfaces
  4. Describe means of protecting information and ensuring 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