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
|
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:
Pedion Areos, 383 34, Volos
+30 24210 74452-55
+30 24210 74380
g-prd@prd.uth.gr