Introduction to DBMS architectures and file organization. Presentation of data models and methodologies for the design of (relational) data bases. Relational model: structures, algebra, calculus, database normalization theory. Operational topics: query optimization, recovery, concurrent access, security, semantic file and system structure, indexing and hashing query optimization, recovery, concurrency control, security, semantic integrity.
Learning objectives:
with the completion of this course, students will have obtained
familiarization with conceptual modeling processes,
understanding of the structure and semantics of the relational data model and of languages for data management and querying,
familiarization with the use of SQL,
understanding of normalization theory and of formal approaches to database design,
understanding of operational aspects of database management systems
Grading:
Specific details on grading can be found on the course’ s website
The courses of the Computer Science Department are designated with the letters "CS" followed by three decimal digits. The first digit denotes the year of study during which students are expected to enroll in the course; the second digit denotes the area of computer science to which the course belongs.
First Digit
Advised Year of Enrollment
1,2,3,4
First, Second, Third and Fourth year
5,6
Graduate courses
7,8,9
Specialized topics
Second Digit
Computer Science Area
0
Introductory - General
1
Background (Mathematics, Physics)
2
Hardware Systems
3
Networks and Telecommunication
4,5
Software Systems
6
Information Systems
7
Computer Vision and Robotics
8
Algorithms and Theory of Computation
9
Special Projects
The following pages contain tables (one for each course category) summarizing courses offered by the undergraduate studies program of the Computer Science Department at the University of Crete. Courses with code-names beginning with "MATH" or "PHYS" are taught by the Mathematics Department and Physics Department respectively at the University of Crete.