Databases
General
Code: ΥΠ16
Language: Greek
Delivery: Face-to-face
Prerequisites: Data structures
Workload
- Lectures: 32.5 hours
- Lab: 19.5 hours
- Study: 46.0 hours
- Project: 70.0 hours
Course Content
The Database Environment. Database Development Process. The Entity-Relationship E-R Model. Logical Database Design and the Relational Database Model. Integrity constraints. Transformation of the E-R diagram to a Relational DB Schema. Database Update. Database Management Languages. Relational Algebra. Relational calculus. SQL as a data management language: queries, views, updates. Introduction to the DB file management and indexing structures.
Learning Outcomes
The aim of the course is to assist students understand the basic concepts of Database Management Systems DBMS and become familiar with the process of creating a database. Students will understand the need for constraints and how the database constraints affect the modification of data in the database. Finally, students will become familiar with basic SQL commands through their application in a real DBMS. At the end of the course the students must be able to:
- Understand the role of constraints in database creation and updates
- Use SQL in real database environment
Skills
- Adaptation in new conditions
- Independent work
- Team work