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 BCA (Revised Fall 2012)
SEMESTER 3
SUBJECT CODE & NAME-BCA3020 – 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. This means that if you port to a different operating
system that uses a different storage
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 between the low level data stored in the database
and the application programs and queries submitted to the system. It is
responsible for interfacing with file system.
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 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
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 and
one-to-one correspondence of the attributes with the corresponding
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 of the columns (not part of the business model) of its
corresponding table in the database.
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