Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

My Assingment effective title and description for your document:, Exams of Data Warehousing

This is my assingment My Assingment effective title and description for your document:My Assingment effective title and description for your document:

Typology: Exams

2016/2017

Uploaded on 05/03/2017

2019539
2019539 🇬🇧

1

(1)

1 document

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
1 .
A well-maintained relational DBMS has a high level of data integrity. What
features of a relational DBMS contribute towards this level of integrity?
2 .
(a) Explain the various functions of RDBMS? Name the dierent categories
of RDBMS users and how they are dierent from each other.
(b) RDBMS has become most popular Database System world wide? Justify
your answer with suitable example.
pf3
pf4

Partial preview of the text

Download My Assingment effective title and description for your document: and more Exams Data Warehousing in PDF only on Docsity!

A well-maintained relational DBMS has a high level of data integrity. What features of a relational DBMS contribute towards this level of integrity?

(a) Explain the various functions of RDBMS? Name the different categories of RDBMS users and how they are different from each other.

(b) RDBMS has become most popular Database System world wide? Justify your answer with suitable example.

Explain different integrity constrains supported by RDBMS and ORDBMS with suitable examples.

Process of normalization is the integral part of designing a database. Justify this statement with suitable database design.

Differentiate among on any three of the following giving suitable examples:-

What do you mean by view? What are its different types? Differentiate between updatable and non updatable view with suitable examples. Also give proper syntax for creating view.

  1. Explain the difference between the Drop & Delete, Commit & Rollback and Alter & Update with suitable examples.