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

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