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
if urgent then
call us on 08791490301, 08273413412
[ Summer 2016 ] 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 database; here
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
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
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
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 increase
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
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
if urgent then
call us on 08791490301, 08273413412
No comments:
Post a Comment