'CISD' -- CIS Database Courses
 
   
 

 
CISD 40 Course Image

CISD 40 - Database Design  (3.0 units)
In this course, students will:
  • analyze database needs and functions
  • create data models
  • create Entity-Relationship (E-R) diagrams
  • create UML diagrams
  • use normalization rules and principles to create properly-designed databases
  • learn basic DBA objectives and tasks
The student receives extensive hands-on instruction on a Windows-based personal computer.
(27 hours lecture;  27 hours lab;  Degree appropriate)
Advisory Prerequisite:   CISD 11 - Database Management - Microsoft Access

Course Measurable Objectives:

  1. Understand the functions of database application.
  2. Learn to apply normalization techniques to a database.
  3. Create and properly interpret both UML and E-R diagrams.
  4. Transform E-R and UML diagrams into relational designs.
  5. Evaluate the need for security and use specific techniques in securing a database.

Course Level Student Learning Outcomes:


Students completing CISD 40 - Database Design will be able to:
  1. apply normalization rules to database design.
  2. create E-R (Entity Relationship) and UML (Unified Modeling Language) diagrams for a given database scenario.
Send questions or comments about this Web site to the  Business Division's  Web Content Manager .
Use of this Web server is subject to the Mt. San Antonio College   Terms of Use  and  Privacy Policy .
 
   
Invisible Login Button