Database Management System detailed Syllabus for Computer Science & Engineering (CW), 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 Computer Science & Engineering (CW) Syllabus for 3rd Sem I – Scheme MSBTE, do visit Diploma in Computer Science & Engineering (CW) Syllabus for 3rd Sem I – Scheme MSBTE 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.
.
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 concept 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:
- Design Normalized database on given data.
- Create and Manage Database using SQL command.
- Write PL/SQL code for given database.
- Apply triggers ob database also create procedure and function according to condition.
- Apply security and confidentiality on given 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 GUI based database software (MS-Access/Visual Foxpro/MySQL.
- Any RDBMS software (MySQL/SQL server.
Unit 1
Database System Concept
Total Teaching Hours – 10
Distribution of Theory Marks
R Level – 04
U Level – 04
A Level – 04
Total Marks – 12
Unit Outcomes (UOs) (in cognitive domain)
- State the importance of DBMS over file processing in the given situation.b Describe the ovcralQ structure of the given DBMS
- Identify the relevant database model in the given situation.
- Draw the E-R diagram of the given database and identify relationship between the entities.
Topics and Sub-topics
- Concept of Data, database, DBMS, advantages of DBMS over file processing system, Application of database.
- Three level Architecture for Database system.
- Data abstraction: Different levels of Data abstraction, Instance and schema, Data independence – Logical and Physical Independence.
- Overall Structure of DBMS.
- Data Modeling: Record based logical model-Relational, Network, Hierarchical
- Data Modeling Using the E-R Model: Entity Relationship Model , Strong Entity set, Weak Entity set, Types of Attributes, E-R Diagrams.
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
Interactive SQL and Advance SQL: SQL Performance Tuning
Total Teaching Hours – 14
Distribution of Theory Marks
R Level – 02
U Level – 04
A Level – 08
Total Marks – 14
Unit Outcomes (UOs) (in cognitive domain)
- Write the given queries using relevant functions.
- Write query to combine the given multiple table using Join.
- Design SQL queries to implement VIEWS on the given tables.
- Apply and drop INDEXES and SYNONYM on the given table.
Topics and Sub-topics
- In-built Functions: String, Arithmetic.
- Date and time, Aggregate functions.
- Queries using Group by, having, and Order by clause, Joins-Inner and Outer Join, Sub queries.
- Views: Concept of View, The Create View Command, Updating Views. Views and Joins, s 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
Unit Outcomes (UOs) (in cognitive domain)
Total Teaching Hours – 14
Distribution of Theory Marks
R Level – 02
U Level – 04
A Level – 08
Total Marks – 16
- Write simple PL/SQL Code using control structure and handle various exceptions in the given situation.
- Create cursor for retrieving multiple records in the given situation.
- Create and Execute stored procedures and functions in the given situation.
- Create and apply database trigger using PL/SQL in the given situation.
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: Predefined 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, How to 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 journal of practical.
- 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. 10, teachers need to ensure to create opportunities and provisions for co-curricular activities.
- Guide student 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..
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 1SRD Group McGraw Hill Education, New Delhi, 2015
- Introduction to Relational databases & SQL programming Allen McGraw Hill Education, New Delhi, 2015
- Database System Concepts McGraw Hillin ANSI C Korth McGraw Hill Education, New Delhi, 2015
- Complete Reference:Mysql Vikram Vaswani McGraw Hill Education, New Delhi. 2015
Software/Learning Websites:
- www.tutorialpoint.com (Important website)
- wielylndia.com or DreamtechPress.com
- http://phindia.com/gupta/chapter/chapterl .pdf
- www.williamstanninus.com
- www.nptel.ac.in
- https://www.khanacademy.org/
For detail Syllabus of all other subjects of Computer Science & Engineering, I – scheme do visit Computer Science & Engineering 3rd Sem Syllabus for I – scheme.
For all Computer Science & Engineering results, visit MSBTE Computer Science & Engineering all semester results direct links.