BIT304 – Data Base Management System


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.