Get fully solved assignment. Buy online from website
online store
or
plz drop a mail with your sub code
we will revert you within 2-3 hour or immediate
Charges rs
125/subject and rs 700/semester only.
if urgent then call us on 08791490301, 08273413412
DRIVE
Fall 2015
PROGRAM
MBADS (SEM 3/SEM 5)
- MBAFLEX/ MBA (SEM 3)
PGDISMN (SEM 1)
SUBJECT CODE &
NAME
MI0034 – DATABASE
MANAGEMENT SYSTEM
BK ID - B1966
CREDIT - 4
MARKS – 60
Q1. The data is
stored in the form of tables which can be retrieved efficiently by any program
as per the request. Since the database users are vast in number, the database
provides authentication. Explain the different types of database users.
(Listing atleast 4 different database users, Explaining them) 2, 8
Answer:
Types of Database Users:
Database Administrator (DBA)
Database Designers (DBD)
End users
System
analysts
Q2. Computer
storage is divided into primary memory and secondary memory. Discuss with an
example, the different types of primary memory and secondary memory. (Listing
the types of primary memory, Listing the types of secondary memory, Describing
the types of primary memory, Describing the types of secondary memory) 1, 1, 2,
6
Answer: The computer storage is divided
into mainly two types:
·
Primary
memory
·
Secondary
memory
Primary storage – It includes storage media that
can be operated directly by the computer central processing unit (CPU), such as
the computer main memory and smaller but faster cache memories.
Secondary
Q3. Consider any
one example of a relational database and show how the different operations of
relational algebra can be performed on the table showing the output. (Listing
the types and its subtypes, Explaining with an example) 3, 7
Answer:
Relational Algebra
The Relational Algebra was introduced by E. F.
Codd in 1972. It consists of a set of operations on relations:
- SELECT (σ):
extracts tuples from a relation that satisfy a given
restriction. Let R be a table that
contains an attribute A. σA=a(R)
= {t ∈ R ∣ t(A) = a} where t denotes a tuple
Q4.
Describe the different normal forms with one example throughout. (Listing the 5
important normal forms, Definitions for each of them, Explanation for each of
them using one example throughout) 2, 3, 5
Answer:
5 important normal forms: the
following types of Normal Forms.
·
First
Normal Form (1NF)
·
Second
Normal Form (2NF)
·
Third
Q5.
Write Short Notes on: 2, 2, 2, 2, 2
a. Transaction
Commit
b. Atomicity
c. Deferred update
d. Security
e. System log
Answer:
Transaction
commit - Transaction
commit is responsible for making all the data modifications permanent in the
database. When transaction commit occurs, the following are the observations:
·
A
commit record is made to indicate that the modifications are permanent, and
this is written to the log Depending upon the type of commit, the log
information in memory is simultaneously written
Q6. With an example
explain the working of ODBMS. (Explaining with an example) 10
Answer: How do ODBMSs work: Consider an example of Student_Courserelationship.
The entity STUDENT has got attributes std_id, std_name and std_address. The
following will be the table for STUDENT database.
Get fully solved assignment. Buy online from website
online store
or
plz drop a mail with your sub code
we will revert you within 2-3 hour or immediate
Charges rs
125/subject and rs 700/semester only.
if urgent then call us on 08791490301, 08273413412
No comments:
Post a Comment