Get fully solved assignment, plz drop a mail with your sub code
computeroperator4@gmail.com
Charges for mba rs 125/subject and rs 700/semester only.
For other rs 125/subject 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
Q.1: Explain the
concept of data independence and explain why it is required?
ANS:
Data independence is usually
considered from two points of view:
Physical data independence and Logical data independence.
Physical dataindependence allows
changes in the physical storage devices ororganization of the files to be made
without requiring changes in the conceptual view or any of the external views
and hence in the application programs using the database. Thus, the files may
migrate from one type of physical media to another or the file structure may
Q2.
Draw and explain the diagram of SQL server 2000 architecture.
Answer.
Microsoft® SQL Server™
2000 is a family of products that meet the data storage requirements of the
largest data processing systems and commercial Web sites, yet at the same time
can provide easy-to-use data storage services to an individual or small business
below is the SQL Server Architecture diagram.
3.
What do you mean by indexed sequential file organization? Explain with the help
of an example. 7+3
Answer.
Sequential File Organization
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
4.
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 fundamental property of a
database system is that it maintains a description of all the data that it
5.
What do you mean by semantics of TRC queries? Give an example of TRC queries. 5+5
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
variable T assigned the tuple value t. To complete this
definition, we must state which assignments of tuple values to the free
variables in a formula make the formula evaluate to true. A query is
Q6.
Explain BCNF with an example.
Answer.
Boyce–Codd normal form (or BCNF or 3.5NF) is a normal form used
in database
normalization. It is a slightly stronger version
of the third normal form (3NF). BCNF was developed in 1974 by Raymond F. Boyce and Edgar F. Codd to address certain types of anomaly
not dealt with by 3NF as originally defined.[1]
If a relational schema is in BCNF then all redundancy based
on functional
dependency has been removed, although other types of redundancy may
still exist. A relational schema Ris in Boyce–Codd normal form
Get fully solved assignment, plz drop a mail with your sub code
computeroperator4@gmail.com
Charges for mba rs 125/subject and rs 700/semester only.
For other rs 125/subject only
if urgent then call us
on 08791490301, 08273413412
No comments:
Post a Comment