<=Back
<=KNEC Diploma in ICT module 2 Database Management System past paper: November 2018
Table 1 shows information contained in a database table. Use it to answer the questions that follow:
Normalize the table up to the second normal form (2NF).
Normalize the table up to the second normal form (2NF).
Viewed: 131 times
For Better experience and learning,for video answers, after video ends playing, click next question in the questions list!!!
Share in:
Questions List:
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
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