BBA Database Management System

Define Database Language.

Who is DBA? List the roles of DBA.

Explain any four types of Database user.

Define Data Model.

Why level of abstraction is maintained in database?

What are the types of database user? Explain each of them in brief.

Identify and explain different types of database languages with example.

What is unary Relationship?

List any four types of attributes in ER Model.

Define Roles.

Illustrate how composite attribute is reduced into relational schema with example?

Explain constraints of generalization and specialization in ER model.

Draw an ER diagram for Hospital management system with at least five entity set. Implement the concept of mapping cardinality and extended ER feature. Assume suitable attribute sets for each entity set.

Differentiate between simple composite attribute.

List the types of mapping constraints in ER Model.

When generalization and specialization is used in ER model? Support your answer with example.

Employee works on the project under one or more project manager for the company. Client pays for the project that is being developed by the company and client provide the feedback for the project.

Draw ER diagram for the above scenario.

Write a SQL statement for update operation.

What is importance of creating view?

Discuss any four constraints available in database with example.

Consider following relational database:

Car (reg_no, model, price, color)

Person (pid, name, address, phone)

owns_by(reg_no, pid, date)

Write SQL statement for the following:
i) Insert a tuple {1, Ram Bdr, kathmandu} in person relation.

ii) Display the model number with highest price.

iii) Increase the price of each car by 15%.

iv) Find name of person who owns red colored car.v) Display those records of car which model contains at most 4 characters.

Write SQL statement to delete student table.

Write a syntax for check constraint SQL.

Explain the importance of Creating view with syntax.

Explain any five aggregate function used in SQL with syntax.

Consider following relational database:

Account(ac_no, type, balance, branch)
Customer(cid, name, address, phone_no, dob)
Depositer(ac_no, cid, date)

Write SQL statement for the following:
i) Insert a tuple {1001, checking, 30000} in Account relation.
ii) Delete those accounts which haven't owns any customer.
iii) Change the phone_no of Ram to 11111111.
iv) Find name of customer who owns an account with balance greater than 2000.
v) Display those records of customers whose name starts with "R" and end with "A".

State 3NF.

How normalization helps to design good database? Explain second normal form with example.

State 1NF.

What is importance of normalization? Explain with example.

Define serializable schedule.

Explain the concept of Time stamp ordering concurrency control techniques.

Explain the Desirable Properties of Transaction.

Define Transaction.

Describe two phase locking mechanism in brief.

Explain the desirable properties of Transactions.

Define deferred data update.

Describe shadow paging concept in brief.

Explain briefly the importance and methods of Database recovery.

What is big data?

What is the importance of database security?

What is NoSQL?

Define big data.

What is Database security? How Database is secured? Explain in brief.