MEL401: Data Base and Information Retrieval Syllabus for ME 4th Sem 2017 Pattern Mumbai University

Data Base and Information Retrieval detailed syllabus scheme for Mechanical Engineering (ME), 2017 regulation has been taken from the University of Mumbai official website and presented for the Bachelor of Engineering students. For Course Code, Course Title, Test 1, Test 2, Avg, End Sem Exam, Team Work, Practical, Oral, Total, and other information, do visit full semester subjects post given below.

For all other Mumbai University Mechanical Engineering 4th Sem Syllabus 2017 Pattern, do visit ME 4th Sem 2017 Pattern Scheme. The detailed syllabus scheme for data base and information retrieval is as follows.

Data Base and Information Retrieval Syllabus for Mechanical Engineering SE 4th Sem 2017 Pattern Mumbai University

Course Objectives:

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 pdf platform to make students’s lives easier.
.

Course Outcomes:

Learner will be able to

1. Identify data models and schemes in DBMS
2. Demonstrate the features of database management systems and Relational database
3. Use SQL- the standard language of relational databases
4. Demonstrate understanding of functional dependencies and design of the database
5. Design graphical user Interface for specific application
6. Create visual software entities

Module 1

Introduction to Database Concept: What is a database?, Characteristics of database, Example of database, File system V/s Database system, What is DBMS?, Users of database system, Advantage of using an enterprise database, Concerns when using an enterprise database, Data independence, DBMS systems architecture, Database administrator 02

Module 2

Entity-Relationship Data Model: Introduction, Benefits of Data Modelling, Types of Models, Phases of Database Modelling, The Entity-Relationship (ER) Model, Generalisation, Specialization and Aggregation, Extended Entity-Relationship (EER) Model 04

Module 3

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 pdf platform to make students’s lives easier.
.

Module 4

Structured Query Language (SQL): Overview of SQL, Data definition commands, set operations, aggregrate functions, null values, Data manipulation commands, Data control commands, Views- using virtual tables in SQL, Nested and complex queries 04

Module 5

Introduction to Transactions Management and Co-currency: Transaction concept, transaction states, ACID properties, Implementation of atomicity and durability, Concurrent Executions, Serializability, Recoverability, Co-currency Control: Lock-based, Timestamp-based, Validation-based protocols, Deadlock handling, Recovery system, Failure classification, Storage structure, Recovery and atomicity, Log based recovery, Shadow paging 04

Module 6

Graphical User Interface: Murphys law of GUI design, Features of GUI, Icons and graphics, Identifying visual cues, clear communication, colour selection, GUI standard, planning GUI Design Work Visual Programming: Sharing Data and Code: Working with projects, introduction to basic language, Using inbuilt controls and ActiveX controls, creating and using classes, introduction to collections, usinf and creating ActiveX components, dynamics data exchange, Object linking and embedding, Creating visual software entities: Working with text, graphics, working with files, file management, serial communication, multimedia control interfaces 06

Assessment:

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 pdf platform to make students’s lives easier.
.

End Semester Practical/Oral Examination:

1. Practical examination of 2 hours duration followed by viva to be conducted by Pair of Internal and External Examiner based on contents
2. Evaluation of practical examination to be done by examiner based on the printout of students work
3. Distribution of marksPractical examination: 40 marks Viva based on practical examination 10 marks
4. Students work along with evaluation report to be preserved till the next examination

Reference Books:

1. Database Management Systems, G K Gupta, McGraw – Hill
2. Database System Concepts, Korth, Slberchatz, Sudarshan, 6thEdition, McGraw – Hill
3. GUI Design for dummies, IDG books
4. Visual Basic 2005, How to program, Deitel and Deitel,3rdEdition, Pearson Education
5. SQL and PL/SQL for Oracle 10g,Black Book, Dr P S Deshpande, Dreamtech Press
6. Introduction to Database Management, Mark L Gillenson, Paulraj Ponniah, Wiley
7. Oracle for Professional, Sharaman Shah, SPD.
8. Database Management Systems, Raghu Ramkrishnan and Johannes Gehrke, TMH
9. Fundamentals of Database Management System, Mark L Gillenson, Wiley India

For detail syllabus of all other subjects of Mechanical Engineering (ME) 4th Sem 2017 regulation, visit ME 4th Sem Subjects syllabus for 2017 regulation.