Database System BSSE 3 Semester/Term UOS — University of Sargodha 2016

University of Sargodha

Class: BSSE 3rd Date: 26-01-16

Subject: Data Base System Marks: 20 Time: 50 Mints

Paper: Subjective(+Prac.)

Q1. Differentiate between: [5 * 2 = 10]

1. Homogeneous vs heterogeneous database

2. Composite vs multivalued attributes

3. Entity integrity vs referential integrity

4. Two-tier architecture Vs Three tier architecture

5. Disjoint rule vs disjoint constraint

Q2. Short Answers [4 * 2 = 8]

1. An E-R model includes entities, attributes, and relationships. What each of these becomes when the

model is converted into a database.

2. List the types of Cardinality that may exist between two entities in E-R modeling

3. What is the objective of three schema architecture?

4. Write down top five parameters of file organization when selected for

a. Board of Intermediate SGD

b. HBL, Pakistan

Q3. [3+12=15]

The Little Hampton Air Company publishes a weekly flight log report, which tracks each aircraft and the

number of hours that were flown by an individual pilot in each aircraft. A separate report is prepared for

each pilot and is used to monitor flight proficiency for the two types of aircrafts (Fixed Wing and Rotary

Wing) which a pilot may be qualified to fly. The following business rules apply to this report. Pilots may

be assigned to fly different aircraft each day by the flight-scheduling manager. Each aircraft has a single

crew chief permanently assigned to perform maintenance on the aircraft, although a crew chief may crew

more than one aircraft. An aircraft number identifies each aircraft. There are several aircraft in the fleet. An

aircraft number is unique, independent of aircraft type. Pilots are identified by their flying-license-number

and crew chief by employee-id.

Additional information:

• All aircraft have seating-capacity data.

• Fixed wing aircraft have number-of-engine data and Rotary aircraft have speed-of-blade data.

(a) Identify the entities in this scenario.

(b) Draw an ER diagram of the entities to include their relationships and any attributes identified.

Q4. Consider the scenario implied by the following student report: [3+12=15]

STUDENT REPORT

Student

Student No : 0293-992

Name : John

Address : 123, kensington Road

Major

Major No Major Name

CS Computer Studies

BC Business Computing

Academic History

Unit Code Unit Description Exam Date Grade

CS12 Computer lvl1 14/2/2000 A

TT20 Technology 14/2/2000 D

(a) Construct a UNF relational model for the student report scenario.

(b) Using the normalization rules, normalize your model to 3NF. (Begin by indicating the

primary key and repeating groups.)