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 only.
if urgent then call us
on 08791490301, 08273413412
[winter 2015 ] 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 =
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
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
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
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
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:
Software
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.
The attributes of a
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 only.
if urgent then call us
on 08791490301, 08273413412
No comments:
Post a Comment