Database System MS Computer Science/MSc Computer Science/PhD Computer Science 3 Semester/Term Islamia University Bhawalpur (IUB) 2014

The Islamia University of Bahawalpur, Pakistan

DEPARTMENT OF COMPUTER SCIENCE & IT

IUB Affiliated Colleges

Class: MCS (3" Semester) Final Term

Subject: Database Systems

Time: 100 Minutes

Name: Nudrat Batool

Selanipk

Session: 2014-16

Code: CSIT 31104

Total Marks: 45

Roll. No. 200k

usta

Q#2 Short Questions. Each question contains three marks (Marks 7x3=21)

1. What is the difference between database and database management system?

2. What is difference between conceptual and physical database design?

3. What is entity integrity constraint?

4. What is referential integrity constraint?

5. Define the relational algebra and relational calculus?

7. Describe data integrity?

Long Questions. Solve any three questions

Q#3 What is normalization and describe 2ºd and 3rd normal form of database. (8 Marks)

Q#4 Draw the E-R model of college Admission system. (8 Marks)

OHS Define the followings terms. (8 Marks)

Super key, candidate key, cardinality, degree.?

O#6 Following the Given student relation and normalize it in 3CNF. (8 Marks) pK

STD (stId, stName, stadr, stogpa, prName, prCrdts) usta

stAd=student Address

prCredits=ProgramCredits

pIName= ProgramName

GOOD LUCK

visit website: ustani.pk