Database Management System detailed Syllabus for Electronics & Computer Engg (TE), K scheme PDF has been taken from the MSBTE official website and presented for the diploma students. For Subject Code, Subject Name, Lectures, Tutorial, Practical/Drawing, Credits, Theory (Max & Min) Marks, Practical (Max & Min) Marks, Total Marks, and other information, do visit full semester subjects post given below.
For all other MSBTE Electronics & Computer Engg 3rd Sem K Scheme Syllabus PDF, do visit MSBTE Electronics & Computer Engg 3rd Sem K Scheme Syllabus PDF Subjects. The detailed Syllabus for database management system is as follows.
Rationale
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Course Outcomes:
Students will be able to achieve & demonstrate the following COs on completion of course based learning
- Explain concept of database management system.
- Design the database for given problem.
- Manage database using SQL.
- Implement PL/SQL codes for given application.
- Apply security and backup methods on database.
Unit I
Introduction To Database System 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. Presentations, Hands-on, Chalk-Board.
Unit II
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Unit III
Interactive SQL and Performance Tuning 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 Presentations, Hands-on, Chalk-Board.
Unit IV
PL/SQL Programming 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 Presentations, Hands-on, Chalk-Board.
Unit V
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Skills Development (Self Learning)
Self Learning
- Implement PL/SQL code for relevant topics suggested by the teacher.
Complete any one course related to Database Management System on Infosys Springboard platform.
Assignment
- Solve an assignment on any relevant topic given by the teacher.
Micro project
- Develop a database for restaurant management system. The restaurant maintain catalogue for the list of food items and generate bill for the ordered food.
- Prepare Invoice management system for electricity bill generation. Accept meter reading as inputs and generate respective bill amount for the same.
- Design a database for registration and admission of patient for Hospital management system, draw ER diag and normalize the database up to 3NF. 0
- Any topic suggested by teacher.
- Above is just a suggestive list of microprojects and assignments; faculty must prepare their own bank of microprojects, assignments, and activities in a similar way.
- The faculty must allocate judicial mix of tasks, considering the weaknesses and / strengths of the student in acquiring the desired skills.
- If a microproject is assigned, it is expected to be completed as a group activity.
- SLA marks shall be awarded as per the continuous assessment record.
- For courses with no SLA component the list of suggestive microprojects / assignments/ activities are optional, faculty may encourage students to perform these tasks for enhanced learning experiences.
- If the course does not have associated SLA component, above suggestive listings is applicable to Tutorials and maybe considered for FA-PR evaluations.
Note :
Laboratory Equipment
- Computer system – (Any computer system with basic configuration) All
- Any RDBMS software (MySQL/Oracle/SQL server/ or any other) All
Suggested Learning Materials
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Learning Websites & Portals
- https://nptel.ac.in/courses/106105175 Data Base Management System
- https://www.w3schools.com/sql/ SQL Tutorial
- https://www.tutorialspoint.com/sql/index.htm SQL Programming Language
For detail Syllabus of all other subjects of Electronics & Computer Engg, K scheme do visit Electronics & Computer Engg 3rd Sem Syllabus for K scheme.
For all Electronics & Computer Engg results, visit MSBTE Electronics & Computer Engg all semester results direct links.