Database Management System (313302) MSBTE QuAn Question Answer Book

Description

QuAn Book – Database Management System (313302)

The QuAn Book for Database Management System (Subject Code: 313302) is a premium study material designed for MSBTE K-Scheme Diploma Engineering students. It provides a complete, topicwise question bank with model answers to help you score maximum marks.

Syllabus Coverage (MSBTE K-Scheme)

• Unit I – Introduction To Database System: Database concepts:-Data, Database, Database management system, File system Vs DBMS, Applications of DBMS, Data Abstraction, Data Independence, Database Schema, The Codd’s rules, Overall structure of DBMS; Architecture:- Two tier and Three tier architecture of database; Data Models:- Hierarchical, Networking, Relational Data Models
• Unit II – Relational Data Model: Relational Structure :- Tables (Relations), Rows (Tuples), Domains, Attributes, Entities; Keys :- Super Keys, Candidate Key, Primary Key, Foreign Key; Data Constraints :- Domain Constraints ,Referential Integrity Constraints; Entity Relationship Model : – Strong Entity set, Weak Entity set, Types of Attributes, Symbols for ER diagram, ER Diagrams; Normalization:- Functional dependencies, Normal forms: 1NF, 2NF, 3NF
• Unit III – Interactive SQL and Performance Tuning: SQL: -Data-types, Data Definition Language (DDL), Data Manipulation language (DML), Data Control Language (DCL), Transaction Control Language (TCL); Clauses & Join:- Different types of clauses – Where, Group by ,Order by, Having. Joins: Types of Joins, Nested queries; Operators:- Relational, Arithmetic, Logical, Set operators; Functions:- Numeric , Date and time, String functions, Aggregate Functions; Views, Sequences, Indexes: -Views : Concept ,Create ,Update, Drop Views. Sequences :- Concept ,Create, Alter , Drop, Use of Sequence in table, Index: Concept ,Types of Index , Create ,Drop Indexes
• Unit IV – PL/SQL Programming: Introduction of PL/SQL: -Advantages of PL/SQL,The PL/SQL Block Structure, PL/SQL Data Types, Variable , Constant; Control Structure:- Conditional Control, Iterative Control, Sequential Control; Exception handling: -Predefined Exception, User defined Exception; Cursors:- Implicit and Explicit Cursors, Declaring, opening and closing cursor, fetching a record from cursor ,cursor for loops, parameterized cursors; Procedures:- Advantages, Create, Execute and Delete a Stored Procedure; Functions:- Advantages, Create, Execute and Delete a Function; Database Triggers :- Use of Database Triggers, Types of Triggers, Create Trigger, Delete Trigger
• Unit V – Database Administration: Introduction to database administration:- Types of database users, Create and delete users, Assign privileges to users; Transaction: Concept, Properties & States of Transaction; Database Backup: Types of Failures, Causes of Failure, Database backup introduction, types of database backups: Physical & Logical; Data Recovery – Recovery concepts , recovery techniques- roll forward ,Rollback; Overview of Advanced database concepts:- Data Warehouse ,Data lakes , Data mining, Big data ,Mongo DB , DynamoDB

What’s Inside the QuAn Book?

• Topicwise Question Bank – All important 2, 4 and 6 marks questions by unit
• Model Answers – Step-by-step solutions with diagrams and marking scheme
• Previous Exam Questions – Actual MSBTE Summer and Winter exam questions
• Frequency Analysis – Most repeated questions highlighted for focused study
• Marking Scheme – Know exactly what to write to score full marks
• Last Minute Ready – Ideal for quick and focused exam preparation

Subject Code: 313302 | Subject: Database Management System | Board: MSBTE | Scheme: K Scheme | Published by: ReemaS Edutech, Kolhapur