INT306: Database Management Systems Notes & Study Material
NA
Access All INT306 Study Resources Free
Interactive PDF viewer, dark mode, full offline notes & PYQs.
Available Study Materials
Handwritten Notes & Slides
Unit-by-unit lecture summaries and handwritten notes from class toppers.
Previous Year Papers (PYQs)
LPU Mid-Term (MTE) and End-Term (ETE) questions with solutions.
Official Syllabus & CA Pattern
Course structure, credits, weightage, and continuous evaluation criteria.
Course Overview & Evaluation Scheme
INT306 Unit-Wise Detailed Syllabus
Unit 1: Introduction to database
purpose of database systems, components of dbms, applications of dbms, three tier dbms architecture, data independence, database schema, instance, data modeling, entity relationship model, relational model, Comparison of relational and non-relational databases
Unit 2: Relational query language
introduction to data definition language, data manipulation, data control and transaction control language, integrity constraints, database keys, SQL basic operations
Unit 3: Relational Operations
Aggregate functions, Sql joins, set operators, views, subqueries, relational algebra, Window functions, Hashing, Indexing and Query Optimization.
Unit 4: Relational Database Design
data integrity rules, functional dependency, need of normalization, first normal form, second normal form, third normal form, boyce codd normal form, multivalued dependencies, fourth normal form
Unit 5: Programming Constructs in Databases
flow control statements, functions, stored procedures, cursors, triggers, exception handling Database Transaction Processing : transaction system concepts, desirable properties of transactions, schedules, serializability of schedules, concurrency control, recoverability
Unit 6: NoSQLDatabases
Introduction of MongoDB, DynamoDB, Serverless cloud database, Structure of MongoDB, SQL vs NoSql, Working with MongoDB, JSON databases, JSON representation of part of the dataset, Index creation & performance comparison using EXPLAIN, Vector Databases
Frequently Asked Questions (FAQs)
How to download INT306 LPU notes for free?
Click the "Open in Scholix App" button above to view all verified handwritten notes, slides, and summary PDFs with zero signup required.
Where can I find INT306 previous year questions (PYQs)?
Scholix maintains an extensive archive of LPU Mid-Term (MTE) and End-Term (ETE) question papers with solution guides.
What is the pass percentage & grading for INT306?
Passing criteria follow LPU academic regulations with combined evaluation across Continuous Assessments, Attendance, and End-Term Examination.