Dear Students the Lecture Notes has been uploaded for the following topics:DATABASE DESIGN: Database Design Process, ER Diagrams - Entities, Attributes, Relationships, Constraints, keys, extended ER features, Generalization, Specialization, Aggregation, Conceptual design with the E-R model, E-R Issues- weak entity set, code rules, Dependencies and Normal forms , Functional Dependencies, Normalizations: 1NF,2NF,3NF, BCNF,4NF,5NF, TRANSACTIONS MANAGEMENT, Transaction Concepts – ACID Properties , serializability and its types Schedules , Serializability – Concurrency Control, Need for Concurrency – Locking Protocols , Two Phase Locking , Deadlock, Transaction Recovery , Save Points – Isolation Levels
Assignment topic is OBJECT BASED DATABASE SYSTEMS and due date is 28-09-2022.
Assignment topic is DISTRIBUTED DATABASE MANAGEMENT SYSTEMS and due date is 27-09-2022.
Dear Students the Lecture Notes has been uploaded for the following topics:Introduction to Database System, , Purpose of Database System, Views of data , Data models, Database Management system –Basic building blocks , Evaluation of Data models, Three-schema architecture of DBMS, Components of DBMS., Basics of SQL, DDL, DML, DCL, structure – creation, alteration, defining constraints – Primary key, foreign key, unique, not null, check, IN operator, Functions - aggregate functions, Built-in functions – numeric, date, string functions, set operations, sub-queries, correlated sub-queries, transaction control commands – Commit, Rollback, Save point, cursors, stored procedures, Triggers
