21CS745
USN
Seventh Semester B.E. Degree Examination
NOSQL Database
TIME: 03 Hours Max. Marks: 100
Note: Answer any FIVE full questions, choosing at least ONE question from each MODULE.
Module -1 Taxonomy Marks
Level
Q.01 a What is NoSQL? Discuss and differentiate between the relational model L2 7
and the aggregate model.
b Which data model does not support aggregate orientation? Explain the model L2 6
with a suitable diagram.
c Define key-value stores and explain the differences between key-value L2 7
and document data models.
OR
Q.02 a Describe with an example how column family stores data in the aggregate L2 6
structure.
b Explain briefly how impedance mismatch occurs in the relational model, L2 7
and what are some common solutions to address it?
c What are materialized views, and how do they differ from relational views in L2 7
terms of data access? What strategies are used to build
materialized views?
Module-2
Q. 03 a Define Master-Slave replication. With a neat diagram, explain the L2 7
advantages and disadvantages of master-slave replication.
b
: User A L3 7
time.
For this example, how can different version stamping methods be applied to
track these updates, and what are the advantages and
disadvantages of each method?
c What is the CAP theorem? Explain the trade-offs between its three L2 6
properties in detail.
OR
Q.04 a Identify the type of conflict in the given scenario. How can it be solved? Alice
and Bob both try to book the last available room at the same time. Alice starts L3 7
filling in her details, but Bob completes his booking first.
When Alice submits her booking, it overwrites Bob's reservation, and the room
is booked for Alice instead.
b What is Sharding? With a neat diagram, explain the concept of sharding with L2 7
an example.
c Define Quorum. Explain how to read and write a quorum with examples. L2 6
Module-3
Q. 05 a Apply the Map-reduce process to compare the sales of products for each
month in 2011 to the prior year. Illustrate the process with suitable L3 10
diagrams.
b What are key-value stores and popular key-value databases? Discuss with an
example how data is organized within a single bucket and mention ways to L2 10
handle key conflicts.
OR
Q. 06 a Given the following sales data, use the MapReduce process to calculate
21CS745
the total sales for each product. Discuss in detail how the Map and
Reduce processes work to compute the total sales.
Data:
Customer_Id Product Quantity Price
1 Puerh 8 24
2 Dragonwell 12 24 L3 10
3 Genmaicha 20 80
4 Puerh 5 15
5 Dragonwell 16 48
b Explain the features of key-value stores. L2 10
Module-4
Q. 07 a What is a document database? Explain with an example how data is L2 7
stored in it and how it differs from an RDBMS.
b List and explain the suitable use cases for document databases. L2 5
c Explain the differences in query handling between MongoDB and
RDBMS with examples. L2 8
OR
Q. 08 a What is a replica set? How does replication work in MongoDB? What are L2 7
thealternatives to MongoDB?
b Briefly explain the scaling feature in document databases with a neat L2 8
diagram.
c Explain a few applications where document databases should not be L2 5
used.
Module-5
Q. 09 a What is a graph database? Explain how relationships and properties are L2 6
represented in a graph, with a neat diagram.
b Explain transaction, consistency and availability with respect to graph L2 6
databases.
c Describe the query features of graph databases in detail with examples. L2 8
OR
Q. 10 a Discuss the three scaling methods in graph databases with a clear L2 8
diagram.
b List and explain applications where graph databases are suitable and not L2 6
suitable.
c With an example graph structure, discuss how relationships are handled L2 6
in a graph database compared to an RDBMS
