Catalog 2017-2018 
    Nov 19, 2018  
Catalog 2017-2018 [ARCHIVED CATALOG]

CSD 331 Database Modeling and Design

5 credits
This course introduces relational database schema design using real-life data examples. Advanced data management topics are examined, including data modeling, normalization, analysis of query efficiency, usage of stored procedures, and triggers. Non-relational (NoSQL) databases used with Big Data are introduced and compared with RDMS.

Prerequisites: CSD 138 , CSD 321 , MATH 220 , and admission to the BAS IT:CSD program

Quarters Offered: Spring

Student Outcomes/Competencies:
Upon successful completion of this course students will be able to: 

  • Query and update relational database
  • Gather requirements for designing of a real-life database
  • Properly design RDBMS schema
  • Use entity-relationship modeling tools
  • Evaluate performance issues and create database indexes
  • Create database views
  • Describe principles of pessimistic and optimistic concurrency control methodologies
  • Identify and implement database integrity constraints
  • Explain usage cases for stored procedures and triggers
  • Normalize a Database Schema
  • Explain the advantages of three normal forms
  • Explain issues related to database security and ways to secure a database
  • Explain design and implementation issues specific to distributed databases
  • Demonstrate knowledge of non-relational database models and compare them to relational model

Total Hours: 60 Lecture Hours: 40 Lab or Clinical Hours: 20