CSL503: Database & Info. System Tab Syllabus for CS 5th Sem 2018 Pattern Mumbai University

Database & Info. System Tab detailed syllabus scheme for Computer Engineering (CS), 2018 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 Computer Engineering 5th Sem Syllabus 2018 Pattern, do visit CS 5th Sem 2018 Pattern Scheme. The detailed syllabus scheme for database & info. system tab is as follows.

Database & Info. System Tab Syllabus for Computer Engineering TE 5th Sem 2018 Pattern Mumbai University

Lab Outcome:

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

Suggested List of Experiments:

1. Identify the case study and detail statement of problem. Design an Entity-Relationship (ER) / Extended Entity-Relationship (EER) Model.
2. Mapping ER/EER to Relational schema model.
3. Create and populate database using Data Definition Language (DDL) and DML Commands for youre the specified System.
4. Apply Integrity Constraints for the specified system.
5. Perform Simple queries, string manipulation operations.
6. Nested queries and Complex queries
7. Perform Join operations
8. Views and Triggers
9. Functions , cursor and procedure.
10. Transaction and Concurrency control
11. Mini project- Creating a Two-tier client-server database applications using JDBC

Assignment: Perform Normalization -1NF, 2NF, 3NF Term Work: Laboratory work will be based on DBMS syllabus with minimum 10 experiments to be incorporated. Experiments should be completed by students on the given time duration Experiments (10) Marks Mini Project (10) Marks Attendance (Theory + Practical. (05) Marks Total (25) Marks Practical and Oral : Practical and oral Exam should be conducted for the Lab, on Database Management System subject for given list of experiments . Implementation (15) Marks Oral (10) Marks Total (25) Marks Oral & Practical exam will be based on the above and CSC502: DBMS syllabus

Text Books:

1. G. K. Gupta :Database Management Systems, McGraw – Hill.
2. Korth, Slberchatz,Sudarshan, :Database System Concepts, 6th Edition, McGraw – Hill
3. Elmasri and Navathe, Fundamentals of Database Systems, 5thEdition, PEARSON
4. Peter Rob and Carlos Coronel, Database Systems Design, Implementation and Management, Thomson Learning, 5th Edition.

Reference Books:

1. Dr. P.S. Deshpande, SQL and PL/SQL for Oracle 10g,Black Book, Dreamtech Press
2. PaulrajPonniah, Introduction to Database Management,Wiley publication
3. Raghu Ramkrishnan and Johannes Gehrke, Database Management Systems,TMH
4. Debabrata Sahoo Database Management Systems Tata McGraw Hill, Schaums Outline

For detail syllabus of all other subjects of Computer Engineering (CS) 5th Sem 2018 regulation, visit CS 5th Sem Subjects syllabus for 2018 regulation.