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
DRIVE
SPRING
2017
PROGRAM
Master
of Science in Information Technology(MSc IT)
SEMESTER
2
SUBJECT
CODE & NAME
MIT207–
Data Base Management System(DBMS)
Assignment
Set - 1
1 Describe various types of
attribute with reference to E-R model with suitable example.
Answer: The entity-relationship (E-R) data
model based on a perception of real world that consists of a set of basic
objects called entities, and of relationships among these objects. It was
developed to facilitate database design by allowing the specification of an
enterprise schema, which represents the overall logical structure of a
database. The E-R data model is one of several semantic data models;
2 Define database manager.
List and explain the important responsibilities of database manager.
Answer: A database manager is a program module
which provides the interface between the low level data stored in the database
and the application programs and queries submitted to the system. It is
responsible for interfacing with file system. One of the functions of database
manager is to convert user's queries coming directly via the query processor or
indirectly via an application program from the user's logical view to the
physical file system. In addition, the tasks of enforcing constraints to
maintain the
3 What is catalog? What
information is stored in the system catalogs?
Answer: A fundamental property of a database
system is that it maintains a description of all the data that it contains. A
relational DBMS maintains information about every relation and index that it
contains. The DBMS also maintains information about views, for which no tuples
are stored explicitly; rather, a definition of the
Assignment
Set - 2
1 What is meant by Embedded
SQL statement? Explain briefly.
Answer: All SQL statements that are embedded
within a host program must be clearly marked, with the details dependent on the
host language; in C, SQL statements must be pre-fixed by EXEC SQL. An SQL
statement can essentially appear in any place in the host language program,
where a host language statement
2 Mention and explain the
basic operations of Relational algebra.
Answer: Union
(È)
If we assume that P and Q are two
union-compatible relations, then the union of P and Q is set-theoretic union of
P and Q.
The resultant relation, R = P U Q, has
tuples drawn from P and Q such that
R = { t |Î P v t Î
Q }
The result relation
3 Describe the advantages
and disadvantages of data distribution.
Answer: Advantages
of Data Distribution
Data sharing and
Distributed Control: If
a number of different sites are connected to each other, then a user at one site
may be able to access data that is available at another site. For example, in
the distributed banking system, it is possible for a user in one branch to
access data in another branch. Without
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
No comments:
Post a Comment