Database Management System
Section outline
-
This course introduces students to the Database Management System (DBMS).
Upon completion of this course, students will be able to design, create, and manage databases using DBMS concepts and SQL.
The course covers database fundamentals, data models, ER diagrams, relational model, SQL queries, normalization, transactions, concurrency control, database security, and backup & recovery techniques -
- Database System Concepts and Architecture
- Components of DBMS
- Table Structure
- Schema definition
- Three views of Data (External View, Conceptual View, Internal View)
-
- Define data model
- Data Models : Network Model Hierarchical Model
- E-R Model
- Advantage & Disadvantages of each Data Model
- Concept of Keys (Primary, Candidate, Super, Foreign)
- Constraints
- Strong Entity Set and Weak Entity Set
-
- The Relational Data Model and Relational Database Constraints
- ER/EER to Relational Model mapping
- Relational Algebra and Relational Calculus
- Relations algebra (Basic operation: Union intersection difference and Cartesian product)
- Additional Relational Algebraic Operations
(Projection, Selection rows, Division, rename and join )
-
- Functional dependencies and normalization for relational databases
- Types of Normalization (1NF, 2NF, 3NF, multivalued dependencies and BCNF, Forth Normal Form, Fifth Normal Form).
-
- MySQL data types – Data Definition Commands – Data Manipulation Commands – Data Retrieval
Commands - Types of operators – Arithmetic
- Comparison and Logical Operators
- MySQL data types – Data Definition Commands – Data Manipulation Commands – Data Retrieval
Topic wise Chapter (English)
Topic wise chapter (Hindi)
Topic wise chapter (English)
Topic wise chapter (Hindi)
Topic Wise Chapter (English)
Topic wise Chapter (Hindi)
Topic wise Chapter (English)
Topic Wise Chapter (Hindi)
Topic Wise Chapter (English)
Topic Wise Chapter (Hindi)