#2.1 Data Model #2.2 Database Schema #2.3 Three-Schema Architecture #2.4 Data independence #2.5 Database Languages and Interfaces #2.6 Centralized and Client/Server DBMS Architectures

#3.1 How to draw ERD #3.2 Schema-تمارين #3.3 Weak Entities Exercise -تمرين #3.4 تمارين - ER #3.5 نموذج اختبار ميد1 #3.6 Shcema - quiz 1 #3.7 نموذج اختبار ميد1 #3.8 hw-sql #3.9 HW1 #3.10 HW2 #3.11 نموذج ميد2 #3.12 نموذج فاينل #3.13 Final-erd #3.14 SQL #3.15 مهم-SQL #3.16 Employees Schema #3.17 ER to Relational Mapping #3.18 رسم ERD #3.19 رسم ERD #3.20 تمرين مهم - الهادي #3.21 رسمه erd الواجب #3.22 Schema-تمارين #3.23 Normalization Exercise #3.24 Normalization Exercise #2 #3.25 Schema - نموذج سامح #3.26 mid1 #3.27 mid1-اختياري #3.28 convert er to sql #3.29 Convert Schema to ERD #3.30 ميد #3.31 Convert ERD to Schema #3.32 أختياري #3.33 draw ERD #3.34 SQL #3.35 1-normalization form #3.36 2-normalization form

#4.1 ملخص شبتر-1 #4.2 ملخص شبتر-2 #4.3 ملخص شبتر-3 #4.4 ER Model Concepts #4.5 Recursive Relationship Type+week entity #4.6 Example of a Ternary Relationship

#5.1 Informal Definitions #5.2 Characteristics of Relations #5.3 Constraints #5.4 Possible Violations for Operations

#6.1 ER Model to Relational Mapping #6.2 Mapping of N-ary Relationship Types

#7.1 create table #7.2 Constraints-1 #7.3 Example of Company Database #7.4 Constraints-2 #7.5 select statement-1 #7.6 select statement-2 #7.7 select statement-3 #7.8 select statement-4 #7.9 INSERT #7.10 delete and update

#8.1 Nested queries #8.2 EXISTS function #8.3 view in SQL

#9.1 Create Table #9.2 Insert and Delete and update and drop #9.3 Alter table #9.4 1 - Select #9.5 select-2 #9.6 Like and between #9.7 order by and Specifying Constraints #9.8 ملخص sql الاول #9.9 SQl-1 #9.10 SQL-2 #9.11 INSEEART DELETE UPDATE #9.12 Alter #9.13 Like and between #9.14 ORDER BY #9.15 SQL HW

#10.1 Relational Algebra -1 #10.2 Relational Algebra -2 #10.3 Relational Algebra -3 #10.4 Relational Algebra - 4 #10.5 Relational Algebra - 5

#11.1 Relationship Types of Degree #11.2 Schema one to one Relationship #11.3 Schema one to many Relationship #11.4 Schema one to many Relationship-2 #11.5 Schema many to many Relationship #11.6 Weak entity Schema #11.7 ER- to-Relational Mapping #11.8 Mapping of Generalization and Specialization Hierarchies to a Relational Schema-1 #11.9 Mapping of Generalization and Specialization Hierarchies to a Relational Schema-2 #11.10 Multiple Inheritance #11.11 Mapping Regular Entities to Relations #11.12 Mapping Binary Relationships 1toN #11.13 Mapping a binary 1to1 relationship #11.14 mapping an M toN relationship #11.15 Mapping Ternary Relationships #11.16 Mapping Unary Relationships

#12.1 First Normal Form 1NF-مختصر #12.2 مختصر-Second Normal Form 2NF #12.3 مختصر - Third Normal Form 3NF #12.4 Normalizing-ex #12.5 Normalizing-ex1