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
[ Winter 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
Explain the functions of the following (a) Entities (b) Attributes (c)
Relationships 3+3+4
Answer
-
|
Entities
|
Entities are the principal data objects
about which information is to be collected; they usually denote a person,
place, thing, or event of informational interest. A particular occurrence of an
entity is called an entity instance or sometimes an entity occurrence. Consider
a Company
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
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
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
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 –
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 complexity takes the form of:
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 to the
same table. It is also used when a persistent class is not concerned with some
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