CPSC 310 Database Management Systems

Learn about data modeling, design, normalization, data dictionaries, client server architecture, SQL, relational databases, and MySQL in this foundational level course on databases and their management systems. Special focus is provided on understanding the critical nature of information resources and why they must be carefully managed. The course uses examples and project-based assignments to support learning.

Credits

5

Cross Listed Courses

None

Prerequisite

MATH 200 & CPSC 210

Corequisite

None

Washington Technology University

Syllabus

CPSC 310 : Database Management Systems

5 Credits

Approved: 12/2/2021 2:17:08 PM

Course Description

Learn about data modeling, design, normalization, data dictionaries, client server architecture, SQL, relational databases, and MySQL in this foundational level course on databases and their management systems. Special focus is provided on understanding the critical nature of information resources and why they must be carefully managed. The course uses examples and project-based assignments to support learning.

Course Required Resources

Ricardo, C. (2017). Databases Illuminated. Burlington: Jones and Bartlett.

Course Keywords

Database management system, flat files, entities, attributes, cardinality, tables, constraints, referential integrity, normalization, normal forms, SQL, requirements gathering, ER modeling, Chen notation, deadlocks, data warehouses, big data