AEL401: Data Base and Information Retrival Syllabus for AE 4th Sem 2017 Pattern Mumbai University

Data Base and Information Retrival detailed syllabus scheme for Automobile Engineering (AE), 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 Automobile Engineering 4th Sem Syllabus 2017 Pattern, do visit AE 4th Sem 2017 Pattern Scheme. The detailed syllabus scheme for data base and information retrival is as follows.

Data Base and Information Retrival Syllabus for Automobile Engineering SE 4th Sem 2017 Pattern Mumbai University

Course Outcomes:

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 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

Rational Model and Algebra: Introduction, Mapping the ER and EER Model to the relational Model, Data Manipulation, Data Integrity, Advantages of Relational Model, Relational Algebra, Relational Algebra Queries, Relational Calculus 04

Module 4

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 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:

Term Work: Assign minimum two case studies for each student. On their case studies following exercises to be performed

1. Problem Definition and draw ER /EER diagram
2. Design Relational Model
3. Perform DDL operation
4. Perform DML and DCL operations
5. Design Forms using Visual programming
6. Retrieve the information through GUI.Distribution of Term work Marks Laboratory work 40 Marks Attendance 10 Marks

End Semester Practical/Oral Examination:

1. Practical examination of 2 hours duration followed by Oral 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 Oral based on practical examination 10marks
4. Students work along with evaluation report to be preserved till the next examination

Reference Books:

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.
.

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