Databases I

Databases I

Code:
Semester:
Type:
Direction:

P1-3030
3rd
Compulsory

Course hours:
Instructors:

Links:

3  Lec – 1 Lab
Christos Skourlas (Faculty), George Prezerakos (Faculty)

Description

Databases, Data Base Systems (DBS), Data Base Management Systems (DBMS), Architecture of DBMS. Data structures and Databases. Hierarchical model, Network model, Relational Model. Relational Algebra, Relational Calculus, Query By Example (QBE). Data Independence, Data Redundancy, Data consistency, Data Integrity and Integrity Rules, Constraints etc. Database Design. Normalization. Functional dependencies. Entity Relationship Model. Structured Query Language (SQL) and SQL3. Views, Updatable views. Database integrity, Recovery, and Security. The role of the Data Base Administrator. Transactions processing. Introduction to Physical Storage Structures.