Database Systems
General
Code: BSC_IT18
Language: English
Delivery: In person
Prerequisites: None
Workload
- Lectures: 39.0 hours
- Lab: 13.0 hours
- Study: 88.0 hours
- Project: 60.0 hours
Course Content
Week 1: Introduction to database systems
Week 2: Data modeling – ER diagrams
Week 3: ER to relational model
Week 4: SQL basics – SELECT, WHERE
Week 5: Joins
Week 6: Aggregations (GROUP BY, HAVING)
Week 7: Subqueries
Week 8: DDL (CREATE, ALTER, DROP)
Week 9: DML (INSERT, UPDATE, DELETE)
Week 10: Normalization
Week 11: Indexes and query optimization
Week 12: Transactions and ACID properties
Learning Outcomes
Upon successful completion of the course, students will be able to:
Understand core concepts of database systems
Design relational databases using ER modeling
Use SQL effectively
Define and manipulate database structures (DDL)
Manage data using SQL (DML)
Write complex queries (joins, subqueries, aggregations)
Apply integrity constraints
Understand normalization principles
Analyze and improve query performance
Use a DBMS (e.g., PostgreSQL, MySQL) in practical scenarios
Skills
The course fosters the following competences:
Search for, analysis and synthesis of data and information, with the use of the necessary technology
Adapting to new situations
Decision-making
Working independently
Team work
Working in an international environment
Working in an interdisciplinary environment
Production of new research ideas
Project planning and management
Respect for difference and multiculturalism
Respect for the natural environment
Showing social, professional and ethical responsibility and sensitivity to gender issues
Criticism and self-criticism
Production of free, creative and inductive thinking
Others:
Database design and management
Data modeling and analysis
Query optimization
Practical SQL proficiency