Introduces relational database theory, SQL querying, and data modeling for effective information storage and retrieval.
About this course
COMP 1400 Database Management Systems introduces the core concepts of relational database theory, SQL querying, and data modeling. You will learn how to design effective information storage systems and retrieve data efficiently. The course covers the full lifecycle of database development, from initial requirements gathering to implementation and maintenance.
You will work with industry-standard database management systems to build practical solutions. This course is designed for students who need a strong foundation in data handling, whether you plan to specialize in software development, network administration, or data analytics.
Who takes this course
This course is an elective open to students in any Computing & Information Technology program. It is particularly useful for those in Computer Systems Technology and Network & Cloud Administration who want to strengthen their backend skills.
Credits: 3 · Hours: 45
Prerequisites
Learning outcomes
- Explain the principles of relational database design and normalization.
- Construct complex SQL queries to insert, update, and retrieve data.
- Create and manage database schemas using data modeling tools.
- Implement basic security controls and user access permissions.
Evaluation
| Component | Weight (%) |
| Quizzes | 20 |
| Lab assignments | 40 |
| Mid-term exam | 20 |
| Final project | 20 |