Practicals 1

PPR RA AC CTTIIC CA ALLSS IIN NA AD DV VA AN NC CEED DD DA ATTA AB BA ASSEESS D E P A R T M E N T O F C O M P U T E R S C DEPARTMENT OF COMPUTER SCIIEEN NC CEE U UN NIIV VEER RSSIITTY YO OFF M MU UM MB BA AII 1.

For a given a global conceptual schema, divide the schema into vertical fragments and place them on different nodes. Implement at least 5 suitable queries on these fragments that will demonstrate distributed databases environment.

2.

For a given a global conceptual schema, divide the schema into horizontal fragments and place them on different nodes. Implement at least 5 suitable queries on these fragments that will demonstrate distributed databases environment.

3.

Place the replication of global conceptual schema on different nodes and implement at least 5 suitable queries that will demonstrate distributed databases environment.

4.

Create different types that include attributes and methods. Define tables for these types by adding at least 10 tuples. Demonstrate insert, update and delete operations on these tables. Fire at least 5 queries on them.

5.

Create a nested table and insert 5 tuples and fire 5 queries.

6.

a. Create a table that contains at least one attribute of an image. Add at least 10 tuples in the table and write query to invoke a particular image. b. Create a table that contains at least one attribute of an audio. Add at least 10 tuples in the table and write query to invoke a particular audio. c. Create a table that contains at least one attribute of a video. Add at least 10 tuples in the table and write query to invoke a particular video.

7.

Create a temporal database and issue at least 3 queries on it.

8.

Create a table that store the special data and issue at least 3 queries.

9.

Formulate a database using active rules using row and statement level.

10.

Create a XML data base and add 3 tuples . Demonstrate insert, update and delete operations on these tables. Fire at least 5 queries on them.

EEEEEEEEEEEEEEE