|
|
|
May 04, 2024
|
|
Catalog 2019-2020 [ARCHIVED CATALOG]
|
CSD 331 Database Modeling and Design5 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 , CSD 321 , 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
Global Outcomes
This course teaches to the global outcome of communication.
Total Hours: 60 Lecture Hours: 40 Lab or Clinical Hours: 20
|
|
|
