DMS for MSBTE 3K Scheme

Database Management System, Sem III Diploma in Computer Engineering, Information Technology MSBTE K Scheme

This blog on Database Management System (MSBTE Code: 313302 Abbr. – DMS) will provide all the required study materials, including the syllabus, sample MSBTE question papers, MSBTE paper solutions, and unit-by-unit questions and answers with marks in accordance with the MSBTE’s “K” scheme. If you are looking for study material that will help you score good marks in “Database Management System” then this is the perfect blog for you, and your search will end here.

This course focuses on fundamentals of relational database management system and enables students to design and manage database for various software applications. It also provides students with theoretical knowledge and practical skills in the use of databases and database management systems in Information Technology applications.

Students will be able to achieve & demonstrate the following on completion of course based learning :

1 – Explain concept of database management system.
2 – Design the database for given problem.
3 – Manage database using SQL.
4 – Implement PL/SQL codes for given application.
5 – Apply security and backup methods on database.

Database Management System Syllabus Download :

Click below to download Database Management System Syllabus for in Diploma in Computer Engineering, Information Technology, Artificial Intelligence as per MSBTE K scheme

Question Paper Analysis of Database Management System, Sem II Diploma in CO / CM / IF MSBTE K Scheme

Dear Students, study of any subject must be done systematically with planning and referring to the previous year’s MSBTE’s board exam question papers and model answers. The following table gives you detailed unit-wise analysis of previous years MSBTE’s board exam question papers as per the K scheme.

Unit wise MSBTE board asked important questions

Unit – I Introduction To Database System (Marks – 12)

1.1 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
1.2 Architecture:- Two tier and Three tier architecture of database.
1.3 Data Models:- Hierarchical, Networking, Relational Data Models.

Download Unit I MSBTE Board Asked Important Questions –

Unit – II Relational Data Model (Marks – 12)

2.1 Relational Structure :- Tables (Relations), Rows(Tuples), Domains, Attributes, Entities
2.2 Keys :- Super Keys, Candidate Key, Primary Key, Foreign Key.
2.3 Data Constraints :- Domain Constraints ,Referential Integrity Constraints
2.4 Entity Relationship Model : – Strong Entity set, Weak Entity set, Types of Attributes, Symbols for ER diagram, ER Diagrams
2.5 Normalization:- Functional dependencies, Normal forms: 1NF, 2NF, 3NF

Download Unit II MSBTE Board Asked Important Questions –

Download Unit II MSBTE Board Asked Important Questions –

Unit – III Interactive SQL and Performance Tuning (Marks – 18)

3.1 SQL: -Data-types, Data Definition Language (DDL),Data Manipulation language (DML), Data Control Language (DCL), Transaction Control Language (TCL).
3.2 Clauses & Join:- Different types of clauses – Where, Group by ,Order by, Having. Joins: Types of Joins, Nested queries.
3.3 Operators:- Relational, Arithmetic, Logical, Set operators.
3.4 Functions:- Numeric , Date and time, String functions, Aggregate Functions.
3.5 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

Download Unit III MSBTE Board Asked Important Questions –

Unit – IV PL/SQL Programming (Marks – 18)

4.1 Introduction of PL/SQL: -Advantages of PL / SQL, The PL / SQL Block Structure, PL/SQL Data Types, Variable ,Constant
4.2 Control Structure:- Conditional Control, Iterative Control, Sequential Control.
4.3 Exception handling: -Predefined Exception, User defined Exception.
4.4 Cursors:- Implicit and Explicit Cursors, Declaring, opening and closing cursor, fetching a record from cursor, cursor for loops, parameterized cursors
4.5 Procedures:- Advantages, Create, Execute and Delete a Stored Procedure
4.6 Functions:- Advantages, Create, Execute and Delete a Function
4.7 Database Triggers :- Use of Database Triggers, Types of Triggers, Create Trigger, Delete Trigger

Download Unit IV MSBTE Board Asked Important Questions –

Unit – V Database Administration(Marks – 10)

5.1 Introduction to database administration:- Types of database users, Create and delete users, Assign privileges to users
5.2 Transaction: Concept, Properties & States of Transaction
5.3 Database Backup: Types of Failures, Causes of Failure, Database backup introduction, types of database backups: Physical & Logical
5.4 Data Recovery – Recovery concepts , recovery techniques- roll forward ,Rollback
5.5 Overview of Advanced database concepts:- Data Warehouse ,Data lakes , Data mining, Big data ,Mongo DB, DynamoDB,

Download Unit V MSBTE Board Asked Important Questions –