Introduction to Database Previous Paper 2022


0

Khyber Pakhtunkhwa Board of Technical & Commerce Education Peshawar
Diploma in Information Technology
(Part -II)
1st Term Examination 2022
Paper: Introduction to Database

Time allowed: 3 hours

Max marks: 100

Note: Attempt any five questions. All questions carry equal marks. Mobile phone & programmable calculators are not allowed.

 

Q.1: Explain different database models.

Q.2: Explain data, database and DBMS with examples.

Q.3: What is Association? Explain different types of Association in detail.

Q.4: Explain ERD and Discuss attributes in detail.

Q.5: Define SQL and discuss the following statements.

I) INSERT

II) UPDATE

III) DELETE

Q.6: Explain Normalization in detail.

Q.7: – Define Constraint. Discuss the following.

I) Foreign key constraint

II) UNIQUE Constraint

III) Check

Q.8: Explain the following functions with suitable examples.

I) Min

II) Max

III) AVG

IV) SUM

V) COUNT

Related Posts

Like, Share, and Follow Us!

Leave a Reply

Your email address will not be published.

Copyright © 2022 Basics of Computer