Go Back   2023 2024 MBA > MBA > Main Forum

  #1  
Old 16th November 2015, 01:43 PM
Unregistered
Guest
 
Default Mumbai University DBMS Lab Manual

Will you please share with me the University of Mumbai DBMS Lab Manual as it is very urgent for me?
Reply With Quote Quick reply to this message
  #2  
Old 16th November 2015, 01:53 PM
Super Moderator
 
Join Date: Jul 2012
Default Re: Mumbai University DBMS Lab Manual

As you want to get the University of Mumbai DBMS Lab Manual so here is the information of the same for you:

Some content of the file has been given here:

Unit – I Introduction to Databases and Transactions:
What is database system, purpose of database system, view of data, relational databases, database architecture, transaction management

Unit- II Data Models:
The importance of data models, Basic building blocks, Business rules, The evolution of data models, Degrees of data abstraction.

Unit-III Database Design, ER-Diagram and Unified Modeling Language:
Database design and ER Modelverview, ER-Model, Constraints, ER-Diagrams, ERD Issues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML

Relational database model:
Logical view of data, keys, integrity rules.

Relational Database design:
Features of good relational database design, atomic domain and Normalization (1NF, 2NF, 3NF, BCNF).

Unit- IV Relational Algebra and Calculus:
Relational algebra:
Introduction, Selection and projection, set operations, renaming, Joins, Division, syntax, semantics. Operators, grouping and ungrouping, relational comparison.

Calculus:
Tuple relational calculus, Domain relational Calculus, calculus vs algebra, computational capabilities.

Unit- V Constraints, Views and SQL:
What is constraints, types of constrains, Integrity constraints,

Views:
Introduction to views, data independence, security, updates on views,
comparison between tables and views

SQL:
Data definition, aggregate function, Null Values, nested sub queries, Joined
relations.

Unit-VI Transaction management and Concurrency control:
Transaction management: ACID properties, serializability and concurrency control,
Lock based concurrency control (2PL, Deadlocks),Time stamping methods,
optimistic methods, database recovery management.

Books:
A Silberschatz, H Korth, S Sudarshan, “Database System and Concepts”, fifth Edition McGraw-Hill, Rob, Coronel, “Database Systems”, Seventh Edition, Cengage Learning.
Practicals:
1) Design a Database and create required tables. For e.g. Bank, College Database
2) Apply the constraints like Primary Key , Foreign key, NOT NULL to the tables.
3) Write a sql statement for implementing ALTER,UPDATE and DELETE
4) Write the queries to implement the joins
5) Write the query for implementing the following functions: MAX(),MIN(),AVG(),COUNT()
6) Write the query to implement the concept of Intergrity constrains
7) Write the query to create the views
8) Perform the queries for triggers
9) Perform the following operation for demonstrating the insertion , updation and deletion using the referential integrity constraints
10) Write the query for creating the users and their role.

INTRODUCTION TO DATABASE MANAGEMENT SYSTEM:
Unit Structure
1.0 Objectives
1.1 Introduction
1.2 What is Database Management System
1.3 History of Database System
1.4 Purpose of Database System
1.5 Advantages and Disadvantages of Database System
1.6 Summary
1.7 Model Questions

1.1 INTRODUCTION
In today’s world as the information technology has changed rapidly, many computing applications deal with large amounts of information regularly.

As the end user applications has changed significantly in last few decades, there is a challenge to store the large amount of information, retrieve and manage this information in timely manner.

This can be achieving today by making use of services of Database Management System (DBMS).

Today DBMS not only used to insert, update and delete the data stored in database.

The job of DBMS system is to collect the data, give a systematic representation to it and also provides ways for the data to be modified or extracted by users or other programs.

As the technology has grown rapidly in past four decades, today DBMS has gain its own importance because the data has brought online in the hands of end user through different computer networking.

For more detailed information I am uploading 2 PDF file which are free to download:

University of Mumbai DBMS Lab Manual





Contact Details:
University of Mumbai
CST Road,
Kalina, Santacruz East
Mumbai,
Maharashtra 400098
India

Attached Files
File Type: pdf University of Mumbai DBMS Lab Manual.pdf (86.5 KB, 1684 views)
Reply With Quote Quick reply to this message
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
IKEA Manual kavita Online MBA Discussions 2 5th April 2018 04:28 PM
SWM Manual CPHEEO Unregistered Main Forum 1 19th July 2017 03:56 PM
Network Lab Manual Anna University Unregistered Main Forum 1 3rd December 2016 02:33 PM
DBMS For SBI SO Unregistered Main Forum 1 26th November 2016 12:53 PM
UPTU DBMS Question Paper Unregistered Main Forum 1 12th November 2016 12:48 PM
VTU LD Lab Manual Unregistered Main Forum 1 8th November 2016 09:00 AM
DBMS for SBI Specialist Officer Unregistered Main Forum 1 26th October 2016 05:03 PM
DBMS Lab KSOU Unregistered Main Forum 1 27th September 2016 03:02 PM
SRM University Lab Manual Unregistered Main Forum 0 18th July 2015 03:24 PM
DBMS Notes MDU Unregistered Main Forum 0 17th July 2015 11:21 AM
DBMS University Question Paper with Answers Unregistered Main Forum 0 17th July 2015 10:12 AM
Anna university Chennai EP lab manual Unregistered Main Forum 0 13th July 2015 04:49 PM
DBMS Study Material for IBPS IT Officer Unregistered Main Forum 0 13th July 2015 09:26 AM
Anna University Os Lab Manual Unregistered Main Forum 0 11th July 2015 04:08 PM
RTU DBMS syllabus Unregistered Main Forum 0 10th July 2015 05:13 PM
DBMS lab manual for Anna university Unregistered Main Forum 0 10th July 2015 03:19 PM
BME lab manual MDU Unregistered Main Forum 0 10th July 2015 12:43 PM
VTU lab manuals lab manual Emmanuel Herrand45 Main Forum 1 27th November 2012 09:47 AM
DBMS Anna university syllabus summit thakur.e Main Forum 1 29th September 2012 11:01 AM
VTU Lab Programs DBMS navid khan Main Forum 1 10th August 2012 01:39 PM


Quick Reply
Your Username: Click here to log in

Message:
Options

Thread Tools Search this Thread



All times are GMT +5.5. The time now is 06:10 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2