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 625/semester only.
if urgent then call us on 08791490301, 08273413412
[ Summer 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
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,
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
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
records.
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
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
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
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 625/semester only.
if urgent then call us on 08791490301, 08273413412
No comments:
Post a Comment