Khyber Pakhtunkhwa Board of Technical Education Peshawar Diploma in Information Technology (Part -II) 1st Term Examination 2020 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.
Q1. Briefly explain Database models. Q2. a) Differentiate data and information.
b) Define the following terms.
i. Database ii. Meta data iii. Data dictionary
Q3. (a) Define “relationship” and explain various types of relations with examples and diagrams.
(b) What is attribute Explain its types.
Q4. What is constraint? Explain Not Null, primary key and unique key constraints. Q5. Explain following terms.
i. Referential integrity ii. Anomalies and its types iii. Strong and weak entity iv. Composite key
Q6. a) What is ERD? Explain with the help of example.
b) What do you know by degree of relationship? Explain.
Q7. a) What clause is used to sort table data in descending order? Explain with example.
b) Differentiate “Commit” and “Roll back” statement.
Q8. Write short note on any two of the following.
a) Simple and complex view b) Role and privilege c) Round and truncate function
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!
Asif Khan
I am Student of DIT
Md. U
Thanks for contacting us. How we can help you?