DBMS

DBMS

Course Schedule 

  • Duration : 1 month
  • Days : Thursday & Friday
  • Timings : 4PM to 6PM

Course Content 

1. Overview of Databases
1.1. Database Management System overview
Overview of Database
Database Management System (DBMS)
Components of Database System
Functions of DBMS
1.2. Database advantages and disadvantages
Advantages of DBMS
Disadvantages of DBMS
1.3. Database Models: Hierarchical, Network, Relational, Object-oriented Relational, Object-oriented
Database Model:
Hierarchical Model:
Network Model:
Relational Model:
Object-relational Database:
Object Database:
2. Relational Model 
2.1. Terminology: File-based (file, record, field) versus data model (entity, attribute, relationship) versus relational model (relation, tuple, attribute) versus relational database (table, row, column)
Relational Model:
Terminology:
2.2. Relational Algebra Operators: Selection, Project, Join
Relational Algebra Operations:
Selection (σ)
Projection (π):
Joins:
3. Database Design Methodology
3.1. Information-Level (Logical) versus Physical-level Design
Logical Modeling:
Physical Modeling:
Conclusion:
3.2. Identification of User Views
E-R Model:
Rule Set:
3.3. Logical Database Design: Entity Relationship Diagram, entity/relation, attribute, relationships, cardinality
Logical Database Design:
Entity/Relation:
Cardinality
Attributes:
3.4. Physical Database Design: tables, primary keys, foreign keys
Rules for translation:
3.5. Top-down versus Bottom-up Design: use of both approaches for correct, complete result
Top-down vs. Bottom-up object database design
4. Detailed Logical Design 
4.1. Functional Dependence
Example:
4.2. Primary Key
Example:
4.3. First Normal Form (1NF)
Example:
Domains and values:
4.4. Second Normal Form (2NF)
Example:
4.5. Third Normal Form (3NF)
Example:
4.6. Relational Schema
Example:
4.7. Update and Delete Data Anomalies
Types of Anomalies:
Update Anomalies:
Delete Anomalies:
5. Structured Query Language (SQL) Overview
Why SQL?
SQL Process:
SQL Commands:
DDL – Data Definition Language:
5.1. Introduction to using DB2 on the AS/400
Hardware requirements
Software requirements:
Checking system compatibility:
Installing DB2 on Linux operating system:
Verifying DB2 installation:
Command Line Processor (CLP)
5.2. Create a DB2 table and view using SQL CREATE statement
5.3. Add data using SQL INSERT statement
5.4. Query data in DB2 using simple SELECT statement
5.5. Modify database structure using SQL ALTER statement
5.6. Query DB2 data dictionary tables using SELECT statement
5.7. Preserve database integrity using SQL’s NOT NULL, CHECK
UNIQUE Constraints
CHECK Constraints:
Limitations of CHECK Constraints:
5.8. PRIMARY KEY AND FOREIGN KEY constraints
Foreign Key Constraints:
5.9. Enforce uniqueness by UNIQUE INDEX
Restrict access with unique indexes:

Posted on: May 9, 2020admin