KNEC Diploma in ICT module 2 Database Management System past paper: November 2018 Answers

Answers for Database Management System past paper: November 2018

Course Name:  Information and Communication Technology
Also Done By:
na
Course Level:  Diploma
Sub Level:       Module II
Course Unit:   Database Management Systems
Exam body:    KNEC
Share with Friends:
        
Go Back



1. Outline four characteristics of a database management system ()
2. Explain the three schema architecture of a database management system ()
3. Outline two rules to data stored in database management system ()
4. A newly established manufacturing company intends to design a database from scratch. State four relational database language they could use ()
5. With the aid of appropriate symbol, explain each of the following components of an Entity Relationship Diagram(ERD). (i) entity (ii) relationship; (iii) Attribute. ()
6. Outline three duties of a database administrator ()
7. Explain each of the following types of database architectures (i) client server; (ii)Distributed. ()
8. With the aid of example in each case, distinguish between data definition language (DDL) and Data Manipulation language(DML). ()
9. During a database maintenance session, it was discovered that the data dictionary had malfunctioned. (i) Explain two functions of this data dictionary in a database (ii) State three components of this dictionary ()
10. Outline three properties of a relational table ()
11. A company intends to integrate its database management system. Explain three structural components that may be used ()
12. Differentiate between super key and candidate key as used in database management system ()
13. Describe the object oriented database model ()
14. An ICT Technician intends to perform database recovery procedure from the enterprise backup. State three types of backup that he may use in the recovery process ()
15. Define each of the following terms as used in Entity-Relationship Modelling (i) Specialization; (ii) Aggregation. ()
16. With the aid of an example in each case, distinguish between composite and derived attributes. ()
17. Explain each of the following terms as used in relational databases: (i) cardinality ratio (iii) Participation constraints. ()
18. The following narrative is a representation of information about banks. Use it to answer the questions that follows ()
19. (i) Identify four entities in the narrative ()
20. Draw an entity relationship Diagram to represent the information ()
21. Outline three characteristics of the 1NF ()
22. Explain each of the following types of anomalies in Normalization: (i) Update (iii) Deletion ()
23. Table 1 shows information contained in a database table. Use it to answer the questions that follow: ()
24. peter designed a database management system using a relational model. Outline three challenges that he may have encountered during the design ()
25. State three database schemas he may have used ()
26. Outline four trends in database technology ()
27. Explain the referential integrity rule ()
28. Peter has been tasked to design a database by following the database life cycle. Explain the conceptual modeling stage of this life cycle ()
29. Outline four advantages of the conceptual modeling stage ()
30. Outline two uses of database system in hotel industry ()
31. Distinguish between weak and strong entities ()
32. A database has been scheduled to run an automatic update on daily basis. Explain three types of integrity constraints that must be checked during update operation ()
Quick Links
Follow Us
facebook twitter LinkedIn
© 2026 Afritutor.com

All Rights Reserved