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
PROGRAM-
BSc IT
SEMESTER-
FIRST
SUBJECT
CODE & NAME- BT0066, Database Management Systems
CREDIT-3
BK
ID- B0950
MAX.
MARKS- 60
Q1.
Explain entity and attributes in E-R diagram. Explain the importance of E-R
diagram. 6, 4
Answer:
Entity and attributes in E-R diagram :
1. Entity: An entity is a thing that exists and
is distinguishable.
a)
Entity instance. An instance is a particular
occurrence of an entity. For example, each person is an instance of an entity
Person, each car is an
Q2.
Why relational data model is important? Explain the terms relation and tuple.
10
Answer:
Relational Model: The relational model is today the
primary data model for commercial dataprocessing applications. It has
attained its primary position because of its simplicity, which eases the
job of the programmer, as compared to earlier data models such as the
network model or the hierarchical model. A database based on the
relational model
Q3.
What is the system catalog in RDBMS? Also explain what information is stored in
the system catalog. 5+5
Answer.
System Catalog In A Relational
DBMS
We can store a relation using one
of several alternative file structures, and we can create one or more indexes
each stored as a file on every relation. Conversely, in a relational DBMS,
every file contains either the tuples in a relation or the entries in an index.
The collection of files corresponding to users' relations and indexes
represents the data in the database. A
Q4.
Explain semantics of TRC queries with examples.
Answer.
Semantics of TRC Queries
What does a TRC query mean? More
precisely, what is the set of answer tuples for a given TRC query? The answer
to a TRC query { T | p(T) }, as we noted earlier, is the set of all
tuples t for which the formula p(T) evaluates to true with
Q5.
Explain data fragmentation with an example. 10
Answer:
Data Fragmentation: If the relation r if fragmented,
r is divided into a number of fragments r1,
r2......,rn. These fragments
contain sufficient information to reconstruct the original relation r. As we
shall see, this reconstruction can take place through the application of either
the union operation or a special type of join operation on the various
fragments. There are two different schemes for fragmenting a relation:
horizontal fragmentation and vertical
Q6.
Describe the approaches for incorporating object orientation capabilities in
databases.
Answer:
Approaches for incorporating object orientation capabilities in databases: There are at least six approaches
for incorporating object orientation capabilities in databases :
1. Novel database data model/ data
language approach: The
most aggressive approach develops entirely new database management system with
object orientation capabilities. Most of the research projects in
object-oriented databases have pursued this approach. The
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