COMP 4754: Database Systems
This course is an elective for the Data-centric Computing Stream.
This course will be of interest to those students who wish to have an introduction to the problems involved in dealing with large amounts of data.
Availability: This course is usually offered once per year, in Fall or Winter.
To introduce students to database processing, database management systems and database design considerations. Additional topics covered include the theory and methodologies essential for the relational database design, implementation, manipulation, optimization and management.
- Assignments and Project 40%
- In-class Exam 20%
- Final Exam 40%
Representative Course Outline
- Introduction to databases and database management systems
- Entity relationship model
- Database design
- Requirement analysis
- Conceptual modelling
- Implementation design
- Physical design
- Modelling of data for various database models
- Dependencies, normal forms and other database design considerations
- Some sample query languages and query processing
- Query optimization
- Security and integrity
- Distributed databases
Page last updated May 24th 2021