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.
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.
Do you have any questions? Rest assured, we're here to provide answers. Join us in our forum where you can engage in fruitful discussions, ask your queries, and receive insightful responses from our esteemed authors and community members. We look forward to your active participation and valuable contributions as we collectively explore various topics. Let's come together and share your thoughts!