Advanced Database Management Systems detailed Syllabus for Computer Technology (CM), 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 the other Computer Technology CM syllabus for 5th Sem, do visit Diploma in Computer Technology 5th Sem I – Scheme. For all the Computer Technology Elective-I subjects refer to Computer Technology Elective-I Scheme. The detail syllabus for advanced database management systems 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 Advanced Database Management Systems concepts using MongoDB and XML
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:
- Differentiate various database architectures.
- Use Object Oriented and Advanced XML queries on Database.
- Manipulate data using MongoDB commands.
- Use Data Mining And Data Warehousing Concepts.
- Use Big Data Concepts.
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/Oracle/SQL server/MongoDB or any other.
Unit 1
Database 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)
- Describe the given clientserver Database Model.
- Use the given locking protocols for concurrency control.
- Apply parallel and distributed database techniques in given situation.
- Differentiate between Parallel and Distributed Databases.
Topics and Sub-topics
- Introduction to client-server Database Model: Two-Tier Client server model, Three-Tier Client server model.
- Concurrency Control Techniques: Concurrency control protocols: Locked Based protocols, granting of locks, Two Phase Locking protocol.
- Introduction to parallel databases: Parallel database system architecture, Types of parallelism, Parallel Database Implementation.
- Introduction to distributed databases: Distributed database system architecture, Benefits of distributed database system, Issues with distributed database systems.
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
Advanced Database Techniques
Total Teaching Hours – 12
Distribution of Theory Marks
R Level – 06
U Level – 04
A Level – 06
Total Marks – 16
Unit Outcomes (UOs) (in cognitive domain)
- Differentiate structured and Unstructured Data.
- Use NoSQL database to solve given queries.
- Use MongoDB to solve given queries.
- Differentiate SQL and NoSQL databases.
- Write query to execute find() function on given data.
- Implement basic operations performed on MongoDB shell on given data.
- Write query using aggregate() method on given data.
Topics and Sub-topics
- Structured versus Unstructured data
- NoSQL database concepts: Types of NoSQL databases, NoSQL data modeling, Benefits of NoSQL, comparision between SQL and NoSQL database system.
- NoSQL using MongoDB: Introduction to MongoDB Shell, Running the MongoDB shell, MongoDB client, Basic operations with MongoDB shell, Basic Data Types ,Arrays, Embedded Documents
- Querying with MongoDB: find() function, specifying which keys to return, query criteria, OR queries, Types specific querying
- Aggregation Introduction: Aggregation Pipeline, Aggregation using Map reduce, Single purpose aggregation
Unit 4
Advances in Databases
Total Teaching Hours – 08
Distribution of Theory Marks
R Level – 02
U Level – 08
A Level – 04
Total Marks – 14
Unit Outcomes (UOs) (in cognitive domain)
- Define data mart, meta data
- Explain architecture of data warehouse
- Analyze given data using data mining.
- Describe the features of BI and BI components framework.
- Explain use of spatial databases in a given situation.
Topics and Sub-topics
- Introduction to Data Warehouse Characteristics, Types of Data Warehouse Architecture, Data Marts, Data Warehousing Lifecycle, Data Warehouse Development
- Introduction to Data Mining Techniques: Data mining technology and its relation to data warehousing, Association rules, classification and clustering, Applications of data mining.
- Introduction to business Intelligence: Features, frameworks, Types and approaches for machine learning
- Introduction to Multimedia Databases, Mobile Databases and digital databases
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.
- 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.
- 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:
- Database Management Systems Application Kogent Learning Solutions Inc. Dreamtech Press 2014, ISBN-978-93- 5119-476-7
- Database System Concepts Korth Henery Tata McGraw Hill Education, 6111 Edition ,ISBN -13:978-93-329-0138-4
- Complete Reference: Mysql Vaswani Vikram McGraw Hill Education, ISBN-13: 9780070586840
- SQL, PL/SQL The Programming Language of ORACLE Bayross Ivan BPB Publications, 3rd Edition ISBN-13: 978-8176569644
Software/Learning Websites:
- https://www.tutorialspoint.com
- https://www.w3schools.com
- http://db.ucsd.edu/static/csel32b-sp01/oql.htm
- https://docs.mongodb.com/manual/tutorial/install-mongodb-on-windows/
- http://www.es.stir.ac.uk/courses/CSC9T6/practicals/l%20Data%20Mining/l%20-%20Weka%201.pdf
For detail Syllabus of all other subjects of Computer Technology, 5th Sem, scheme I -, visit Computer Technology 5th Sem Syllabus for I – Scheme.
For all Computer Technology results, visit MSBTE Computer Technology all semester results.