Database System MSCS 1 Semester/Term Islamia University Bhawalpur (IUB) 2017

The Islamia University of Bahawalpur

Course Code: - CSIT-21103

Program: - MCS

ustani.pk

Final (Subjective)

Marks:-40

ustani.pk

Course Title:- Database Systems

Term: - 1st

Q. No 2 Write short answers for the followings.

ustani.pk

Time: - 115 mins

3+ 3+3+3 +3+3+2 = 20

What is the purpose of LIKE operator?

What is a view? How it is related to data independence?

Ill.

IV.

VI.

Which normal forms rely on the definition of functional dependency?

Define an atomic transaction and explain why atomicity is important?

V. Define rollback and roll forward.

What is the purpose of NOT logical operator?

VIl. What is constraint?

Long Questions

7+6+7 = 20

Note: Answer only three questions from the following questions. Draw diagrams if necessary.

2. No 3 What is sub query: Bescribe the restrictions on sub queries.

Q. No 4 Explain the difference between an exclusive lock and shared locktani. ph

Q. No 5 Define second normal form. Give an example of a relation in 1NF but not in 2NF.Transform the

relation into relations in 2NF.

visit website: ustani.pk