Description

SESSION SEPTEMBER 2022
PROGRAM MASTER OF COMPUTER APPLICATIONS (MCA)
SEMESTER I
COURSE CODE & NAME DCA6104 – ADVANCED DATABASE MANAGEMENT
SYSTEM
Set – I
1. Explain various transaction operations in DBMS.
Ans: To prevent data from failure different backup methods are used. There are three
different levels of backup.
These are discussed as below:
 Full database backup: It considers a full backup of the database, or dump of the database.
 Differential backup: In case of differential backup, only the last variations that are
performed on the
Buy Complete assignment from us
Price – 190/ assignment
MUJ Manipal University Complete
SolvedAssignments session Jul/Aug 2022
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 – www.assignmentsupport.in
2. What do you mean by Normalization? What are the different normal forms? Explain
by giving suitable example.
Ans: The Normalisation Process Normalisation comprises of various set of rules which are
used to make sure that the database relations are fully normalised by listing the functional
dependencies and decomposing them into smaller, efficient tables.
Normalisation primarily helps to:
1. eliminate data maintenance anomalies
3. What are the various types of database management system? Briefly explain
Ans: Based on data model
For database Systems, various models are used based on data model:
 Hierarchical Model
 Network Model
 Relational Model
 Object-relational Model
Set – II
4. What are the three machine architectures upon which parallel DBMS run?
Ans: Parallel DBMSs architecture:-
Now we will briefly discuss the parallel DBMS architecture. There are mainly three machine
architectures available on which you can run parallel DBMSs so as to minimise the response
time and maximise the throughput.
These three architectures are discussed below:
5. Write short notes on
a) Video Database Management System
Ans: Video Database Management
The video database management system comprises of open source system. The video
database management system research group came up with the extensions and adaptations
that were required to support full functionality of the database.
The extensions
b) Temporal Databases
Ans: Temporal Database
Temporal databases are used to record time-referenced data. Basically
majority of the database technologies are temporal. For example:
 Record keeping function (inventory administration, medical-record and
personnel, )
 Financial function (banking, accounting and portfolio organisation)
6. (a) Differentiate between Homogeneous and Heterogeneous Distributed databases?
Ans: Homogeneous and Heterogeneous Database When the database technology is the same
at each of the locations and the data at the several locations are also compatible, that data is
known as homogenous
(b) What do you mean by validation-based Protocol in Concurrency Control?
Ans: Concurrency Control by Validation
Transactions can continue without locking. All database modifications are performed on a
local copy. We verify if the schedule for transaction is serialisable or not. If it is serialisable,
the local copy variations are affected to the global database. Or else, the local modifications
are not needed,