Data Bases - 22C901 (8th semester)
Course TitleData Bases
Course contentsThe course is introductory in databases with particular emphasis on the relational model and SQL. Introduction, conceptual database design. Data Modeling with Entity-Relationship Model, Relational Data Model,. Relational algebra, SQL, embedded SQL. Normalization. Internal Schema, files, indexes, multilayer indexes. Large databases, transactions, security, coordination of multiple transactions, database connections to the Internet, Interface of Relational Databases to XML. The lab includes guided analysis, design and database development using a web DBMS. The course includes optional groupwork
Name of lecture(s)Nikolaos Avouris, Polyxeni Stathopoulou

Learning outcomes At the end of this course the student should be familiar with basic principles of database systems, the design process of a data base..Further objective is to engage students in collaborative design of a database through group work.At the end of this course the student should be familiar with basic principles and technologies of modern web applications, and site design process. Further objective is to engage students in collaborative design of web applications through group work.
CompetencesDesign and implement database system with emphasis on relational databases. Translation of the requirements of a micro world on a entity relationship diagram, building of logical database model. Basic knowledge of SQL
PrerequisitesAlgorithms and data structures, computer systems organization
Recommended readingR. Elmasri, SBNavathe: Fundamentals of Database Systems, 4 edition,  
L. Ullman, Introduction to MySQL, Wesley,  
C.J. Date, An Introduction to Data Base Systems, Volume 1, 6th Edition, Addison Wesley Publ,
DM Kroenke, Database processing: Fundamentals, design & implementation, Prentice Hall. 2000
Teaching and learning methodsLectures (3 hours per week) using slides, including tutorials during which typical problems are solved and students are asked to solve problems either individually or in small groups. Similar problems are given to solve during the tutorial or at home. The Lab (2 hours / wk.) involves guided design and implemtation of a relational data base with support of teaching assistants. Finally more complex problems of DB design are given as group work to be dealt with in groups of 2-3 students
Assessment and grading methodsThe grading is based on performance in the final written exam that includes questions of theory and problems to solve. In addition, part of the final grade results from the marks given to laboratory exercises and group work.

Computer-supported collaborative learning has been an active area of research since the beginning for the HCI group more>>

Web usability team of the HCI Group has been active in studying human-web interaction and ways to support the design of accessible, findable, usable and aesthetically appealing web sites. more>>

Mobile Technology Unit of the HCI Group has been studying design and evaluation of mobile applicationss more>>

Hci Group | Electrical and Computer Engineering | University of Patras