Nov 24, 2024  
Catalog 2024-2025 
    
Catalog Navigation
  Catalog Home

  Programs by School
  Programs by Degree and Certificate Type
  Alphabetical List of Programs
  Course Descriptions

  General Information
  Enrollment Services
  Tuition and Financial Aid
  Academic Information
  Support Services
  Directory

  Archived Catalogs
HELP
Catalog 2024-2025

CSD 331 Database Modeling and Design

5 credits
The 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, and usage of stored procedures and triggers. Non-relational (NoSQL) databases used with Big Data are introduced and compared with RDBMS.

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

Course Outcomes
Upon successful completion of this course students will be able to: 

  • Query and update relational databases
  • Gather requirements for designing a real-life database
  • Properly design RDBMS schema
  • Use entity-relationship modeling tools
  • Evaluate performance issues and create database indices
  • 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 models

Program Outcomes
This course teaches to the following program outcomes:

  • demonstrate competency in software engineering, software testing principles, and quality assurance techniques
  • identify, evaluate, and apply efficient algorithms and technologies required for developing software system
  • demonstrate ability to understand and integrate contributions to the architecture design of a large software system
  • be prepared to obtain an entry-level position at a software development company

College-Wide Learning Outcomes
This course teaches to the college-wide learning outcome of Communication, the ability to engage effectively in verbal, non-verbal, written, and/or symbolic expression.

Total Hours: 60 Theory (Lecture) Hours: 40 Guided Practice (Lab or Clinical) Hours: 20