• enEnglish
    • elΕλληνικα (Greek)
  • Shortcuts
    • International Relations Office (IRO)
    • Time Schedule
    • Library & Information Centre
    • Phonebook (in greek)
PRD-UThPRD-UThPRD-UThPRD-UTh
Department of Planning and Regional Development
School of Engineering
University of Thessaly
  • Home
  • The Department
    • The Department and its Location
    • The Department in the Local and Academic Community
    • Administrative Structure
    • Opinions of Graduates
    • Establishments
  • Studies
    • Undergraduate Programme
      • Presentation
      • Courses
      • Time Schedule
    • Graduate Programs
      • Master in Urban Regeneration, Urban Development & Real Estate [URUDRE]
        • Courses
      • Master in Sustainable Management of Environmental Change and Cyclical Economy [SMECCE]
        • Courses
      • Master in Project Management, Transportation and Spatial Planning (PMTSP)
        • Courses
      • Master in Tourism and Cultural Planning and Development (TCPD)
        • Courses
      • Masters in Strategic Management and Competitiveness (SMC)
        • Presentation (in greek)
    • Doctoral Studies
    • Postdoctoral Research
  • Research
    • Scientific editions
      • Research – Discussions Papers
      • e-journal “Aeihoros”
      • Institutional Repository
    • Research Units
      • Research Unit of Computer Science Applications in Spatial Planning
      • Research Unit of Demographic and Social Analysis
      • Research Unit of Evaluation of Development Policies and Programs
      • Research Unit of Environment and Spatial Planning [ESPL]
      • Research Unit of Geographical Research and Environmental Planning [GREENPLAN]
      • Research Unit of Infrastructure, Technology Policy and Development [RUITPOD]
      • Research Unit of Regional Economic Analysis and Policy
      • Research Unit of Rural Space
      • Research Unit of Spatial Analysis, GIS and Thematic Mapping
      • Research Unit of Tourism Planning, Research and Policy
      • Research Unit of Urban Space Morphology
      • Research Unit of Urban and Spatial Planning
    • Research Centers
      • Informations System Center
  • Staff
    • Faculty Members
    • Research and Technical staff
    • Other Faculty
    • Adjunct Faculty
    • Administrative Staff
  • Support
    • Secretary
    • International Relations Office (IRO-UTH)
    • Library & Information Centre
  • Contact
Databases

Databases

Code
ΜΕ1000
Category
Elective
Semester
5th Semester, 7th Semester, 9th Semester
Thematic field(s)
S1-MSA: Methods of Spatial Analysis
Hours (weakly)
3
ECTS
5
Workload (h)
125
Instructor(s)
  • Panayiotis Manetos
  • Course goal
  • Course subject
  • Assessment
  • Bibliography
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:

  1. a) Students are aware of the evaluation’s measures from the first week of the semester
  2. 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.
  3. 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
  • Εισαγωγή στις Βάσεις Δεδομένων, Βασίλειος Τ. Ταμπακάς
  • Σχεσιακές βάσεις δεδομένων - Νέα αναθεωρημένη έκδοση, Κεχρής Ευάγγελος

Contact info


Pedion Areos, 383 34, Volos

+30 24210 74452-55

+30 24210 74380

g-prd@prd.uth.gr

News

  • Events
  • Academic
  • Administrative

ΣΥΝΔΕΣΜΟΙ

  • The Department
    • The Department and its Location
    • Administrative Structure
    • The Department in the Local and Academic Community
© Τμήμα Μηχανικών Χωροταξίας, Πολεοδομίας και Περιφερειακής Ανάπτυξης | Πολυτεχνική Σχολή | Πανεπιστήμιο Θεσσαλίας
  • Home
  • The Department
    • The Department and its Location
    • The Department in the Local and Academic Community
    • Administrative Structure
    • Opinions of Graduates
    • Establishments
  • Studies
    • Undergraduate Programme
      • Presentation
      • Courses
      • Time Schedule
    • Graduate Programs
      • Master in Urban Regeneration, Urban Development & Real Estate [URUDRE]
        • Courses
      • Master in Sustainable Management of Environmental Change and Cyclical Economy [SMECCE]
        • Courses
      • Master in Project Management, Transportation and Spatial Planning (PMTSP)
        • Courses
      • Master in Tourism and Cultural Planning and Development (TCPD)
        • Courses
      • Masters in Strategic Management and Competitiveness (SMC)
        • Presentation (in greek)
    • Doctoral Studies
    • Postdoctoral Research
  • Research
    • Scientific editions
      • Research – Discussions Papers
      • e-journal “Aeihoros”
      • Institutional Repository
    • Research Units
      • Research Unit of Computer Science Applications in Spatial Planning
      • Research Unit of Demographic and Social Analysis
      • Research Unit of Evaluation of Development Policies and Programs
      • Research Unit of Environment and Spatial Planning [ESPL]
      • Research Unit of Geographical Research and Environmental Planning [GREENPLAN]
      • Research Unit of Infrastructure, Technology Policy and Development [RUITPOD]
      • Research Unit of Regional Economic Analysis and Policy
      • Research Unit of Rural Space
      • Research Unit of Spatial Analysis, GIS and Thematic Mapping
      • Research Unit of Tourism Planning, Research and Policy
      • Research Unit of Urban Space Morphology
      • Research Unit of Urban and Spatial Planning
    • Research Centers
      • Informations System Center
  • Staff
    • Faculty Members
    • Research and Technical staff
    • Other Faculty
    • Adjunct Faculty
    • Administrative Staff
  • Support
    • Secretary
    • International Relations Office (IRO-UTH)
    • Library & Information Centre
  • Contact
  • enEnglish
    • elΕλληνικα (Greek)
PRD-UTh