Learning Outcomes
Understanding of the concept of massive data management (using secondary memory). Knowledge of designing applications with massive data. Mastering SQL. Acquaintance of MS SQL Server to design, implement, define and manipulate a database.
Course Content (Syllabus)
Introduction. Storage media. System architecture. Entity-relationship model. Relational model. Relational algebra and relational calculus. Functional and multivalued dependencies. Normalization and Normal forms. SQL language. Mandatory lab exercises with MS SQL Server.
Additional bibliography for study
- 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