Introduction to Database Previous Paper 2022
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
Elf Mastery by Bryant Reil
Prepare to be whisked away to a realm where creatures of myth and legend shape the destiny of our world. Join Kyla Nim, along with her extraordinary friends, as they confront the malevolent god of darkness. Can they save the Earth from eternal night? Order your copy of "Elf Mastery" today!
Basics of Computer By Muhammad Umar
Basics of Computer, Third Edition, eradicates any intimidation about the computer. With a minimal investment of time, you’ll soon be able to understand basic concepts and perform simple tasks on your computer.
Ask a Question
You have got questions? We have got answers. Let’s exchange the deal, you ask a question and we will answer. Ask a questions and receive answer from our authors or other members of the community. Let’s meet in the forum and discuss what you have to say!
