Database Concepts Examination - Sarhad University, Peshawar printable pdf download

Database Concepts Examination - Sarhad University, Peshawar

Name: _________________________________________, Roll No. __________________

Sarhad University, Peshawar

(Distance Education)

Subject

: Database Concepts

Examination: Final, Spring 2013

Time Allowed: 03 Hours

Total Marks: 80

NOTE: Question No. 1 is compulsory. Attempt four questions from the rest. All questions carry equal marks.

Mobile phones and other electronic gadgets are not allowed.

Q 1)

Fill in the blanks:

1. An _____________ is a characteristic of an entity type that is of interest to the organization.

2. SQL is an acronym of _______________.

3. A primary key that consist of more than one attribute is called a __________ key.

4. An _________ is a logical representation of the data in an organization.

5. A relation that has no partial functional dependencies is in __________ normal form.

6. A relation that has no multivalued attributes is in ___________ normal form.

7. A relation that has no transitive dependencies is in __________ normal form.

Q2. Define concurrency. List and describe the techniques used to control concurrency.

Q3. Explain different data models used in logical database design.

Q4. What is normalization? Discuss 1

, 2

, 3

, and 4

normal form in detail with the help of examples.

Q5. Explain design and implementation phases of the database development life-cycle?

Q6. Briefly explain the following concepts:

a) Manual system

b) File processing systems

c) Database systems

Q7. Write short notes on any TWO of the following

1. ERD

2. Crash Recovery

Types of databases

Database Concepts - Spring 2013 -

Page 1 of 1

Database Concepts Examination - Sarhad University, Peshawar