| 13-3-2023 |
1.5 hours |
Introduction to Database Differences between data and information. File-Based file system Limitations of the file-based system Database Management systems. DDL & DML(Introduction) History of Database Management System. Advantages & Disadvantages of Database systems. |
|
|
|
1.5 hours |
Data Models Views Components of DBMS Environment Roles in Databases |
|
|
| 20-3-2023 |
1.5 hours |
The Three-Level ANSI-SPARC Architecture External Level, Conceptual, Internal Level. Schemas, Mapping, and instances Data Independence Database Languages Functions of a DBMS |
|
|
|
1.5 hours |
Components of a DBMS Multi-User DBMS Architecture Teleprocessing File-Server Architectures Traditional Two-Tier Client-Server Architecture Three-Tier Client-Server Architecture Transaction Processing Monitors |
|
|
| 27-3-2023 |
1.5 hours |
Relationship Types Degree of Relationship Types Recursive Relationship Attributes Simple and composite Attributes Single-Valued and Multi-Valued Attributes Derived Attributes |
|
|
|
1.5 hours |
Strong and Weak Entity Types Attributes on Relationship Structural Constraints One-to-One (1:1) Relationships One-to-Many (1:*) Relationships Many-to-Many (*:*) Relationships Multiplicity for Complex Relationships Cardinality and Participation Constraints |
|
|
| 3-4-2023 |
1.5 hours |
Introduction to Relational Database Model A Logic View of Data Characteristics of a Relational Table |
|
|
|
1.5 hours |
Types of Keys, Relational Database keys. Integrity Rules Views Updating Views. |
|
|
| 10-4-2023 |
1.5 hours |
The Extended Entity-Relationship Model Entity Super-Types and Subtypes Specialization Hierarchy |
|
|
|
1.5 hours |
Inheritance Subtype Discriminator The Extended Entity-Relationship Model |
|
|
| 17-4-2023 |
1.5 hours |
Introduction to SQL Objectives of SQL History of SQL Importance of SQL Terminology Writing SQL Commands Data Manipulation |
|
|
|
1.5 hours |
Simple Queries Sorting Results (ORDER BY Clause) Using the SQL Aggregate Functions Grouping Results (GROUP BY Clause) Subqueries ANY and ALL Multi-Table Queries EXISTS and NOT EXISTS Combining Result Tables Practice queries |
|
|
| 24-4-2023 |
1.5 hours |
The Relational Algebra Unary Operations Set Operations |
|
|
|
1.5 hours |
Join Operations Division Operation Aggregation and Grouping Operations Summary of the Relational Algebra Operations |
|
|
| 1-5-2023 |
1 Hour |
Mid Term |
|
|
| 8-5-2023 |
1.5 hours |
Cartesian /Cross Product , Joins |
|
|
|
1.5 hours |
Types of Joins (Natural, theta, outer joins) Query trees Translating relational algebra to query trees |
|
|
| 15-5-2023 |
1.5 hours |
Normalization Its Purpose (to remove redundancy) Anomalies related to Normalization Normal Forms |
|
|
|
1.5 hours |
Conversion to First Normal Form Conversion to Second Normal Form |
|
|
| 22-5-2023 |
1.5 hours |
Conversion to Third Normal Form Higher-Level Normal Forms Fourth Normal Form(4NF) |
|
|
|
1.5 hours |
Normalization and Database Design Normalization Practice |
|
|
| 29-5-2023 |
1.5 hours |
Introduction to SQL Objectives of SQL History of SQL Importance of SQL Terminology Writing SQL Commands Data Manipulation Simple Queries Sorting Results(ORDER BY Clause) |
|
|
|
1.5 hours |
Using the SQL Aggregate Functions Grouping Results (GROUP BY Clause) Subqueries ANY and ALL Multi-Table Queries EXISTS and NOT EXISTS Combining Result Tables. |
|
|
| 5-6-2023 |
1.5 hours |
The Relational Algebra Unary Operations Set Operations Join Operations Division Operation |
|
|
|
1.5 hours |
Aggregation and Grouping Operations Summary of the Relational Algebra Operations |
|
|
| 12-6-2023 |
1.5 hours |
What is Transaction? Transaction States Properties of Transactions Concurrency control and why it is needed? |
|
|
|
1.5 hours |
The lost update The dirty read problem The inconsistent analysis problem Why recovery needed? Types of Failure |
|
|
| 19-6-2023 |
1.5 hours |
Concurrency Control Techniques 2PL 2PL to remove Lost update problem Dirty Read Problem Inconsistent Analysis Problem |
|
|
|
1.5 hours |
Two phase Locking Problems Deadlocks Deadlocks Prevention Deadlock Detection |
|
|
| 26-6-2023 |
1.5 hours |
Basic time stamping Thomas Write Rule |
Security in Database |
|
|
1.5 hours |
Security in Database |
Security in Database |
|
| 3-7-2023 |
2 Hour |
Final Term |
|
|
