DCA6111 RELATIONAL DATABASE MANAGEMENT SYSTEM JAN FEB 2026

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

MUJ

Its Half solved only

Buy Complete assignment from us

Price – 190/  assignment

MUJ Manipal University Complete SolvedAssignments  JAN- FEB  2026

buy cheap assignment help online from us easily

we are here to help you with the best and cheap help

Contact No – 8791514139 (WhatsApp)

OR

Mail us-  [email protected]

Our website – https://muj.assignmentsupport.in/

JAN-FEB 2026

 

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

 

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 upon functional relationships between elements and was described

 

 

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

 

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.

 

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