BITM Database Management System

Define Database Management System.

Define the term Tuple Relational Calculus.

Write any example of multivalued attribute.

What do you mean by Growing phase?

Give an example of lossy decomposition.

Does Specialization increase the size of Schema? Give reason.

Why is store procedure used?

Define Big Data.

What is the use of Default keyword in SQL?

Write a syntax to create a view.

Explain different type of relationship with example.

What are the properties of Relational Decomposition? Explain.

Explain the Best practices of Naming Convention in Database management System.

Explain Read condition of time stamp ordering concurrency control.

Explain Right, left and Full Join with example.

How Database System can be made secure? Explain.

Explain the recovery process using NO-UNDO / REDO with an example.

Explain the benefits and significance of using a Relational Database system compared to a traditional file system.

Define Multivalued Dependency. Illustrate with example how a table can be Normalized using fourth normal form.

From the following relation

Student (ID, S_Name, Address, Gender, Age)

Write Relation Algebra

a. To find all rows where Age is less than 20

b. To list all the student

c. To list Name and gender of students

d. To list Name and Address of students whose gender is ‘M’ and age is greater than 30

Consider the given schema design for Department Store.

Customer (c_id, C_Name, address, gender, age, phone, email, created_date)

Product (pr_id, P_name, product_price, mfg_date, exp_date)

Purchase (id, c_id, pr_id, qunatity, total_price, entered_by, entered_at)

a. Find the name and price of product whose name start from 'K' and end in 'T'.

b. Find the name of customer who purchases ‘Pen’.

c. Insert the record of new customer.

d. Delete the product ‘Pen’

e. Increaser the price of all product by 25%

f. Write DDL statement for creating above relation

How strong entity, weak entity and relationship set is represented in table? Explain with example.