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.
• 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.
• 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
• 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 11: Data management using SQL/Data searching using SQL
Lecture 12: Normalization
Lecture 13: Open Source Software for Databases
Determination of weight
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
Εισαγωγή στις Βάσεις Δεδομένων, Βασίλειος Τ. Ταμπακάς
Σχεσιακές βάσεις δεδομένων - Νέα αναθεωρημένη έκδοση, Κεχρής Ευάγγελος