Get fully solved assignment, plz drop a mail with your sub code
computeroperator4@gmail.com
Charges rs
125/subject and rs 700/semester only.
our website is www.smuassignment.in
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
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 subsystem, the MySQL engine operates at a level of abstraction away
from the operating system.
Q3
List and explain the important responsibilities of database manager.
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 needed. A database manager is a program
module which provides the interface
Q
no 4 Explain the Sequential File Organization with the help of diagrams.
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 – require that operand relations be union compatible. Two
relations are union compatible if they
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
Get fully solved assignment, plz drop a mail with your sub code
computeroperator4@gmail.com
Charges rs
125/subject and rs 700/semester only.
our website is www.smuassignment.in
if urgent then call us
on 08791490301, 08273413412
No comments:
Post a Comment