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 500/semester only.
if urgent then call us on 08791490301, 08273413412
[Summer 2014 ] ASSIGNMENT
PROGRAM M.Sc IT
SEMESTER 2
SUBJECT CODE & NAME-MIT202– Data Base Management
System(DBMS)
CREDIT 4, BK ID B1479, MAX. MARKS 60
Q1
What are the applications of database system?
Answer:
A database application is a computer
program whose primary purpose is entering and retrieving information from a
computerized database. Early examples of database applications were accounting
systems and
Q2
Write the functions of the following (a) Storage Manager (b) Buffer
Manager 3+2
Answer
–
|
Storage manager
|
The Storage Manager: The Storage
Manager interfaces with the operating system (OS) to write data to the disk
efficiently. Because the storage functions reside in a separate subsystem, the
MySQL engine operates at a level of abstraction away from the operating system.
This means
Q3.
What are the important responsibilities of database manager? Explain
Answer
- Databases typically
require a large amount of storage space. Corporate databases are usually
measured in terms of gigabytes of data. Since the main memory of computers cannot
store this information, it is stored on disks. Data is moved between disk
storage and main
Q
no 4 Explain the Sequential File Organization.
Answer
- A sequential file is
designed for efficient processing of records in sorted order based on some
search-key. A search key is any attribute or set of attributes; it need not be
the primary key, or even a
Qno 5 Explain basic operations of Relational algebra?
Answer
- Basic operations are
the traditional set operations: union, difference, intersection and Cartesian
product. Three of these four basic operations- union, intersection, and
difference – require that operand relations be union compatible. Two relations
are union compatible if they have the same parity
Q6
What are the disadvantages of Data Distribution
Answer
- Disadvantages of Data
Distribution The primary disadvantage of distributed database systems is the
added complexity required to ensure proper coordination among the sites. This
increased
Answer
- As a result, VBSF supports two types of class-to-table
mappings that help overcome the differences between relational and object
models: SUBSET and SUPERSET.
SUBSET
Mapping: This type of
mapping is used when all the attributes of a persistent class are mapped
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 500/semester only.
if urgent then call us on 08791490301, 08273413412
No comments:
Post a Comment