DATABASES

Course Information
TitleΒΑΣΕΙΣ ΔΕΔΟΜΕΝΩΝ / DATABASES
CodeNCO-05-03
FacultySciences
SchoolInformatics
Cycle / Level1st / Undergraduate
Teaching PeriodWinter
CoordinatorAnastasios Gounaris
CommonNo
StatusActive
Course ID40002945

Programme of Study: PPS-Tmīma Plīroforikīs (2019-sīmera)

Registered students: 10
OrientationAttendance TypeSemesterYearECTS
GENIKĪ KATEUTHYNSĪCompulsory Course537

Class Information
Academic Year2018 – 2019
Class PeriodWinter
Faculty Instructors
Weekly Hours6
Class ID
600121208
Type of the Course
  • Background
  • Scientific Area
  • Skills Development
Course Category
Specific Foundation / Core
Mode of Delivery
  • Face to face
Digital Course Content
Erasmus
The course is also offered to exchange programme students.
Language of Instruction
  • Greek (Instruction, Examination)
Prerequisites
General Prerequisites
There are no prerequisite courses in the formal sense. Students should master topics related to Programming, Data Structures, Algorithms
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.
General Competences
  • Apply knowledge in practice
  • Make decisions
  • Work autonomously
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.
Keywords
ER model. Relational model. Relational algebra. Dependencies and normalization. SQL.
Educational Material Types
  • Slide presentations
  • Book
Use of Information and Communication Technologies
Use of ICT
  • Use of ICT in Course Teaching
  • Use of ICT in Laboratory Teaching
Course Organization
ActivitiesWorkloadECTSIndividualTeamworkErasmus
Lectures52
Laboratory Work26
Project45
Exams6
Literature study81
Total210
Student Assessment
Description
Written exams (70%) and Lab exams (30%)
Student Assessment methods
  • Written Exam with Short Answer Questions (Formative, Summative)
  • Written Exam with Problem Solving (Formative, Summative)
Bibliography
Course Bibliography (Eudoxus)
Ιωάννης Μανωλόπουλος και Απόστολος Παπαδόπουλος: "Βάσεις Δεδομένων: Θεωρία και Πρακτική Εφαρμογή", Εκδόσεις Νέων Τεχνολογιών, Αθήνα, 2006.
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
Last Update
08-06-2016