vcc.ca
CSTP 1201: Introduction to Database Management Systems
Effective date
September 2022
Department
Computer Systems Tech Diploma
School
Trades, Technology and Design
Description
In this course students will learn how to manage SQL database systems, including performing basic database administration. Students will learn how to configure a database to support different applications and to perform tasks such as creating users and database schema, applying constraints, setting up access control, assigning memory, defining storage structures and manipulating data. Since database administration does not end after the database is created, students will learn the importance of backup and recovery strategy. Students will become familiar with fundamental concepts in the field such as transnational operations, ACID property, backup and redundancy, data integrity, various database roles (database admin, database programmer, database designer), database normal forms, join operations, and how to perform queries.
Credits
4.0
Year of study
1st Year Post-secondary
Prerequisites
CSTP 1105.
Corequisites
None
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Explain the basics of Structured Query Languages (SQL) for databases
- Describe the steps in designing a SQL database
- Create databases and tables, transaction logs and database snapshots
- Explain ACID properties of a well designed SQL database
- Explain JOINs and how to use them in SQL databases
- Apply data relationships to maintain data integrity
- Create queries that select data from tables
- Explain Normalization and DeNormalization in the design of databases
- Create stored procedures and triggers
- Design forms to create a user interface
- Explore performance tuning and troubleshooting strategies
- Perform general DB Admin: backup and restore
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Lecture, Online, Seminar, Tutorial: 40
Clinical, Lab, Rehearsal, Shop, Kitchen, Simulation, Studio: 40
Total Hours: 80
Clinical, Lab, Rehearsal, Shop, Kitchen, Simulation, Studio: 40
Total Hours: 80
Instructional Strategies
Instructional strategies include classroom lectures, demonstrations, group discussions, computer lab and hands-on practical work.
Grading System
Letter Grade (A-F)
Passing grade
C
Evaluation Plan
|
Type |
Percentage |
Assessment activity |
|
Assignments |
40 |
4 project assignments, could be individual or team projects |
|
Midterm Exam |
20 |
|
|
Final Exam |
20 |
|
|
Participation |
5 |
Could contain quizzes. |
|
Project |
15 |
Final project |
Course topics
- SQL databases
- Entity Relational Diagrams
- Data tables and normalization
- Queries and tables
- Queries and manipulating data
- SQL Stored Procedures
- Forms and reports functionality
- Code procedures and functions
- Triggers
- ACID property of a well designed db
- JOIN for db queries
- DB Admin: Backup, Restore
Notes:
- Course contents and descriptions, offerings and schedules are subject to change without notice.
- Students are required to follow all College policies including ones that govern their educational experience at VCC. Policies are available on the VCC website at:
https://www.vcc.ca/about/governance--policies/policies/. - To find out if there are existing transfer agreements for this course, visit the BC Transfer Guide at https://www.bctransferguide.ca.