Learning Outcomes
Cognitive: Learning ideas and database concepts, database management tools and database applications.
Skills: After the course completion students will have the ability to design and manage Databases. Moreover, they will have the ability to perform specific actions on database management systems and in other helping software tools. In addition, the assignments will help students to gain additional knowledge and solve practical problems.
Course Content (Syllabus)
Introduction, Database Architecture, Modeling data with entity-relationship model, Relational model and relational algebra, SQL language, Relational calculus and multi-valued Functional Dependencies, Normal forms. Lab exercises.
Keywords
databases, entity-relationship model, relational model, relational algebra, SQL language, functional dependencies, normal forms
Additional bibliography for study
- Ιωάννης Μανωλόπουλος και Απόστολος Παπαδόπουλος: "Βάσεις Δεδομένων: Θεωρία και Πρακτική Εφαρμογή", Εκδόσεις Νέων Τεχνολογιών, Αθήνα, 2006.
- H. Garcia-Molina, J.D. Ullman, J.D. Widom, "ΣΥΣΤΗΜΑΤΑ ΒΑΣΕΩΝ ΔΕΔΟΜΕΝΩΝ, ΤΟΜΟΣ Ι", Πανεπιστημιακές Εκδόσεις Κρήτης, 2011.
- R. Ramakrishnan, J. Gehrke, "Database Management Systems", McGraw-Hill, 2002.
- C. J. Date, "Introduction to Database Systems", Addison Wesley, 2003.
- R. Elmasri, S.B. Navathe, "Fundamentals of Database Systems", Addison Wesley, 2006.
- A. Silberschatz, H.F. Korth, S. Sudarshan, "Database System Concepts", McGraw-Hill, 2005.