CPSC 3300: Fundamentals of Databases

About

Fundamental concepts of database design and applications, including relational database design, entity-relationship (ER) model, standard query language (SQL), transaction management, and triggers. Design and development of applications using databases.

Prerequsites

Take CPSC-2430; Minimum grade C; - Must be completed prior to taking this course.

Learning Outcomes

• Create logical entity-relationship (ER) models of varying complexity
• Apply normalization
• Create physical databases from logical models
• Use SQL to manipulate data
• Create database triggers and transactions
• Develop web applications using databases

SQL: A platform used to help create diagrams based off ER diagrams
Example of ER Diagram