SMI1001Winter 2024Databases
← Back to university path
Databases I
Detailed view of the course, studied concepts, technologies used, and major academic work associated with it.
Code
SMI1001
Session
Winter 2024
Domain
Databases
Overview
Introductory course on relational databases covering both theoretical foundations and practical aspects. It helped me learn how to model data, design relational schemas, use SQL to manipulate data, and understand normalization and integrity principles in a database management system.
Technologies used
SQLOraclePL/SQLTOADModélisation relationnelle
Key concepts covered
- Introduction to databases and DBMS
- Database users and their needs
- Database management system architecture
- Database design
- Entity-Relationship model
- UML modeling applied to data
- Relational model
- Relational algebra and relational calculus
- View concept
- SQL: data manipulation language (DML)
- SQL: data definition language (DDL)
- Integrity constraints
- Null values and missing data
- Functional dependencies
- Database normalization
- Normal forms: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF
- Multivalued dependencies and join dependencies
- Introduction to object-relational and multidimensional databases
- Introduction to multimedia data and XML
Coursework and evaluated components
- Database design and modeling exercises
- Data manipulation with SQL
- Practical work using Oracle, PL/SQL, and TOAD
- Team assignment applying course concepts
- Midterm exam
- Final exam