IT303: Sql Lab Syllabus for IT 3rd Sem 2017 Pattern Mumbai University

Sql Lab detailed syllabus scheme for Information Technology (IT), 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 Information Technology 3rd Sem Syllabus 2017 Pattern, do visit IT 3rd Sem 2017 Pattern Scheme. The detailed syllabus scheme for sql lab is as follows.

Sql Lab Syllabus for Information Technology SE 3rd 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:

Student should be able to:

1. Construct problem definition statements for real life applications and implement a database for the same.
2. Design conceptual models of a database using ER modeling for real life applications and also construct queries in Relational Algebra.
3. Create and populate a RDBMS, using SQL.
4. Write queries in SQL to retrieve any type of information from a data base.
5. Analyze and apply concepts of normalization to design an optimal database.
6. Implement indexes for a database using techniques like B or B+ trees.

Hardware Requirement:

PC i3 processor and above

Software requirement:

Any SQL Compiler

Prerequisites:

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

Lab

1. 1. Students to be given assignments to construct detailed problem definitions for real life applications.
   2. Construction of ER/EER diagrams for the given problems.
   3. Assignment based on relational Algebra 4 CO 1 CO 2
2. 1. Basic SQL Queries-DDL and DML.
   2. Construction of Database-Keys
   3. Population of the database 5 CO 3
3. Complex Queries using group by, nested queries, recursive queries, joins, views, Triggers, Cursors 5 CO 4
4. Design and Implementation of a fully fledged Database with front end for a real life application (Using JDBC. 4 CO 1
5. Assignment for conversion of relation to different normal forms. 2 CO 5
6. Program for construction of index- B-Tree / B+-Tree 4 CO 6

Text Books:

1. SQL The Complete Reference, 3rd Edition , James R Groff, Paul N. Weinberg, Andy Oppel, McGraw Hill.
2. G. K. Gupta :Database Management Systems, McGraw – Hill

Reference Books:

1. Korth, Slberchatz,Sudarshan, :Database System Concepts, 6th Edition, McGraw – Hill
2. Raghu Ramkrishnan and Johannes Gehrke, Database Management Systems, TMH

Term Work:

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 Information Technology (IT) 3rd Sem 2017 regulation, visit IT 3rd Sem Subjects syllabus for 2017 regulation.