Database System MS Computer Science/MSc Computer Science/PhD Computer Science

University of sargodha

RS 30 Term Examination 3024

Paper: Database systems MI 202)

Shict: Computer Science

Time Alone HOUT

Maximum Marks: 10

Objective Part

(Compulsory)

0.1. Write short answers of the following in 2-3 lines of esch on your answer sheet

What is Data Warehouse!

What is detahase manapement system.

What is dals independice!

What is composite identitor

Nian is degrce of relationship?

Write down the limitations of hierarchical and network model

vili

What a dale dillonaly

(2 8)

ustadni.com

0.5.

(3*8)

Lapiis be functises of cach of the fellening SOL keywords wring simple SOL sumes for a sincl

Comet the following table int

a HAVING

wallarahim williesamele

Jrd nonnal fom.

Vat Date

resisted

dINNER JOIN

0) IN

b) GROUP

1)

D LIKE

#-ICONDO

All

32 M Model 12.022007

Town talen

Dr. ZAHU

Chest infectice

Eyes intestion

13-007

p-200145

Paid

9-Jall Road

Dr Linget

Dr.Ktreshi

Hon Tre

Cough

Draw BE-R model of the tollowing

A person may be employed by

of moce ef pintatices, and eith orginizatica may be the employer of

ane er mote persons. An organization can be an internal organizational unit er an external organization

Foe perces and organization, we want to know Deir ID, same, oStress, and phone number. Foe perses.

we wint to know their birth date, and for organizatices, we want to know their bodest number. For catt

ployment, we want to know the employment dute, scemination dase, and boeus. Employment of i

persce by an organizatice may result in the persos belding many positions over time. For each positice

he want to know its title, and each time someone holds that postion, we need to kiw the star dave t

emination date and salary. An onganization is responsible for cochi postlion. it is possibie for a person u

employed by one organization and hold a position for whith another organization is respearible.

Write SOL commands for each of the following quone»

Half Hits.

see fees, type, country nandone, bor, diglacement

Ships (same, class, launched)

Battles iname. date)

d) Outcomes (ship, battle. result)

aì Find the mamher of battleship classes

b) Find the marace marmber of puns of balties cases.

e) Find the average of guns of buttleships. Note the dillerence between

(D) and

(e) Usladni.com

do we weight a class by the number of ships of that class of not!

) tend for cach class the year in which the first ship of that class was launched.

c) Find for sach class the number of shins of that class sunk in battle