University of Mumbai 2006-7th Sem B.E Information Technology Database Systems IT - Question Paper

(1) Question No. one is compulsory.
(2) Attempt any Jour out ol the remaining ques..
(3) Answers to sub-questions must be written together.

1) You have to design and implement a database that manages info about publishers, authors, and books. a few info includes:

• A publisher has a name and an address for the headquarters. every publisher also has a set of branches, every branch having an address and 2 phone numbers.
• An writer has a name and an address;
• A book is published by n publisher and has a list of writers associated with it. An writer can publish several books and a book can be published by at most 1 publisher.

a) Draw an Extended Entity-Relationship diagram (5)
b) Specify an object-relational database schema that suitably
represents the above properties. Use object-relational features
(user-defined data types, object tables, references, nested
tables...) whenever suitable. Use SQL 3 (10)
c) Write a SQL three query for the subsequent query :
List the name of the writer who has published the most books
with publisher "McGraw Hill" (5)

2. (a) Compare and contrast two tier and three tier,
Client server architecture (10)
(b) Consider an airline database that keeps track of passenger
reservations on various flights. Design Object Oriented
Schema for the system (10)

3. University of Mumbai wants to put up its database of examination outcomes
for the past 20 years onto the web.
(a) explain the design such a web database. (10)
(b) define XML schemas for the database (10)

4 (a) Consider the global schema;
PA TIENT (Number, Name, SSN, Amouni(_Due, Dept, Doctor,
Med_treatment)
DEPARTMENT(Dept, Location, Director)
STAFF (Staffnumi, Director, Task)
1. Show two examples of horizontal fragmentation
2. Show two examples of vertical fragmentation
3. Show two examples of derived fragmentation (5 * three «I5 )
(b) define in brief the design and implementation problems for
mobile databases (5)

5 (a) define with example applications the need for relational object
end object relational databases (10)

(b) Compare and contrast the object and the relational data models (10)

6. discuss the-following concepts with examples:
(a) Object Identity (OID)
(b) Type constructor
(c) Persistent data kinds
(d) Accessor functions (GET and SET) (5 * four * 20)

7. Write detailed notes on
a) Spatial Databases
b) Mobile Database: (10*2=* 20)

Earning:   Approval pending.