Scribd
Upload
50 views2 pages

ADBMS Assignment1

This document outlines an assignment for the Advanced Database Management System course at Matoshri College of Engineering and Research Centre. It includes course outcomes related to relational and object-oriented databases, as well as various topics on distributed and parallel database architectures. The assignment consists of multiple questions divided into two parts, focusing on theoretical concepts and practical applications in database management.

Uploaded by

Minakshi Gite
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
50 views2 pages

ADBMS Assignment1

This document outlines an assignment for the Advanced Database Management System course at Matoshri College of Engineering and Research Centre. It includes course outcomes related to relational and object-oriented databases, as well as various topics on distributed and parallel database architectures. The assignment consists of multiple questions divided into two parts, focusing on theoretical concepts and practical applications in database management.

Uploaded by

Minakshi Gite
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Matoshri Education Society’s

Matoshri College of Engineering and Research Centre Nashik

Department of Information Technology


Assignment 1
Course :Advanced Database Management System A.Y 2023-24
Code : 314445(B) Semester : V

………………………………………………………………………………………………………………………………………….…
Course Outcomes (CO):
CO1: To understand the fundamental concepts of Relational and Object-oriented databases.
CO2: To learn and understand various Parallel and Distributed Database Architectures and
Applications
……….……………………………………………………………………………………………………………………………………
1 2 3 4 5 6

Q. Statement of Question Unit Bloom’s CO PI


No No. Level
1 to 6

PART A

1 What is Relational Data Model? Explain relational model 1 L1 CO1


constraints in detail.

2 Explain relational database schema in detail 1 L2 CO1

3 Explain different type of anamolies. 1 L2 CO1

4 Explain basic properties of OOP.(OR Describe features of 1 L2 CO1


Object oriented databases)

5 Differentiate between data abstraction and 1 L2 CO1


encapsulation

6 Explain the concept of polymorphism in detail. 1 L2 CO1

7 Write short notes on 1 L1 CO1


a. Object Identity
b. Object Structure
c. Type Constructor
8 What is Abstract data types? 1 L1 CO1

9 Differentiate between OODBMS and RDBMS. 1 L2 CO1

10 Write short notes on 1 L1 CO1


d. Class hierarchies and inheritance
e. Polymorphism

PART B

1 Explain architecture of distributed database. 2 L2 CO2

2 Explain distributed concurrency control and recovery in 2 L2 CO2


detail.

3 Explain distributed catalog management. 2 L2 CO2

4 What are the main architecture of used for building 2 L2 CO2


parallel databases? Give advantages and disadvantages.

5 Explain Query evaluation process in parallel databases. 2 L2 CO2

6 Explain architecture of parallel database. 2 L2 CO2

7 Explain storing data in DDBMS. 2 L2 CO2

8 Explain interquery and intraqury parallelism. 2 L2 CO2

9 Explain various system parameters of parallel databases. 2 L2 CO2

10 Describe the steps used to perform JOINS in a parallel 2 L2 CO2


Database.

Bloom’s level of question-- Remember: 1, Understand: 2, Apply: 3, Analysis: 4, Evaluate:


5, Create: 6

You might also like