Databases I
| Course Code | 321-3200 |
|---|---|
| Semester | 4 |
| ECTS | 5.00 |
| Hours (Theory) | 3 |
| Hours (Lab) | 2 |
| Instructor | Vlachou Akrivi |
Course Content
Introduction to Database Management Systems (DBMS). Databases. Database users. Advantages of using a DBMS. Schemas and instances. DBMS architecture. The principle of data independence. The entity-relationship, the relational and the object-relational model. Integrity constraints. Database update operations. Database languages. Relational algebra. Tuple and domain relational calculus. SQL as a query language: queries, views, update statements. Introduction to primary file organizations and indexes.
Learning Outcomes
The student that will complete successfully the course is expected that will be in position to:
- Analyze the requirements and design a database
- Apply the principles of conceptual and logical modeling and designing of databases
- Implement SQL queries in a database management systems
- Design well structured databases based on the normalization rules
- Understand the cost of processing a query on a database.
Prerequisites
Not required.
Teaching and Learning Methods
| Activity | Semester workload |
|---|---|
| Lectures | 39 hours |
| Laboratory Exercises | 26 hours |
| Personal study | 56 hours |
| Laboratory Exams | 2 hour |
| Final exams | 2 hours |
| Course total | 125 hours (5 ECTS) |
Assessment Methods / Grading
- short-answer questions
- problem solving
- laboratory work
Teaching Language
Greek (English for Erasmus students)