Dear students get fully solved
assignments
Send your semester &
Specialization name to our mail id :
help.mbaassignments@gmail.com
or
call us at : 08263069601
PROGRAM
Bachelor of Science in Information
Technology - B.SC(IT)
SEMESTER
III
SUBJECT CODE & NAME
BIT304 – Data Base Management System
Qus:1 What are the properties of
database?
Answer: The database is a collection of
related data. In a file system, the fundamental component of a file is a data item, which is the smallest named
unit of data that has meaning in the real world – for example, last name, first
name, street address, ID number, or political party. A group of
Qus:2 Write a note on hierarchal
model.
Answer: The hierarchical data model
organizes data in a tree structure. There is a hierarchy of parent and
Qus:3 Discuss
select statement with example.
Answer: The select statement specifies the
method of selecting the tuples of the relations(s). The tuples processed are
from one or more relations specified by the form clause of the select
statement. The basic form of
Qus:4 What are the different
function of database management system?
Answer: There are several functions that a
DBMS performs to ensure data integrity and consistency of data in the database.
The ten functions in the DBMS are: data dictionary management, data storage
management, data transformation and presentation, security management,
multiuser access control, backup and recovery management, data integrity
management,
Qus:5 Discuss
briefly relative data model.
Answer:
The relational model today, is the
primary data model for commercial data processing 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
Qus:6 What
are subqueries? Explain with example.
Answer: The expression following WHERE can
be either a simple predicate as explained above or it can be a query itself!
This part of the query following WHERE is called a Subquery.
A subquery, which
Dear students get fully solved
assignments
Send your semester & Specialization
name to our mail id :
help.mbaassignments@gmail.com
or
call us at : 08263069601
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.