You can pay in 6 instalment of
Rs 125-125 if u have any doubt.
computeroperator4@gmail.com
www.smuassignment.in
www.assignmenthelpforall.blogspot.in
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
Q.2:
Why relational data model is important? Explain the terms relation and tuple.
ANS:
The relational model
is today 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
Q.3:
Perform the following DML operations on the table:
1.
Insert values for the table CUSTOMERS with fields – ID, name, age, address and
salary and insert records in the table given below:
+----+----------+-----+-----------+----------+
| ID |
NAME | AGE | ADDRESS | SALARY |
+----+----------+-----+-----------+----------+
| 1 |
Ramesh | 32 | Ahmedabad | 2000.00 |
| 2 |
Khilan | 25 | Delhi | 1500.00 |
| 3 |
kaushik | 23 | Kota | 2000.00 |
| 4 |
Chaitali | 25 | Mumbai | 6500.00 |
| 5 |
Hardik | 27 | Bhopal | 8500.00 |
| 6 |
Komal | 22 | MP | 4500.00 |
| 7 |
Muffy | 24 | Indore | 10000.00 |
+----+----------+-----+-----------+----------+
Solution:
There are two basic syntaxes of INSERT INTO
statement as follows:
INSERT INTO TABLE_NAME (column1,
column2, column3,...columnN)]
VALUES (value1, value2,
value3,...valueN);
Q.4:
Consider the relations
EMPLOYEE(emp#,
name)
ASSIGNED_TO(project#,
emp#)
PROJECT(project#,
project_name, chief)
Express
the following queries in Relational Algebra
(i)
Get details of employee working on both comp354 and comp345 project numbers.
(ii)Find
the employee number of employee who do not work on project comp678
ANS:
Solution:
Set table EMPLOYEE to E, and set table ASSIGNED_TO to A.
Q.5:
What do you mean by anamoly in database system? Why it is required? Explain the
types of anamolies in database system.
ANS:
The database is
a collection of related data. The basic component of a file in a file system 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 related
data items treated as a single unit by an application is called a record. Examples of types of records
are order, salesperson, customer,
Q.6:
Differentiate between Relational Database Management System And Object Oriented
Database Management System.
ANS:
RDBMSs were never
designed to allow for the nested structure. These types of applications are
extensively found in CAD/CAE, aerospace, etc. OODBM can easily support these
applications. Moreover, it is much easier and more natural to navigate through
these complex structures in the form
No comments:
Post a Comment