Programming & DataBases

LEARNING OUTCOMES

The objectives of this course are:

• understanding the operation and structure of a relational database system
• the development of skills related to the design of relational databases
• programming databases using the SQL language

Upon successful completion of the course the student will be able to:

• apply the main techniques for designing, modeling and implementation of simple databases
• use the main techniques of the SQL language In order to implement database systems
• understand and apply the advantages of relational databases in information management
• combine procedural and declarative programming techniques for management purposes and information processing in Geographic Information Systems

 

General Competences

• Search, analysis and synthesis of data and information, using the appropriate technologies
• Individual work
• Project design and manipulation
• Work in an interdisciplinary environment
• Promotion of creative and inductive thinking

 

SYLLABUS

Types of databases. System’s architecture. Entity-Relation model. Relational data model. Normalization. Data management operations. Relational algebra. Introduction to SQL. Tables, creating tables. Data types. The concept of primary key. Field properties. Value field integrity. Relationships between tables. Questions and criteria. Complex questions based on multiple tables. Views and aggregate functions. Calculated fields. Forms, reports, grouping and ordering in reports. Table management. Integrity restrictions. Hierarchical structures and networks. Procedures. Triggers. Database development in MySQL, MS-Access and phpMyAdmin. SQL extensions.

 

STUDENT PERFORMANCE EVALUATION

I. Written final examination that includes:
– Short answer questions
– Problem solving
II. Midterm written examinations
III. Projects

The examination material and the evaluation process are announced to the students during the lectures and are also posted on the course’s website.

 

ATTACHED BIBLIOGRAPHY

In Greek:
1. Κεχρής Ευάγγελος, 2015, Σχεσιακές βάσεις δεδομένων, Εκδόσεις Κριτική.
2. Μανωλόπουλος Ι., Παπαδόπουλος Α., 2006. Συστήματα Βάσεων Δεδομένων: θεωρία και πρακτική εφαρμογή. Εκδόσεις Νέων Τεχνολογιών.
3. Στεφανάκης Ε., 2010. Βάσεις Γεωγραφικών Δεδομένων και Συστήματα Γεωγραφικών Πληροφοριών. Εκδόσεις Παπασωτηρίου.
4. Elmasri R. Navathe S.B., 2007. Θεμελιώδεις Αρχές Συστημάτων Βάσεων Δεδομένων. Εκδόσεις Δίαυλος
5. Connolly T. M., Begg C. E., 2001. Συστήματα βάσεων δεδομένων. Εκδόσεις Ίων.

 

In English:
1. Carter J., 2002. Database Design and Programming with Access, SQL, Visual Basic and ASP. McGraw Hill
2. Rockoff L., 2010. The Language of SQL: How to Access Data in Relational Databases. Cengage Learning PTR.