Database Management detailed Syllabus for Information Technology (IF), I – scheme 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 Diploma in Information Technology (IF) Syllabus for 4th Sem I – Scheme MSBTE, do visit Diploma in Information Technology (IF) Syllabus for 4th Sem I – Scheme MSBTE Subjects. The detailed Syllabus for database management 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.
.
Competency:
The aim of this course is to help the student to attain the following industry identified competency through various teaching learning experiences:
- Apply Database Management concepts using SQL.
Course Outcomes:
The theory, practical experiences and relevant soft skills associated with this course are to be taught and implemented, so that the student demonstrates the following industry oriented COs associated with the above mentioned competency:
- Create Database using SQL commands
- Manage Database using SQL commands.
- Implement Advanced SQL concepts on Database.
- Write PL/SQL code for database application.
- Apply security and safety on Database.
Suggested Exercises:
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..
Instruments Required:
The major equipment with broad specification mentioned here will usher in uniformity in conduct of experiments, as well as aid to procure equipment by authorities concerned.
Equipment Name with Broad Specifications
- Computer system – Any computer system with basic configuration
- Any RDBMS software – MySQL/SQL server or any other
Unit 1
Creating Relational Database
Total Teaching Hours – 04
Distribution of Theory Marks
R Level – 02
U Level – 02
A Level – 04
Total Marks – 08
Unit Outcomes (UOs) (in cognitive domain)
- Describe the given RDBMS term with example.
- Design SQL queries to create the specified Relational database
- Use relevant DDL command to carry out the given database definition operation.
- Categorise the given SQL command in DD1, DML, DCL.
- Apply the given data constraint for data integration.
- Describe the procedure to create the given database using SQL commands.
Topics and Sub-topics
- Relational Database Design: Concept of Relational Database Design, different types of RDBMS software, different relational algebra operator.
- RDBMS Terminology -Relation, Attribute, Domain, Tuple, cardinality, Degree.
- Introduction to SQL: Data Types in SQL, purpose of DDL, DML DCL and TCL. DDL commands: CREATE, ALTER, DROP, TRUNCATE, DESC, RENAME, Use of data constraints
Unit 2
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 3
Advance features of SQL
Total Teaching Hours – 12
Distribution of Theory Marks
R Level – 02
U Level – 04
A Level – 10
Total Marks – 16
Unit Outcomes (UOs) (in cognitive domain)
- Design SQL queries for implementing the given View/ sub query.
- Design SQL queries for implementation of the given Sequences.
- Create Indexes using SQL Query to solve the given problem.
- Describe the procedure to create Synonym using SQL Query to solve the given problem.
Topics and Sub-topics
- Views: Concept of View, The Create View Command, Updating Views, Views and Joins, Views and Sub queries, Dropping Views.
- Sequences: Creating Sequences, Altering Sequences, Dropping Sequences.
- Indexes: Index Types, Creating of an Index: Simple Unique, and Composite Index, Dropping Indexes
- Synonyms: Creating Synonyms, Dropping Synonyms.
Unit 4
PL/SQL Programming
Total Teaching Hours – 12
Distribution of Theory Marks
R Level – 02
U Level – 04
A Level – 10
Total Marks – 16
Unit Outcomes (UOs) (in cognitive domain)
- Describe the use of the given component of PL/SQL.
- Use the relevant control structure in PL/SQL Code to solve the given conditional/ iterative problem.
- Write the PL/SQL Code to handle the given exception.
- Write the PL/SQL codes to create cursor for retrieving multiple records for the given problem.
- Create a stored Procedures and Functions using the PL/SQL to solve the given problem.
- Write PL/SQL code for the given database application .
Topics and Sub-topics
- Introduction of PL/SQL, Advantages of PL/SQL, The PL/SQL Block Structure, PL/SQL execution environment, PL/SQL data Types, Variables, Constants.
- Control Structure: Conditional Control, Iterative Control, Sequential Control.
- Exception handling: Predelined Exception, User defined Exception.
- Cursors: Implicit and Explicit Cursors, Declaring, Opening and Closing a Cursor, Fetching a Record from Cursor, Cursor for loops, Parameterized Cursors.
- Procedures: Advantages, Creating, Executing and Deleting a Stored Procedure.
- Functions: Advantages, Creating, Executing and Deleting a Function.
- Database Triggers: Use of Database Triggers, apply database Triggers, Types of Triggers, Syntax for Creating Trigger, Deleting Trigger.
Unit 5
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..
Suggested Student Activities:
Other than the classroom and laboratory learning, following are the suggested student-related co-curricular activities which can be undertaken to accelerate the attainment of the various outcomes in this course: Students should conduct following activities in group and prepare reports of about 5 pages for each activity, also collect/record physical evidences for their (students) portfolio which will be useful for their placement interviews:
- Prepare journals based on practical performed in laboratory.
- Give seminar on relevant topic.
- Undertake micro-projects.
Suggested Special Instructional Strategies:
These are sample strategies, which the teacher can use to accelerate the attainment of the various learning outcomes in this course:
- Massive open online courses (MOOCs) may be used to teach various topics/sub topics.
- L in item No. 4 does not mean only the traditional lecture method, but different types of teaching methods and media that are to be employed to develop the outcomes. About 15-20% of the topics/sub-topics which is relatively simpler or descriptive in nature is to be given to the students for self-directed learning and assess the development of the COs through classroom presentations (see implementation guideline for details).
- With respect to item No.
- teachers need to ensure to create opportunities and provisions for co-curricular activities.
- Guide students in undertaking micro-projects.
- Demonstrate students thoroughly before they start doing the practice.
- Encourage students to refer different websites to have deeper understanding of the subject.
- Observe continuously and monitor the performance of students in Lab.
- Demonstrate students thoroughly before they start doing the practice.
- Encourage students to refer different websites to have deeper understanding of the subject.
Suggested Micro-Projects
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..
Suggested Learning Resources:
- Introduction to Database Management Systems ISRD Group McGraw Hill Education, 2005, New Delhi, ISBN-13:9780070591196
- Database System Concepts Korth, Henery Abraham, Silberschatz Sudarshan ,S McGraw Hill Education, New Delhi, 2013, ISBN-13: 978-9332901384
- Complete Reference: Mysql Vaswani Vikram McGraw Hill Education, New Delhi, ISBN-13: 9780070586840
- SQL. PL/SQL The Programming Language of ORACLE Bayross, Ivan BPB Publications, New Delhi3rd Edition. ISBN-13: 978-8176569644
- Database Management Leon Alexis & Leon Mathews Vikas Publishing, New Delhi ISBN-13:9788182092228
Software/Learning Websites:
- www.tutorialpoint.com (Important website)
- wielylndia.com or DreamtechPress.com
- hllp://phindia.com/gupta/chapter/chapter1.pdf
- www. williamstannings.com
For detail Syllabus of all other subjects of Information Technology, I – scheme do visit Information Technology 4th Sem Syllabus for I – scheme.
For all Information Technology results, visit MSBTE Information Technology all semester results direct links.