Database Management System IUnit ID :H7DX 04ContentHours1. Background of the Database1.1 Database History1.2 Traditional File-based systems vs. Databases1.3 Database approach1.4 Advantages and Disadvantages of DBMS1.5 Roles in the Database Environment(Data Administrator(DA), Database Administrator(DBA), Database Designer, Application Developer, End User)1.6 Database Environment1.7 The Three-level ANSI-SPARC DBMS Architecture1.8 Introduction to database languages1.9 Introduction to Data Modeling1.10 Functions and Components of DBMS10ContentHours2. The Relational Model2.1. Introduction to Data Model2.2. Database Terminology2.3. Introduction to Relational Data Structure2.4. Database Relations2.5. Properties of relations2.6. Relational Keys2.7. Relational Database Schema2.8. Integrity constraints 2.8.1. Nulls 2.8.2. Entity Integrity 2.8.3. Referential Integrity 2.8.4. General Constraints2.9. Views 2.9.1. Terminology 2.9.2. Purpose of Views 2.9.3. Updating Views2.10. The Relational Algebra 2.10.1. Unary Operations 2.10.2. Set Operations 2.10.3. Join Operations 2.10.4. Division Operation 2.10.5. Aggregation and Grouping Operations15ContentHours3. Entity Relationship Modeling3.1. Introduction to Entity Modeling terminology(Conceptual, Logical and Physical data Model)3.2. Keys, Attributes Entity Types3.3. Strong and Weak Entity Types3.4. Attributes on Relationships3.5. Structural Constraints 3.5.1. One-to-One (1:1) Relationships 3.5.2. One-to-Many (1:*) Relationships 3.5.3. Many-to-Many (*:*) Relationships 3.5.4. Multiplicity for Complex Relationships 3.5.5. Cardinality and Participation Constraints3.6. Problems with ER Models 3.6.1. Fan Traps 3.6.2. Chasm Traps15ContentHours4. Normalization4.1. Introduction to Normalization4.2. How Normalization Supports Database Design4.3. Data Redundancy and Anomalies 4.3.1. Insertion Anomalies 4.3.2. Deletion Anomalies 4.3.3. Modification Anomalies4.4. Functional Dependencies 4.4.1. Characteristics of Functional Dependencies 4.4.2. Identifying Functional Dependencies 4.4.3. Identifying the Primary Key for a Relation using Functional Dependencies4.5. The Process of Normalization4.6. First Normal Form (1NF)4.7. Second Normal Form (2NF)4.8. Third Normal Form (3NF)4.9. General Definitions of 1NF 2NF and 3NF10ContentHours6. Database planning Techniques6.1. The Information Systems Lifecycle6.2. The Database System Development Lifecycle6.3. Database Planning6.4. System Definition6.5. Requirements Collection and Analysis6.6. Database Design 6.6.1. Graphical ER Diagrams Designing tools (Workbench, Query Browsers)6.7. DBMS Selection6.8. Data Conversion and Loading6.9. Operational Maintenance15ContentHours5. Structured Query Language (SQL)5.1. History of SQL5.2. SQL Commands5.3. Data Definition language(DDL)5.4. Data Manipulation Language (DML) 5.4.1. Data Types 5.4.2. Create and Drop Database 5.4.3. Create and Drop Table 5.4.4. Create and Drop Attributes 5.4.5. Create and drop Relations 5.4.6. Create and Drop Views 5.4.7. Discretionary Access Control10ContentHours7. Database Management System (TUTORIAL 01)8.Database Management System (TUTORIAL 02)0505