BT0066, Database Management Systems

Published on November 2016 | Categories: Documents | Downloads: 29 | Comments: 0 | Views: 272
of 4
Download PDF   Embed   Report

Comments

Content


Dear students get fully solved assignments
Send your semester & Specialization name to our mail id :

[email protected]
or
Call us at : 08263069601
(Prefer mailing. Call in emergency )




ASSIGNMENT
PROGRAM BSc IT
SEMESTER 1
SUBJECT CODE & NAME
BT0066, Database Management Systems
CREDIT 4
BK ID
MAX.MARKS 60

Note: Answer all questions. Kindly note that answers for 10 marks questions should be approximately
of 400 words. Each question is followed by evaluation scheme.

Q. 1 Explain the concept of data independence and explain why it is required?
Answer: - Data independence:- Data independence is the type of data transparency that matters for a
centralized DBMS. It refers to the immunity of user applications to make changes in the definition and
organization of data.
Physical data independence deals with hiding the details of the storage structure from user applications.
The application should not be involved with these issues, since there is no difference in the operation
carried out against the data. The data

Q.2 Why relational data model is important? Explain the terms relation and tuple.
Answer:- Important of Relational data model:- The relational model for database management is a
database model based on first-order predicate logic, first formulated and proposed in 1969 by Edgar F.
Code. In the relational model of a database, all data is represented in terms of tuples, grouped into
relations. A database organized in terms of the relational model is a relational database.
Diagram of an example database according to the




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 |

Answer:- CREATE TABLE table name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),
....
);
 The column name parameters specify the names of the columns of the table.
 The data type parameter specifies



2. Based on the customer table given above update the salary to 20000 whose salary is less than that.
Based on the customer table given above Fetch ID,
Answer: - record:-
A record, also called a row of data, is each individual entry that exists in a table. For example there are 7
records in the above CUSTOMERS table. Following is a single row of data or record in the CUSTOMERS
table:


3. Name and Salary fields from the CUSTOMERS table for a customer with name Hardik.
Answer:-OriginalTable:-


CUSTOMERS table for a customer with name Hardik:-

Q.4 Consider the

Q.5What do you mean by anamoly in database system? Why it is required? Explain the types of
anamolies in database system.
Answer:- Anamoly in database system:- Database anomalies, are really just unmatched or missing
information caused by limitations or flaws within a given database. Databases are designed to collect
data and sort or present it in specific ways to the end user. Entering or deleting information be it an
update or a new record can cause issues if the database is limited or has ‘bugs’. Modification anomalies
or Update anomalies are data inconsistencies

Q.6 Differentiate between Relational Database Management System And Object Oriented Database
Management System.
Answer:- RDBMS vs OODBMS
An Object-Oriented Database Management System (OODBMS), sometimes referred as Object Database
Management System (ODMS) is a Database Management System (DBMS) that supports modeling and
creation of data as objects. OODBMS provides support for object classes, class property and method
inheritance by sub classes and their objects. A Relational Database Management System (RDBMS) is also
a DBMS but, that is based on the relational model. Most popular DBMSs currently in use are RDMSs.
As mentioned earlier RDBMS is based on
Dear students get fully solved assignments
Send your semester & Specialization name to our mail id :

[email protected]
or
Call us at : 08263069601
(Prefer mailing. Call in emergency )


Sponsor Documents

Or use your account on DocShare.tips

Hide

Forgot your password?

Or register your new account on DocShare.tips

Hide

Lost your password? Please enter your email address. You will receive a link to create a new password.

Back to log-in

Close