Go Back   2018 2019 Student Forum > Management Forum > Main Forum



 
Thread Tools
  #1  
Old 26th April 2016, 11:13 AM
Unregistered
Guest
 
Posts: n/a
Default Mumbai University Database

Hello sir this is karan and I am looking for the syllabus of Database Management System from University of Mumbai please can you help me in this case
Reply With Quote Quick reply to this message

  #2  
Old 26th April 2016, 11:15 AM
Super Moderator
 
Join Date: May 2012
Posts: 58,013
Default Re: Mumbai University Database

The University of Mumbai is one of the first three state universities of India and the oldest in Maharashtra The University of Mumbai offers Bachelors, Masters and Doctoral courses apart from diplomas and certificates in many disciplines

As you are asking about the syllabus of Database Management System from University of Mumbai please have a look on the below given information

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

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

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 sequential 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, updating and
Deletion using the referential integrity constraints

10) Write the query for creating the users and their role.

For more detail about the syllabus please have a look on the below given PDF



Contact Detail


121, Mahatma Gandhi Rd,
Kala Ghoda Mumbai, Maharashtra 400001
Reply With Quote Quick reply to this message
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pacific University Library Database Unregistered Main Forum 2 10th July 2018 03:27 PM
IIT Madras Alumni Database Unregistered Main Forum 2 10th May 2018 09:18 AM
Database Management System Syllabus Anna University Unregistered Main Forum 1 11th April 2016 05:18 PM
Database Certification Courses Unregistered Main Forum 1 8th April 2016 03:44 PM
Database And Database Management System Unregistered Main Forum 1 3rd March 2016 04:23 PM
Which of the Following is a Database Management System Unregistered Main Forum 1 12th February 2016 10:00 AM
Sequel Database Training Unregistered Main Forum 1 8th January 2016 07:09 PM
Graduate school database Unregistered Main Forum 1 26th December 2015 04:28 PM
Grad school database Unregistered Main Forum 1 26th December 2015 01:27 PM
Database Developer Certification Unregistered Entrance Exams 1 15th December 2015 09:03 AM
SQL Database Classes Unregistered Entrance Exams 1 11th December 2015 02:27 PM
GIA Job Database rohit vaid Main Forum 3 1st December 2015 01:29 PM
Database Administrator Courses Unregistered Main Forum 1 21st November 2015 04:06 PM
CSU OT Fieldwork Database Unregistered Main Forum 1 17th November 2015 01:31 PM
Oracle Database Administrator Course Unregistered Main Forum 1 6th November 2015 10:06 AM
Pacific University Database Unregistered Main Forum 1 6th August 2015 04:30 PM
IIT Kharagpur Alumni Database Unregistered Main Forum 0 26th June 2015 02:44 PM
Xavier University Database Unregistered Main Forum 1 18th June 2015 03:43 PM
IITD IRIS Database Unregistered Main Forum 0 9th May 2015 10:06 AM
Bangalore University Database Unregistered Entrance Exams 0 16th April 2015 09:11 AM


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 11:24 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.0 PL2

1 2 3