|
|
Apr 19, 2024
|
|
Catalog 2018-2019 [ARCHIVED CATALOG]
|
CSD 331 Database Modeling and Design5 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
|
|
|