#2.1 The Enhanced EntityRelationship (EER) Model #2.2 Constraints and Characteristics of Specialization and Generalization Hierarchies #2.3 Modeling of UNION Types Using Categories #2.4 Types Using Categories درس اضافي

#3.1 Relational Database Design Using ER-to-Relational Mapping #3.2 Mapping of Shared Subclasses (Multiple Inheritance) #3.3 Mapping of Categories (Union Types #3.4 Mapping of Generalization and Specialization Hierarchies to a Relational Schema

#4.1 Object and Object-Relational Databases #4.2 ODL

#5.1 Primary Index #5.2 Primary Index-2

#6.1 The Relational Algebra and Relational Calculus-1 #6.2 The Relational Algebra and Relational Calculus-2 #6.3 The Relational Algebra and Relational Calculus-3 #6.4 The Relational Algebra and Relational Calculus-4 #6.5 The Relational Algebra and Relational Calculus-5 #6.6 The Relational Algebra and Relational Calculus-6 #6.7 The Relational Algebra and Relational Calculus-7

#7.1 Introduction to Query Processing

#8.1 Introduction to Transaction Processing #8.2 Why we need concurrency control #8.3 Why recovery is needed #8.4 Transaction and System Concepts #8.5 Desirable Properties of Transactions #8.6 Characterizing Schedules based on Serializability #8.7 Testing for conflict serializability Algorithm #8.8 Example

#9.1 Database Concurrency Control -1 #9.2 Database Concurrency Control -2 #9.3 Database Concurrency Control -3

#10.1 Purpose of Database Recovery #10.2 Data Update #10.3 Checkpointing #10.4 Recovery Protocol

#11.1 Introduction to Database Security Issues #11.2 Database Security and the DBA #11.3 Access Protection, User Accounts, and Database Audits #11.4 Types of Discretionary Privileges #11.5 Specifying Privileges Using Views -1 #11.6 Specifying Privileges Using Views -2 #11.7 Mandatory Access Control #11.8 Role-Based Access Control #11.9 Access Control Policies for E-Commerce and the Web #11.10 Introduction to Statistical Database Security #11.11 Introduction to Flow Control #11.12 Encryption

#12.1 رسم ERD #12.2 رسم ERD #12.3 تمرين مهم #12.4 نموذج اختبار #12.5 رسم ERD #12.6 تمرين #12.7 Logfile

#13.1 واجب1