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
[Fall 2015 ] 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
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 that if
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 memory as
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 superkey. To permit fast retrieval of records in search-key
order, we chain together records by pointers. The pointer in each record points
to the next record in search-key order. Furthermore, to minimize the number of
block accesses in sequential file processing, we store
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
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
Answer
- As a result, VBSF supports two types of class-to-table
mappings that help overcome the
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