Databases

Upon completion of the course, students will have acquired the basic knowledge and skills necessary to design and implement a Database. More specifically they will be able to:

• develop an understanding of the role as well as the advantages of DBSs in data management.

• data management procedures.

• describe the key elements as well as the architecture of a database system.

• understand the DB design process.

• understand the use of high-level model’s data structure.

• limitations of the relational data model.

Knowledge

• Describes and analyzes the main principles of Database design.

• Knows the measurement methods and instruments needed to resolve a problem.

• Knows the calculation methods which will be needed to resolve any problem.

• Knows how to implement the E/R diagrams

• Can develop critical thinking and responsible scientific and professional behavior.

Skills

• During the laboratory exercises the students are requested to apply combinatorial methods for answering.

• At the same time, the homework is structured in such a way as to encourage critical thinking and ability

Competences

• Extensive knowledge and critical understanding of the theory and principles of Database design.

• Acquisition, analysis and reporting of data

• Team work

The general skills which a student should have acquired and the ones the course aims for are:

· Search, acquire, analyze and synthesize data.

• Analysis and reporting of information

• Applications (Exercises)

• Decision making

• Group Assignment exercises (Discussion ability, enhancing self-thinking and accuracy of implementation

• Understanding the basic principles of Databases

During this course the students learn about the basic concepts of Databases, and design exercises in Ms Access. They learn about the current trends and technological advancements in the field of databases management. The course consists of the following 13 lectures:

Lecture 1: Introduction / Basic concepts

Lecture 2: Data Models

Lecture 3: Introduction to MS Access

Lecture 4: The concepts of the Entity-Relationship Diagram

Lecture 5: Relational Database Schema (I)

Lecture 6: Relational Database Schema (II)

Lecture 7: Relational algebra

Lecture 8: E/R diagram to Relational Database Schema

Lecture 9: Entity-Relationship Diagram applications/ exampled

Lecture 10: Introduction to SQL

Lecture 11: Data management using SQL/Data searching using SQL

Lecture 12: Normalization

Lecture 13: Open Source Software for Databases

*Evaluation Criteria*	*Determination of weight*
Written exams	70%
Projects	30%

The evaluation criteria are accessible to students from the course’s website and are announced repeatedly in both lecture lectures and laboratory courses. During the semester, students are informed about the grades/scores of the laboratory exercises through the e-class platform.

Transparency in evaluation is ensured in the following ways:

a) Students are aware of the evaluation’s measures from the first week of the semester
b) For each laboratory exercise they deliver, they are informed of the score/grade and of their errors. Then they can resubmit the corrected version of the exercise.
c) Finally, when the results of the written exams are announced, students have a reasonable amount of time (updated through an announcement) to ask for re-evaluation

Εισαγωγή στις Βάσεις Δεδομένων, Βασίλειος Τ. Ταμπακάς
Σχεσιακές βάσεις δεδομένων - Νέα αναθεωρημένη έκδοση, Κεχρής Ευάγγελος

» Undergraduate Programme

Contact info

News