Πρόγραμμα
| Εβδομάδα | Δ/Φ | Περιγραφή | Βιβλιογραφία | Υλικό |
| 1 | Δ | Introduction I: Syllabus & Introduction to Databases Course Objectives and Syllabus, Database Types and Applications, Basic Definitions, Basic Operations in a Databasem, A Database Example, Basic Advantages of using a Databases (as opposed to Files) |
Chapter 1.1-1.3, Elmasri-Navathe. Fundamentals of Database Systems 5ED | |
| Φ | Το φροντιστήριο δεν θα γίνει | |||
| Δ | Introduction II: Database Users and Database System Concepts and Architecture Database Users and Responsibilities, More Advantages of Using the DBMS Approach, A Brief History of Database Applications, When Not to Use a DBMS, Data Models, Schemas, and Instances |
Chapter 1.4-1.9, 2.1, Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| 2 | Δ | Introduction III: Database System Concepts and Architecture Three-Schema Architecture and Data Independence, Database Languages and Interfaces, The Database System Environment, Centralized and Client/Server Architectures for DBMSs, Classification of Database Management Systems |
Chapter 2.2-2.7, Elmasri-Navathe. Fundamentals of Database Systems 5ED | |
| Φ | Φροντιστήριο 1: Introduction to Databases | Εκφώνηση | Λύσεις | |
| Δ | Entity-Relationship Model I: Data Modeling Using the Entity-Relationship (ER) Model Using High-Level Conceptual Data Models for Database Design, An Example Database Application, Entity Types, Entity Sets, Attributes, and Keys |
Chapter 3-3.3, Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| 3 | Δ | Entity-Relationship Model II: Data Modeling Using the Entity-Relationship (ER) Model Relationship Types, Relationship Sets, Roles, and Structural Constraints, Weak Entity Types, Refining the ER Design for the COMPANY Database, ER Diagrams, Naming Conventions, and Design Issues |
Chapter 3.4-3.7, Elmasri-Navathe. Fundamentals of Database Systems 5ED | |
| Φ | Φροντιστήριο 2: ER Modeling | Εκφώνηση | Λύσεις | |
| Δ | Entity-Relationship Model III: ER + The Enhanced Entity-Relationship (EER) Model Relationship Types of Degree Higher Than Two, Designing Tools, Enhanced Entity-Relationship (Subclasses, Superclasses, and Inheritance, Specialization and Generalization, Constraints and Characteristics of Specialization and Generalization Hierarchies, Modeling of UNION Types Using Categories, An Example UNIVERSITY EER Schema) |
Chapter 3.8, 4.1-4.4, Appendix A, Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| 4 | Δ | Relational Model I |
Chapter 5.1-5.2, Elmasri-Navathe. Fundamentals of Database Systems 5ED | |
| Φ | Φροντιστήριο 3: ER + EER Modeling | Εκφώνηση | Λύσεις | |
| Δ | Relational Model II Relational Constraints (Key, Entity, Referential Integrity, Domain), Update Operations, Transactions, and Dealing with Constraint Violations |
Chapter 5.2-5.3 Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| 5 | Δ | Relational Algebra I Introduction, Unary Relational Operations: SELECT (σ), PROJECT (π), RENAME (ρ), Relational Algebra Operations from Set Theory (UNION, INTERSECTION, MINUS, SYMMETRIC DIFFERENCE), Binary Relational Operations: JOIN |
Chapter 6.1-6.3, Elmasri-Navathe. Fundamentals of Database Systems 5ED | |
| Φ | Φροντιστήριο 4: Relational Model and Relational Algebra | Εκφώνηση | Λύσεις | |
| Δ | Relational Algebra II Binary Relational Operations (DIVISION), Additional Relational Operations (Aggregate Functions, Generalized Projection, Grouping, Recursive Closure, Outer Join), Examples of Queries in Relational Algebra with University and Sailors-Reserve-Boats Example |
Chapter 6.4-6.5, Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| 6 | Δ | ER-to-Relational Mapping ER-to-Relational Mapping Algorithm (Mapping of: Regular Entity Types, Weak Entity Types, Binary 1:1, 1:N and M:N Relation Types, Multivalued attributes, N-ary Relationship Types, ER-to-Relational Mapping Algorithm (Options for Mapping Specialization or Generalization, Mapping of Union Types (Categories)). |
Chapter 7, Elmasri-Navathe. Fundamentals of Database Systems 5ED | |
| Φ | Φροντιστήριο 5: Relational Algebra | Εκφώνηση | Λύσεις | |
| Δ | SQL-DDL Introduction to SQL-DDL,Data types, DDL statements CREATE/DROP/TRUNCATE/DELETE/ALTER, Constraints (PRIMARY KEY, UNIQUE, FOREIGN KEY, NOT NULL, CHECK), Integrity Constraints |
Chapter 8.1-8.3, Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| 7 | Δ | SQL-DML I Introduction to SQL-DML, SQL vs. Relational Algebra, Simple SELECT-FROM-WHERE Queries, JOIN and Cartesian Product, DISTINCT, Set Operations (UNION [ALL], INTERSECT, EXCEPT) |
Chapter 8.4, Elmasri-Navathe. Fundamentals of Database Systems 5ED | |
| Φ | Φροντιστήριο 6: Relational Algebra (Advanced) | Εκφώνηση | Λύσεις | |
| Δ | SQL-DML II Ordering of Results (ORDER-BY), Pattern Matching with LIKE and CONTAINS (TSQL), Comparisons Involving NULLS (IS NULL), Nested Queries (Correlated and Uncorrelated) and Set/Multiset Comparisons (EXIST, IN, op-ALL, op-ANY), DIVISION (using NOT EXISTS ... EXCEPT), R-δένδρα |
Chapter 8.4-8.5.4, Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| 8 | Δ | SQL-DML III Renaming with AS, Advanced Joins (NATURAL, INNER JOIN, OUTER JOIN (LEFT, RIGHT, FULL), CROSS JOIN), Aggregate Functions in SQL (COUNT, MAX, MIN, AVG, SUM), Characteristics of COUNT in TSQL (DISTINCT, ALL, *) |
Chapter 8.5.6-8.5.7, Elmasri-Navathe. Fundamentals of Database Systems 5ED | |
| Φ | Φροντιστήριο 7: Relational Algebra and SQL | Εκφώνηση | Λύσεις | |
| Δ | SQL-DML IV Conceptual Query Execution Plan Explanation, GROUP-BY, HAVING in SQL, Insert/Delete/Update Operations in SQL, BULK INSERT in TSQL. |
Chapter 8.5.8-8.5.9, Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| 9 | 18/03/2013 | ΑΡΓΙΑ | ||
| Φ | Επανάληψη για ενδιάμεση εξέταση | Υλικό μέχρι διάλεξη 12-13 | ||
| 21/03/2013 | ΕΝΔΙΑΜΕΣΗ ΕΞΕΤΑΣΗ (Αίθουσα: B148, Ώρα: 19:15-21:00) | Υλικό μέχρι διάλεξη 12-13 | ||
| 10 | 25/03/2013 | ΑΡΓΙΑ | ||
| Δ/Φ | Φροντιστήριο: JAVA-SQL Programming in SQLServer and Project Phase 2 Φροντιστήριο: Λύσεις ενδιάμεσης εξέτασης |
|||
| Δ | Advanced SQL I: Internal Database Programming Programming inside the Database: Introductory (SET, DECLARE, USE, SELECT, GO,IF..ELSE, WHILE, CASE), Scripts and Batches, Dynamic SQL and EXEC. |
Chapter 8.7-8.8, Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| 11 | 01/04/2013 | ΑΡΓΙΑ | ||
| Δ | Advanced SQL II & ΙΙΙ: Internal/External Database Programming Stored Procedures (SPROCs), Advantages and Disadvantages of Stored Procedures, User Defined Functions (UDFs), Programming Database Objects with High Level Languages (SQLCLR), Embedded SQL, DB Programming with Function Calls: SQL/CLI or JDBC |
Chapter 9.1, Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| Δ | Functional Dependencies and Normalization I Introduction to Normalization, Informal Design Guidelines for Relational Schemas: i) Semantics of Relation and Attribute Names. |
Chapter 10.1, Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| 12 | Δ | Functional Dependencies and Normalization I Informal Design Guidelines for Relational Schemas: ii) Redundant Information in Tuples and Update Anomalies (Insert, Update, Delete), iii) NULLs in Tuples and iv) Spurious Tuples. |
Chapter 10.1, Elmasri-Navathe. Fundamentals of Database Systems 5ED | |
| Φ | Φροντιστήριο 8: Advanced SQL | Εκφώνηση | Λύσεις | |
| Δ | Functional Dependencies and Normalization II Introduction to Functional Dependencies (FD): Motivation and Definitions, Inference Rules for FD, Armstrong Axioms and FD Proofs, Additional Definitions for FDs: FD Closure F+, Attribute Closure X+, Equivalence of two sets of FDs (F+=G+), Cover of an FD set, Minimal Cover for an FD Set. |
Chapter 10.2, Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| 13 | Δ | Functional Dependencies and Normalization III Overview of Normalization and Normal Forms, Definitions: Prime and Non-Prime Attribute, Partial and Full Functional Dependencies, Normal Forms (1NF, 2NF and 3NF): Motivation, Examples, Decomposition. |
Chapter 10.3-10.4, Elmasri-Navathe. Fundamentals of Database Systems 5ED | |
| Φ | Φροντιστήριο 9: Functional Dependencies, Normal Forms | Εκφώνηση | Λύσεις | |
| Δ | Functional Dependencies and Normalization IV Normal Forms (BCNF, 4NF, 5NF): Motivation, Examples, Decomposition |
Chapter 10.5, 11, Elmasri-Navathe. Fundamentals of Database Systems 5ED | ||
| 22/05/2013 | Φ | ΕΠΙΠΡΟΣΘΕΤΟ ΦΟΝΤΙΣΤΗΡΙΟ ΓΙΑ ΤΕΛΙΚΗ ΕΞΕΤΑΣΗ Αίθουσα:tbd, Ώρα:tbd |
||
| 25/05/2013 | ΤΕΛΙΚΗ ΕΞΕΤΑΣΗ Αίθουσα:ΧΩΔ02-007, Ώρα:08:30-16:30 |
