DATABASES

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

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

Registered students: 304
OrientationAttendance TypeSemesterYearECTS
GENIKĪ KATEUTHYNSĪCompulsory Course537
Class Information
Academic Year2020 – 2021
Class PeriodWinter
Faculty Instructors
Instructors from Other Categories
Weekly Hours6
Class ID
600176698
Course Type 2021
Specific Foundation
Course Type 2016-2020
  • Background
Course Type 2011-2015
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
Cognitive: Understanding of the concept of massive data management (using secondary memory). Knowledge acquisitionof designing applications with massive data. Mastering SQL. Acquaintance of MS SQL Server to design, implement, define and manipulate a database (SQLite Lab). Skills: be capable of designing, developing and processing 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 SLite
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 project and 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
10-04-2022