STUPIDSID
This Qs paper appeared for ADBMS of Computer Engineering (Semester 5)
1(a)
You need to design a database for an art gallery. The database schema must keep information about artist, their names, (which are unique), birth places, age, style of art and photograph. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g. Painting, sculpture, photograph), and its price, along with picture(thumbnail) must be stored. The database also stores information about customers.
For each customer, database stores the persons unique name, address and total amount of money spent in the gallery and the artist and type of art the customer tends to like (can be text).
Draw an EER diagram from the system
For each customer, database stores the persons unique name, address and total amount of money spent in the gallery and the artist and type of art the customer tends to like (can be text).
Draw an EER diagram from the system
6 M
1(b)
Map the EER to Relations for Q 1(a)
8 M
1(c)
Take two typical queries and write them in SQL for Q 1(a)
6 M
2(a)
Explain different architectures of parallel databases
10 M
2(b)
State comparison of RDBMS, OODBMS, ORDBMS
10 M
3(a)
Explain data fragmentation, replication and allocation technique for distributed database design.
10 M
3(b)
Give an overview of 3-Tier client server architecture
10 M
4(a)
What is SQL-3? Write in detail about features of SQL 3
10 M
4(b)
What is well formed and valid XML document? With example explain what is XML schema file?
10 M
5(a)
Explain in detail about heuristic approach to query optimization
10 M
5(b)
Explain the method for implementing the SELECT operation
10 M
6(a)
Explain conceptual database design in database design and implementation process.
10 M
6(b)
Explain concurrency control in distributed database
10 M
7. Write short notes on (any two):
7(a)
Specialization and Generalization
10 M
7(b)
Joins in SQL
10 M
7(c)
Measures of query cost
10 M
More question papers from Advanced Database Management Systems