5) Jones, Smith, and Clark hold the jobs of programmer,knowledge engineer, and manager (not necessarily in that order). Jones owes the programmer$10. The manager's spouse prohibits borrowing money. Smith is not married. Your task is tofigure out which person has which job.Represent the facts in prepositional logic. You should have nine propositional symbols torepresent the possible person/job assignments. Solve the problem by showing thatonly one of them is implied by KB, and by saying what its interpretation is.

17. The ___ represents facts and rules.Question 3Answera.None of theseb.Inference enginec.Knowledge based.Operating system

Task 1: Consider the following relational schema • Employee (EmpID, Name, Dob, Gender, Doj, Designation, Basic_pay, DNo); Gender must take value ‘M’ or ‘F’. • Dept (DNo, DName); • SkillSet (SkillNo, Description, Charge_Outrage); • EmpSkills (EmpID, SkillNo); • Project (PNo, PName, Start_Date, End_Date, Project_Manager_ID); Project Number must start with ‘P’. • Works (EmpID, PNo, Date_Worked_On, Intime, Outtime); Questions 1. Develop DDL to implement the above schema specifying appropriate data types for each attributes and enforcing primary key, check constraints and foreign key constraints. 2. Develop a SQL query to list the details of staff who earn the AVG basic pay of all staff. 3. Develop a SQL query to list the details of staff who have skills with a charge outrate greater than 60 per hour. 4. Develop a SQL query that will keep track of the department number, department name, the number of employees in the department and total basic pay expenditure for the department and store result in a temporary table. 5. Develop a SQL query to list the details of Depts which has more than 3 employees working in it. 6. Develop a SQL query to list the details of employees who have 2 or more skills but not more than 4

Verbal Ability 7 questions, 1 mark each Q 24. Determine if the statement given below is a fact, an inference, or a judgement. It is not like him to behave this rudely with anyone. Ops: A. Fact B. Judgement C. Inference Q 25. Determine if the statement given below is a fact, an inference, or a judgement. I get paid less than what my wife makes each month. Ops: A. Inference B. Fact C. Judgement Q 26. The sentences given below form a coherent passage when arranged logically. Choose the option which gives the correct sequence. 1. As a result, they started investing themselves more and more into the performance of their teams and the organisation. 2. Employees were beginning to see that the company was going to look after them, and they weren't in it alone. 3. As soon as the changes were implemented, line managers started reporting increased engagement in office meetings. 4. The results were for the world to see, with the first quarter after the changes seeing a whopping 20% increase from the numbers of that quarter last year. 5. The CEO's radical changes had paid rich dividends, and she had just proven that respecting the employees was not about increasing costs, but increased rewards. Ops: A. 5 4 1 2 3 B. 1 3 2 4 5 C. 3 2 1 4 5 D. 5 4 3 1 2 Q 27. The sentences given below form a coherent passage when arranged logically. Choose the option which gives the correct sequence. 1. Things were at an all time low when the new CEO was onboarded. 2. One would expect cuts to be made in employee benefits and expenses that are often regarded as superfluous. 3. At the outset, she began making some pretty radical changes. 4. But she instead increased salaries by 8%, added 2 sick leaves for everyone, and restarted Casual Fridays. 5. "The employees' trust needed to be won back", she said in an interview later. And win back trust she did. Ops: A. 5 4 1 2 3 B. 1 3 2 4 5 C. 5 4 3 1 2 D. 3 2 1 4 5 Q 28. Determine if the statement given below is a fact, an inference, or a judgement. It has been a pleasure working for you. Ops: A. Judgement B. Inference C. Fact Q 29. Determine if the statement given below is a fact, an inference, or a judgement. We'd have been late by an hour if we had remained stuck in traffic. Ops: A. Fact B. Inference C. Judgement Q 30. Determine if the statement given below is a fact, an inference, or a judgement. Stars are hot and dense clusters of gas. Ops: A. Fact B. Judgement C. Inference answer

A lawyer, a manager, a merchant, and a driver, all live in the same building. Their names are Marc, Ryan, Samuel, and Anthony, but not necessarily in that order.i. Marc and the driver are not friends with Peter.ii. Ryan and the merchant are friends.iii. Samuel and the lawyer live on the same floor.iv. The manager is a friend of Anthony and the merchant.What is the profession of Peter?radio_button_uncheckedLawyerradio_button_uncheckedManager radio_button_uncheckedMerchantradio_button_uncheckedDriver

Match the truth tables to its corresponding propositional logicAnswer 1 Question 13Answer 2 Question 13Answer 3 Question 13