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 Outcomes:
Students completing the course will be able to: Knowledge: understand the structure and semantics of the relational data model as well as standard languages for manipulating data and formulating queries. Familiarize themselves with using the standard SQL language. Understanding: understand the theory of normalization and the standard approach to database design as well as functional aspects of database management systems. Application: reuse existing knowledge and methodologies to design efficient databases according to specific requirements. To apply their knowledge for the development of an information system (a combination of high-level programming languages and a database management system). Analysis: take a structured approach to the process of the conceptual modeling of a problem and capturing it using a relational data model. Synthesis: combine individual tools and methodologies to solve complex data management problems and construct efficient databases creatively, clearly and correctly. Evaluation: evaluate the advantages and disadvantages of database systems as well as different conceptual models.
Student Performance Evaluation:
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.