BT0066, Database Management Systems

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

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 :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

(Prefer mailing. Call in emergency )