ADVANCE DATABASE MANAGEMENT SYSTEM (ADBMS) DECEMBER 2010 SEMESTER 5 COMPUTER SCIENCE
Con. 6095-10 (REVISED COURSE) GT-6712
(3 Hours) [Total Marks : 100]
N.B. : (1) Question no. 1 is compulsory.
(2) Attempt any four out of remaining.
| 1. a) | Define data warehousing and data mining. List the applications. | 5 |
| b) | Explain concept of Geographical information System. | 5 |
| c) | Compare RDBMS, OODBMS and ORDBMS. | 5 |
| d) | Write short note on Query processing in distributed databases. | 5 |
2. a) | Describe different architecture for Parallel Database. | 10 |
| b) | Explain mobile databases and multimedia databases. | 10 |
3. a) | What is DTD ? Give the DTD for an XML representation of the following nested | 10 |
| relational schema. | ||
| Emp=(ename, Childrenset setof(children),Skillsetsetof(skill)) | ||
| Children-(name, Birthday) | ||
| Birthday=(day, month, year) | ||
| Skills=(type, Examset,setof(exams)) | ||
| Exams=(year, city). | ||
| b) | What is difference between Persistent and Transient objects? How persistence is | 10 |
| handled in typical Object - oriented system. | ||
4. a) | Explain with proper example nested relation in ORDBMS. | 10 |
| b) | Write short note on Mobile databases. | 10 |
5. a) | Explain data fragmentation, replication and allocation technique for distributed | 10 |
| database design. | ||
| b) | Consider the following database for a chain of bookstores. | |
| Books (Booknum, Primary-author, Topic, Total-stock, Price) | ||
| Bookstore (Storenum, City, State, Zip, Inventory-value) | ||
| Stock (Storenum, Booknum, Qty) | ||
| indicate a star schema that could be used for building a data warehouse. | 10 | |
6. a) | Explain with suitable example Aggregation, Specialization and Generalization in | 10 |
| EER diagrams. | ||
| b) | Explain with suitable example object identity, Object structure and type | 10 |
| constructors in case OODBs. | ||
7. | Write short note on any two. | 20 |
| a) Transient Object,Subclass and superclass. | ||
| b) Temporal database | ||
| c) Web databases. |
No comments:
Post a Comment