Database Management System
SKU-Database Management System is an online training course designed for the Engineering students. This course is divided into topics like SQL, DBMS Architecture, E-R Model, Normalization etc which are self explanatory. This is a self study package explains basic concepts in interesting and innovative manner. In this we provided flash animation with some interactivity also & Pictorial Representation for clear understanding of the concepts.
Unit 1.1: File System vs DBMS
File System, Database Management System and Comparison between File System and Database Management System.
Unit 1.2: DBMS Architecture
Logical Architecture, Database Administrator and Physical Architecture.
Unit 1.3: Schemas and Instances
Schemas and Instances of Relation.
Unit 1.4: ER Model
Entity, Attributes, Relationship, Symbols for E R Model and E R Model for Student Database.
Unit 1.5: Data Models
Introduction, Types of Data Models: Hierarchical Model, Network Model, Relational Model and Object Model.
Unit 2.1: Relational Data Models
Introduction, Basic terms of Relational Model like Relation, Tuple, Attributes, Domain, Relational Schema and Relational Instances and Characteristics of Relational Model.
Unit 2.2: Keys
Introduction and Types of keys like Super, Candidate, Primary, Unique, Foreign, Composite, Alternate and Secondary Key.
Unit 2.3: Relational Constraints
Introduction and Types of Constraints like Domain Constraint, Primary key Constraint, Integrity Constraint and Constraint on Update Operations.
Unit 2.4: Relational Algebra
Introduction and Types of Relational Algebra like Union, Intersection, Set Difference, Cartesian Product, Select, Project, Join, Division, Rename, Assignment, Aggregate, Grouping.
Unit 3.1: SQL
Introduction, Working of SQL, Important features of SQL, Functions of DBMS, Queries of Select, Update, Delete, Insert, Create, Alter, Truncate, Drop, Constraints, Views, Index, Subqueries, Functions.
Unit 4.1: Normalization
Introduction, Normal Forms (1NF, 2Nf & 3NF), Functional Dependency, Decomposition and Desirable Properties for Decomposition.
Unit 4.2: Distributed DBMS (DDBMS)
Introduction, Architecture, Distributed Database System Design, Levels of Data & process distribution and Transparency in DDBMS.
Unit 4.3: Transaction Processing
Introduction, Transaction Concepts & States, Implementation of Atomicity & Durability, Concurrent Transactions, Serializability, Recoverability and Security & Integrity.
Unit 4.4: Object Oriented DBMS (OODBMS)
Introduction, Why OODBMS?, Object Relational Database System (ORDBMS), Object Oriented Database System (OODBMS), Implementation of Object Oriented Concepts in Database System and OODBMS vs ORDBMS.
Add to Cart