DCA6111 RELATIONAL DATABASE MANAGEMENT SYSTEM

Description

SESSION	Jan-Feb 2026
PROGRAM	MASTER OF COMPUTER APPLICATIONS (MCA)
SEMESTER	I
COURSE CODE & NAME	DCA6111 RELATIONAL DATABASE MANAGEMENT SYSTEM

 

Assignment Set – 1

 

 

Q.1. Describe the major classes of parallel machines and their relevance in parallel database systems. (10 Marks)

Ans 1.

Parallel machines are computing architectures which make use of multiple processors to accomplish tasks in parallel, thus increasing performance and throughput. In database systems, parallelism is used to speed up query processing, data loading or sorting as well as transaction management. Parallel databases spread data and computation across multiple processors, allowing them to process large amounts of data effectively. Three primary classes of parallel machine designs exist:

Its Half solved only

Buy Complete from our online store

 

https://smuassignment.in/online-store/

 

MUJ Fully solved assignment available for session Jan-Feb 2026.

 

Lowest price guarantee with quality.

Charges INR 198 only per assignment. For more information you can get via mail or Whats app also

Mail id is aapkieducation@gmail.com

 

Our website www.smuassignment.in

After mail, we will reply you instant or maximum

1 hour.

Otherwise you can also contact on our

whatsapp no 8791490301.

 

 

 

Q.2. How does the Eddy architecture contribute to reducing query response time in large-scale distributed systems? (10 Marks)

Ans 2.

Traditional systems for processing queries employ an executed plan that is fixed and determined by a query optimizer prior to the execution starts. This static approach works well for data that is accurate and conditions in the system remain stable. In large-scale distributed systems, conditions such as data skew network latency, server load, and data arrival rates vary dynamically as queries are executed. The Eddy architecture is an adaptive query processing system designed to address these issues

 

Q.3. Explain the concept of normalization in DBMS and its importance. Discuss each normal form (1NF to 5NF) with examples. (10 Marks)

Ans 3.

Normalization is a method to organize a relational database in order to minimize redundantness and increase data integrity. It involves separating huge table structures that have poor structure into more compact, well-organized tables and connecting them through foreign keys. It is the goal of storing all data pieces in a single location, to avoid update, insert and deletion errors. Normalization is founded

 

Assignment Set – 2

 

Q.4. Write short notes on the following: (a) Starburst (b) Oracle (c) DB2 (10 Marks)

Ans 4.

Starburst

Starburst is a relational extensible database developed by IBM’s Almaden Research Center in the latter part of the 1980s. It was designed as a test bed for researchers to explore new directions in the database design and allow the engine to be highly flexible. Its most significant contribution is a query rewriting based on rules system where transformation rules called”rewrite” rules translate SQL queries into more efficient internal representations. These rules are able to be added or modified without

 

Q.5. Explain the concept of database recovery management. Discuss the different levels of backup techniques used for recovering data. (10 Marks)

Ans 5.

The database recovery management process can be described as the process of restoring an existing database to a proper and consistent state after an event of failure. It can be caused by computer crashes, power failures as well as software issues humans’ mistakes or disk corruption. A system for managing databases must make sure that transactions committed to the system are always preserved and complete transactions do not leave any partial results in the database. Recovery management

 

Q.6. Discuss the concept of data fragmentation in distributed databases. Explain its types in detail. (10 Marks)

Ans 6.

A distributed database stores data across multiple computers connected by networks. Data fragmentation refers to the process that divides a relation into smaller parts called fragments that are kept at various sites within the distributed database. Fragmentation allows the system to store data at the location where it is most often accessed, to process queries locally, without having to transfer entire tables across the network. It also helps enhance availability by storing independent copies of the same data at multiple sites as well as support parallel processing in which the different sites deal with