<=Back
<=KNEC Diploma in Secretarial Studies Module II: Information Communication Technology II theory past paper November 2022
Jeff intends to design a database for a company and has identified the entities customers and products.
(i)State four attributes that could be assigned to the entity customers.(4 marks)
(ii)Identify the most appropriate attribute to assign the primary key to the entity named customers.(2 marks)
(iii) State two reasons for creating a relationship between the customers and products entities in the database.(2 marks)
(i)State four attributes that could be assigned to the entity customers.(4 marks)
(ii)Identify the most appropriate attribute to assign the primary key to the entity named customers.(2 marks)
(iii) State two reasons for creating a relationship between the customers and products entities in the database.(2 marks)
Viewed: 157 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. Define each of the following terms as used in desktop publishing applications: I) Kerning (II) Tracking. (2 marks)
2. Alice used the Arrange command feature when designing a publication using a desktop publishing program. Outline four options she could have used.(4 marks)
3. The following fields were used in database table: Production Date, Product Name, Product Cost and Product Photo State the most appropriate data type for each field. (2 marks)
4. Outline two ways of securing data in a database. (4 marks)
5. Kalulu, the book-keeper of Tajiri Merchants, has given you the following information as at 31.12.2018
6. Mustafa Hardware has several shops and would like to keep track of the operations of the shops. Describe two types of memorandum/day books that Mustafa Hardware could use in the shops
7. With the aid of a diagram in each case, describe each of the following database models. (i)hierarchical; (ii)relational. (6 marks)
8. Describe four examples of text effects that could be used in desktop publishing program.(4 marks)
9. The following are examples of desktop programs used in desktop publishing programs: PageMaker, Corel draw, Ms Publisher, Photoshop, Ventura, Harvard: Classify them as either text based or graphic based(3 marks)
10. State four advantages of maintaining accounting records of a business using financial application software. (4 marks)
11. The following transactions involve Kabiri Restaurant. March 3 Paid rent by cash Ksh28,000. March 6 Paid Ksh40,000 of the cash of the firm into a bank account. Record the transactions in the relevant ledger accounts. (3 marks)
12. Jeff intends to design a database for a company and has identified the entities customers and products. (i)State four attributes that could be assigned to the entity customers.(4 marks) (ii)Identify the most appropriate attribute to assign the primary key to the entity named customers.(2 marks) (iii) State two reasons for creating a relationship between the customers and products entities in th
13. Makamu Wholesale Traders have been using a financial application program to record financial transactions. Describe four major subheadings that could appear in the income statement report extracted using the program. (4 marks)
14. Explain the function of each of the following features in a desktop publishing programs: (i)bookmark;(4 marks) (ii)hyperlink.
15. Differentiate between trade discount and cash discount in accounting (4 marks)
1. Define each of the following terms as used in desktop publishing applications: I) Kerning (II) Tracking. (2 marks)
2. Alice used the Arrange command feature when designing a publication using a desktop publishing program. Outline four options she could have used.(4 marks)
3. The following fields were used in database table: Production Date, Product Name, Product Cost and Product Photo State the most appropriate data type for each field. (2 marks)
4. Outline two ways of securing data in a database. (4 marks)
5. Kalulu, the book-keeper of Tajiri Merchants, has given you the following information as at 31.12.2018
6. Mustafa Hardware has several shops and would like to keep track of the operations of the shops. Describe two types of memorandum/day books that Mustafa Hardware could use in the shops
7. With the aid of a diagram in each case, describe each of the following database models. (i)hierarchical; (ii)relational. (6 marks)
8. Describe four examples of text effects that could be used in desktop publishing program.(4 marks)
9. The following are examples of desktop programs used in desktop publishing programs: PageMaker, Corel draw, Ms Publisher, Photoshop, Ventura, Harvard: Classify them as either text based or graphic based(3 marks)
10. State four advantages of maintaining accounting records of a business using financial application software. (4 marks)
11. The following transactions involve Kabiri Restaurant. March 3 Paid rent by cash Ksh28,000. March 6 Paid Ksh40,000 of the cash of the firm into a bank account. Record the transactions in the relevant ledger accounts. (3 marks)
12. Jeff intends to design a database for a company and has identified the entities customers and products. (i)State four attributes that could be assigned to the entity customers.(4 marks) (ii)Identify the most appropriate attribute to assign the primary key to the entity named customers.(2 marks) (iii) State two reasons for creating a relationship between the customers and products entities in th
13. Makamu Wholesale Traders have been using a financial application program to record financial transactions. Describe four major subheadings that could appear in the income statement report extracted using the program. (4 marks)
14. Explain the function of each of the following features in a desktop publishing programs: (i)bookmark;(4 marks) (ii)hyperlink.
15. Differentiate between trade discount and cash discount in accounting (4 marks)