May 2, 2022

2019july_[tnc-pdf-viewer-iframe file=”https://knecnotes.co.ke/wp-content/uploads/2022/05/2019july_OCR.pdf” width=”100%” height=”800″ download=”false” print=”false” fullscreen=”true” share=”true” zoom=”true” open=”true” pagenav=”true” logo=”true” find=”true” current_view=”true” rotate=”true” handtool=”true” doc_prop=”true” toggle_menu=”true” toggle_left=”true” scroll=”true” spread=”true” default_scroll=”0″ default_spread=”0″ language=”en-US” page=”” default_zoom=”auto” pagemode=”none” iframe_title=””]OCR

2017jul[tnc-pdf-viewer-iframe file=”https://knecnotes.co.ke/wp-content/uploads/2022/05/2017july_OCR.pdf” width=”100%” height=”800″ download=”false” print=”false” fullscreen=”true” share=”true” zoom=”true” open=”true” pagenav=”true” logo=”true” find=”true” current_view=”true” rotate=”true” handtool=”true” doc_prop=”true” toggle_menu=”true” toggle_left=”true” scroll=”true” spread=”true” default_scroll=”0″ default_spread=”0″ language=”en-US” page=”” default_zoom=”auto” pagemode=”none” iframe_title=””]y_OCR

2016nov_O[tnc-pdf-viewer-iframe file=”https://knecnotes.co.ke/wp-content/uploads/2022/05/2016nov_OCR.pdf” width=”100%” height=”800″ download=”false” print=”false” fullscreen=”true” share=”true” zoom=”true” open=”true” pagenav=”true” logo=”true” find=”true” current_view=”true” rotate=”true” handtool=”true” doc_prop=”true” toggle_menu=”true” toggle_left=”true” scroll=”true” spread=”true” default_scroll=”0″ default_spread=”0″ language=”en-US” page=”” default_zoom=”auto” pagemode=”none” iframe_title=””]CR

2015no[tnc-pdf-viewer-iframe file=”https://knecnotes.co.ke/wp-content/uploads/2022/05/2015nov_OCR.pdf” width=”100%” height=”800″ download=”false” print=”false” fullscreen=”true” share=”true” zoom=”true” open=”true” pagenav=”true” logo=”true” find=”true” current_view=”true” rotate=”true” handtool=”true” doc_prop=”true” toggle_menu=”true” toggle_left=”true” scroll=”true” spread=”true” default_scroll=”0″ default_spread=”0″ language=”en-US” page=”” default_zoom=”auto” pagemode=”none” iframe_title=””]v_OCR

2015jul[tnc-pdf-viewer-iframe file=”https://knecnotes.co.ke/wp-content/uploads/2022/05/2015july_OCR.pdf” width=”100%” height=”800″ download=”false” print=”false” fullscreen=”true” share=”true” zoom=”true” open=”true” pagenav=”true” logo=”true” find=”true” current_view=”true” rotate=”true” handtool=”true” doc_prop=”true” toggle_menu=”true” toggle_left=”true” scroll=”true” spread=”true” default_scroll=”0″ default_spread=”0″ language=”en-US” page=”” default_zoom=”auto” pagemode=”none” iframe_title=””]y_OCR

2014ju[tnc-pdf-viewer-iframe file=”https://knecnotes.co.ke/wp-content/uploads/2022/05/2014july_OCR.pdf” width=”100%” height=”800″ download=”false” print=”false” fullscreen=”true” share=”true” zoom=”true” open=”true” pagenav=”true” logo=”true” find=”true” current_view=”true” rotate=”true” handtool=”true” doc_prop=”true” toggle_menu=”true” toggle_left=”true” scroll=”true” spread=”true” default_scroll=”0″ default_spread=”0″ language=”en-US” page=”” default_zoom=”auto” pagemode=”none” iframe_title=””]ly_OCR

2013nov_O[tnc-pdf-viewer-iframe file=”https://knecnotes.co.ke/wp-content/uploads/2022/05/2013nov_OCR.pdf” width=”100%” height=”800″ download=”false” print=”false” fullscreen=”true” share=”true” zoom=”true” open=”true” pagenav=”true” logo=”true” find=”true” current_view=”true” rotate=”true” handtool=”true” doc_prop=”true” toggle_menu=”true” toggle_left=”true” scroll=”true” spread=”true” default_scroll=”0″ default_spread=”0″ language=”en-US” page=”” default_zoom=”auto” pagemode=”none” iframe_title=””]CR

Diploma in Human Resource Management Diploma in Human Resource Management July 2013 Diploma in Human Resource Management November 2013 Diploma in Human Resource Management July 2014 Diploma in Human Resource Management July 2015 Diploma in Human Resource Management Nov 2015 Diploma in Human Resource Management Nov 2016 Diploma in Human Resource Management July 2017 Diploma in Human Resource Management July 2019

2013july[tnc-pdf-viewer-iframe file=”https://knecnotes.co.ke/wp-content/uploads/2022/03/2013july_OCR-4.pdf” width=”100%” height=”800″ download=”false” print=”false” fullscreen=”false” share=”true” zoom=”true” open=”true” pagenav=”true” logo=”true” find=”true” current_view=”true” rotate=”true” handtool=”true” doc_prop=”true” toggle_menu=”true” toggle_left=”true” scroll=”true” spread=”true” default_scroll=”0″ default_spread=”0″ language=”en-US” page=”” default_zoom=”auto” pagemode=”none” iframe_title=””]_OCR

UNIVERSITY EXAMINATIONS: 2016/2017 EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY BIT2104 DATABASE DESIGN AND DEVELOPMENT FULL TIME/PART TIME/DISTANCE LEARNING SPECIAL/SUPPLEMENTARY EXAMINATION DATE: JULY, 2017 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE a) Define the following terms i) Entity integrity (2Marks) ii) Referential integrity (2 Marks) iii) Database schema (2 Marks) iv) Normalization (2 Marks) b) Explain the following i) Data manipulation language (2 Marks) ii) Data Control Language (2 Marks) iii) Data Definition Language (2 Marks) c) Describe the types of update anomalies that may occur on a table that has redundant data. (4 Marks) d) i) Describe the purpose of a design methodology. (2 Marks) ii) What factors can be used to measure efficiency? (6 Marks) e) Explain what is meant by a DDBMS, and discuss the motivation in providing such a system. (4 Marks) QUESTION TWO a) Explain the following database architectures i) Single database ii) Replicated database iii) partitioned database iv) cloud based database (8 Marks) b) Draw an entity relationship diagram for the following scenario. A student can take only one course at a time. A lecturer can teach many students. A course must belong to a faculty. A lecturer can belong to only one department though can teach in several faculties. Identify the suitable attributes in each entity type. (12 Marks) QUESTION THREE a) What is the purpose of open database connectivity (ODBC) (2 Marks) b) A employee table has the following fields empno, empname, dateofbirth, deptcode, basicsalary. You are required to write the SQL command for i) Add a new field marital status (2 Marks) ii) Add a new record with a sample record (3 Marks) iii) List records of employees with salary range between 50,000 and 100,000 (3 Marks) iv) List the employees in descending order of their empno (2 Marks) c) State a necessary and sufficient condition for a table to be in the Third Normal Form ( 2 Marks) d) List the disadvantages of distributed databases (6 Marks) QUESTION FOUR A combined medical and herbal centre wants to create a database to keep track of its medics, patients, herbal medicine, and herbal prescriptions. For simplicity, both a herbal medic and a patient will be recorded for his or her name, a herbal medicine will be recorded for its name, unit and the price per unit, and a prescription will be recorded for its date, the patient and medic, and all the herbs included in the prescription. a) For the conceptual database design phase, design your database in terms of an EntityRelationship (ER) diagram. This ER diagram should include explicitly the primary keys, the participation multiplicities for the relationship type/s. State the additional assumptions, if any, that are crucial to the design in your final ER diagram. (4 Marks) b) For the logical database design phase, map the final ER diagram into the global relation diagram. Indicate all the primary keys, foreign keys, multiplicity constraints, as well as at least the crucial attributes. (Here “crucial” is in regard to the database design, not necessarily to the needs of business information.) (3 Marks) c) Write an SQL script (of statements) that generates at least 2 tables for your designed database in above with proper primary keys and foreign keys if any. At least one of these TWO tables should contain a foreign key that is related to at least one of the tables you created via SQL here. (2 Marks) QUESTION FIVE a) Explain why it is necessary to select the target DBMS before beginning the physical database design phase. (4 Marks) b) Discuss the two main activities associated with application design. (2 Marks) c) Describe the potential benefits of developing a prototype database system. (3Marks) d) Discuss the main activities associated with the implementation stage. (3 Marks) e) Describe the purpose of creating a mission statement and mission objectives for the required database during the database planning stage. (2 Marks) f) Discuss what a user view represents when designing a database system. (2 Marks) g) Compare and contrast the centralized approach and view integration approach to managing the design of a database system with multiple user views. (4 Marks)

UNIVERSITY EXAMINATIONS: 2016/2017 ORDINARY EXAMINATION FOR THE DEGREES OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY /BACHELOR OF BUSINESS IN INFORMATION TECHNOLOGY BIT2103 BBIT200 PRINCIPLES OF ARTIFICIAL INTELLIGENCE FULLTIME/PART TIME/DISTANCE LEARNING DATE: AUGUST, 2017 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE (a) Briefly explain the meaning of the following concepts with reference to artificial intelligence i) Artificial intelligence (2 Marks) ii) Intelligent agents (2 Marks) (b) Distinguish between Intrapersonal and interpersonal intelligence. State potential careers and techniques used for improving each intelligence (4 Marks) (c) Write whether each statement is true (T) or false (F), and provide a short explanation: ( i) Both breadth-first and depth first search are inefficient (2 Marks) (ii) Uniform-cost search is optimal (2 Marks) (iii) Greedy search is complete (2 Marks) (d) Briefly explain three applications of artificial intelligence techniques (3 Marks) (e) Consider the following knowledgebase of a certain family father_of (peter, fred) . father_of (peter, tom). father_of (james,david). gender (tom, male) student (tom, KCAU). (f) Formulate predicate- logic queries that can be typed in Prolog to find the following knowledge (i) a list of all the fathers (2 Marks) (ii) all the children of peter. (2 Marks) (iii) Confirm the existence of a kcau student known as tom (2 Marks) (g) Briefly describe two categories of artificial intelligence tasks. Give one example for each case. (4 Marks) (h) Given that p is true and q is false, construct a truth table that shows the truth value for the following expression: (2 Marks) (i) Define the term ‘expert system’ (1 Mark) QUESTION TWO a) Briefly explain the meaning of the following concepts. Give one example of potential career for each case (i) Linguistic Intelligence (2 Marks) (ii) Spacial intelligence (2 Marks) (iii) Bodily kinesthetic intelligence (2 Marks) d) Consider the following propositions Cat is mammal, mammal is an animal, cat has fur, and bear has fur (i) Construct Semantic Network (4 Marks) (ii) Convert the semantic network constructed in (3d) into predicate logic (2 Marks) (e) Explain four limitations of expert systems in the context of artificial intelligence (4 Marks) (f).Explain two elements that can be used to represent uncertainty in fuzzy logic reasoning Give one example for each element. (4 Marks) QUESTION THREE (a) Briefly explain the meaning of the following terms ( i) Robot (2 Marks) (ii) Intelligent agent (2 Marks) (iii) Agent environment (2 Marks) (b) Describe any two applications of a robot in the industry (2 Marks) (c) State and explain three types of mobile robots (3 Marks) (d) Briefly explain four characteristics of a robot (4 Marks) (e) State and explain five parts of a robot (5 Marks) QUESTION FOUR (a)Describe the meaning of the following terms in the context of artificial intelligence (i) Inferencing (2 Marks) (ii) Solution (2 Marks) (iii) Firing of a rule (2 Marks) (iv) Heuritics (2 Marks) (b) State and explain four inferencing methods (4 Marks) (c) Describe four characteristics of a good knowledge representation technique (4 Marks) (d) If Z croaks and eats flies – Then Z is a frog. If Z fly – Then Z it is a bird. If Z is a frog – Then Z is green If Z is a canary – Then Z is yellow Suppose you have a pet that croaks and eats flies. Use forward chain to determine the colour of the pet? (4 Marks) QUESTION FIVE (a) Briefly describe the meaning of the term ‘search problem’ (2 Marks) (b).State and explain five elements of defining search problem. (5 Marks) (c). Describe three characteristics of un informed searching methods. (3 Marks) (d). Consider the search tree shown Figure below. (i)Use depth first search algorithm to find a path from S to E. What is the path cost? (4 Marks) (ii) Use breadth first algorithm find a path from S to C. Specify the path cost (4 Marks) (e) . Consider the following figure Specify the state space represented in the above figure (2 Marks)

UNIVERSITY EXAMINATIONS: 2016/2017 EXAMINATION FOR THE DEGREES OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY/ APPLIED COMPUTING/ BUSINESS IT BIT2103 PRINCIPLES OF ARTIFICIAL INTELLIGENCE FULLTIME/ PART TIME/ DISTANCE LEARNING SUPPLEMENTARY/SPECIAL EXAMINATIONS DATE: JULY, 2017 TIME: 2 HOURS INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions. QUESTION ONE a) State and explain three types of human intelligences [3 Marks] b) Describe the meaning of the term “Artificial Intelligence” [2 Marks] c) Discuss five elements of a search problem in artificial intelligence. [5 Marks] d) State and explain any three knowledge representation techniques. [6 Marks] (iii) Select any one knowledge representation techniques discussed above in (ii) and discuss how it may be implemented. [3 Marks] e) Explain the meaning of the terms “inference”, “backward chaining” and “forward chaining” [3Marks]. (f) Explain any four applications examples of how artificial intelligence may be used in medicine and industry. [4 Marks] g) You are given an expert system with several rules pertaining to the behaviour of a certain animals If X croaks and eats flies – Then X is a frog. If X chirps and sings – Then X is a canary. If X is a frog – Then X is green If X is a canary – Then X is yellow i) Your pet croaks and eats flies. Use forward chain to determine the colour of the pet? [4 Marks] QUESTION TWO a) Describe two assumptions of knowledge representation. Use examples to explain your answer. (4 Marks) b) Describe four properties of a good knowledge representation technique (4 Marks) c) Construct Semantic Net work of the following scenario (4 Marks) Bird is an animal Bird has part wing Robin is a bird Robin is a rusty Robin is a red d) Explain any three differences between procedural and declarative knowledge (3 Marks) e) Translate the following rule into a frame (3 Marks) IF (hair) OR (drinks milk) THEN (mammal) f) Briefly explain the meaning of the term ‘ heuristics’ in the context of artificial intelligence (2 Marks) QUESTION THREE a) Briefly explain the meaning of the following concepts i) Fuzzy logic reasoning (2 Marks) ii) Case-based Reasoning (CBR) (2 Marks) iii) State space (2 Marks) b) Distinguish between deductive and inductive reasoning. Give an example for each case (4 Marks) c) State and explain any four characteristics of an intelligent agent (4 Marks) (d). Describe three un informed searching methods (3 Marks) (e).Briefly describe the meaning of the term ‘intelligent agent’. Give one example to illustrate your answer (3 Marks) QUESTION FOUR (a) Explain the meaning term ‘expert systems’ [2 Marks] (b) State and explain five components of an expert system. [5 Marks] (c) Describe any three benefits of expert systems in modern society. [3 Marks] (d) State and explain four participants of developing expert systems [4 Marks] (e) Describe any two limitations of expert systems [2 Marks] (f) Explain four differences between an Agents other software. [4 Marks] QUESTION FIVE (a) Intelligent agents interact with different types of environments. State and explain any four of these environments [4 Marks]. (b) Briefly describe three limitations of hill climbing method in the context of artificial intelligence [4 Marks] (c) Briefly explain any two applications of robots in modern society. [2 Marks] d) Describe the following intelligent tests in the context of artificial intelligence [4 Marks] i.Turing Test. ii.Chinese room. (e) Briefly explain four elements of an intelligent agent [4 Marks] (c) Describe the meaning of the term expert reasoning task as used in artificial intelligence [2 Marks]