Course: Databases and Data Management
Code: CSC301
Semester: Β΄
Instructor: E. Petraki
Course link in E-Class https://eclass.uoa.gr/courses/ECON397/
Description
The course aims at providing knowledge on fundamental issues about database systems, design and development of Relational Databases, Structured Query Language (SQL), and popular Database Management Systems. Topics related to data structures, data and function modeling, methodologies and languages for data retrieval are also presented. Finally, issues related to the analysis, design and implementation of specific Financial and Administrative databases are studied.
Course outline
- Introductory concepts: Data and Information, Storage Units, Data Files, Data Structures
- Databases and Data Models
- Architectural overview of Database Systems
- Conceptual Database Design and Entity Relationship Diagrams
- Relational model, transforming ER diagrams to relational databases
- Introduction to Relational Algebra
- Relational Database Design Principles and Normal Forms (Normalization)
- Methodologies and query languages. The Structured Query Language (SQL)
- Presentation of Financial and Administrative applications: analysis, design, implementation
- NoSQL Databases. Trends in data management and information retrieval
Laboratory exercises
The course includes laboratory exercises which involve practical training on the course’s subject, under the supervision of the tutor. Students are divided into groups for laboratory training. The goal of the laboratory courses is to familiarize them with popular Database Management Systems. Specifically, students are taught MS-Access environment. An introduction about creating and managing databases using SQL commands is also held using Oracle and MySQL DBMSs.
Project
During the semester, students work το create a complete database project. The project is divided into steps and starts the second week of the semester. The first step is the definition of database requirements. Next steps are the conceptual DB design and the implementation in MS-Access environment. The project is gradually developed, and each step is completed during the semester after the relevant theoretical lecture.
Textbooks
- Kehris Evangelos, Relational Databases, New revised edition, Kritiki A.E. Publications, 2015.
- Stavrakoudis Athanasios, Databases and SQL: A practical approach, 2nd edition, Klidarithmos EPE Publications, 2015.
- R. Ramakrishnan, J. Gehrke: Database Management Systems, 3rd Edition. Volume A, A. Tziola Publications, 2012
- R. Elmasri, S.B. Navathe, Fundamentals of Database Systems, Translation - Scientific Editing Michalis Hatzopoulos, Εκδόσεις Diavlos Publications, 2012.
- Jeffrey Ullman, Jenniffer Widom, Fundamentals of Database Systems, Klidarithmos EPE Publications, 2008.
- Ε.J.Yannakoudakis: Database Systems , B’ Edition, Volume Α, E. Benou Publications, 2009.
