Principles of Database 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 3rd Sem I – Scheme MSBTE, do visit Diploma in Information Technology (IF) Syllabus for 3rd Sem I – Scheme MSBTE Subjects. The detailed Syllabus for principles of database 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:
- Develop Relational Database by applying principles of database design.
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:
- Use fundamental concepts of database in a Database System.
- Choose relevant data model to solve a problems.
- Develop relational databases using Entity Relationship modelling approach.
- Apply constraints for data integrity in Relational database.
- Apply data normalization and denormalization techniques 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- Operating System: Windows 7 or higher Memory: 2 GB RAM or higher Processor Speed: Intel Core i3 or higher Hard Drive: 500 GB or larger . DVD Drive: DVD +/- RW
- Database Management System product with Graphical User Interface such as MS-ACCESS, MySQL, MariaDB
Unit 1
Basics of Database and Architecture
Total Teaching Hours – 08
Distribution of Theory Marks
R Level – 04
U Level – 04
A Level – 04
Total Marks – 12
Unit Outcomes (UOs) (in cognitive domain)
- Distinguish the data and information based on their characteristics in the given context.
- Identify database components for the given database application.
- Differentiate the features of the given databases with examples.
- Explain the three level of architecture of database for the given application system.
Topics and Sub-topics
- Introduction: Data, Database and its purpose, Characteristics of the database, file system vs. database approach, Different types of Database, Advantages and disadvantages of database systems.
- Concepts of database: Components of database- Hardware, Software, People, Procedure.Database Product, Data abstraction, Database languages -Data Definition Language(DDL), Data Manipulation Language(DML), Data Control Language(DCL).Data independence – Logical and Physical Independence. Data integrity.
- Architecture of data base: Three Level Architecture for a Database System-Database (Data) Tier, Application (Middle) Tier and User (Presentation) Tier.
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
Database Design using ER model
Total Teaching Hours – 12
Distribution of Theory Marks
R Level – 02
U Level – 04
A Level – 08
Total Marks – 14
Unit Outcomes (UOs) (in cognitive domain)
- Represent identified entities set and their relationship in terms of tables for the given application system.
- Use relevant types of Key to establish the given type of relation between tables.
- Design E-R diagram for the given application system.
- Identify the shortcomings of ER modeling approach for the given system to resolve it through EER approach.
Topics and Sub-topics
- Entities, Entity set. Relationships
- Representation of entities, attributes, relationship attributes, relationship set
- Generalization, aggregation
- Structure of relational Database and different types of keys. Expressing M: N relation
- Shortcomings of ER Model. Enhanced ER (EER) model; sub class, super class, Specialization and Generalization.
Unit 4
Relational Data Base Model
Total Teaching Hours – 12
Distribution of Theory Marks
R Level – 02
U Level – 06
A Level – 10
Total Marks – 18
Unit Outcomes (UOs) (in cognitive domain)
- Apply relevant key in database to comply the given constraints.
- Describe with sketches the schema diagram of the given database.
- Apply the given constraints on the specified identified database application.
- Write procedure to manipulate the given table by adding/ modifying/ deleting records.
Topics and Sub-topics
- Database schema and subschema
- Relational databases and relational database schemes, Entity integrity, referential integrity and foreign key.
- Relational constraints and relational database schemes-Domain constraints, Key constraints, Not Null.
- Codds rules of RDBMS.
- Working with RDBMS: Create table, insert values in the table, edit table, delete table using appropriate GUI based database.
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 Practicals.
- 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 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.
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:
- Database Management Systems Gupta, G. K. McGraw Hill Education, New Delhi 2013, ISBN: 978-07-107273-1
- An Introduction to Database Systems Date, C. J. Addison Wesley, New Delhi 2003 ISBN 13: 9780321189561
- Database System Concepts-6e Silberschatz Abraham, Korth Henry, Sudarshan S. McGraw Hill Education, New Delhi 2013, ISBN: 978-93-329-0138-4
- Database Management System- A practical approach Chopra, Rajiv S. Chand and Company, New Delhi 2016, ISBN:978-93-856-7634-5
Software/Learning Websites:
- www.webopedia.com
- https://www.tutorialspoint.com/database_tutorials.htm
- www.studytonight.com/dbms/overview-of-dbms.php
- www.beginnersbook.com/2015/04/dbms-tutorial/
- www.w3schools.in/dbms/
- www.tutorialspoint.com/listtutorials/ms-access/1
- http://www.quackit.com/microsoft_access/tutorial/
- https://www.techonthenet.com/access/tutorials/
For detail Syllabus of all other subjects of Information Technology, I – scheme do visit Information Technology 3rd Sem Syllabus for I – scheme.
For all Information Technology results, visit MSBTE Information Technology all semester results direct links.