Consider the following information and use it to answer the questions that follow; A customer owning account 801 is transferring Ksh. 139,500 from his account to an account 998 belonging to one of his business partners. The business partner (owner of account 998) is also trying to settle a debt of raw materials supplied by one of his suppliers by issuing a cheque of 150,000. Assume that cheques are debited (credited) immediately after being deposited. Assume the bank has a rule that minimum balances cannot go below zero.   What anomaly might have occurred above? Why so?

Q: Consider the schema of 2 tables below, and then answer the question about it. employee (ID,…

A: The answer is given below.

Q: A Company supplies a range of cosmetics products and gives discounts on orders as follows: For order…

A: A company supplies a rang of cosmetic products and gives discounts on order as follows: For order…

Q: In the University library every 5 minutes a student arrives arrives. The librarian takes 3 minutes…

A: Below is the required table and answers with calculation:

Q: Answer this question by considering the following credibility data used by a bar to decide whether…

A: Lets see the solution.

Q: Given the following transaction database: Transaction id Items t1 {1, 3, 4, 6} t2 {2, 3, 5}…

A: The, given Transaction id items: t1 {1, 3, 4, 6} t2 {2, 3, 5} t3 {1, 2, 3, 5} t4 {2, 5,} t5 {1, 2,…

Q: 4) You are asked to calculate the weekly take home pay for a group of employees at your company (for…

A: Solution  There is a table name employee  ID of employee= 87,43,99 ,5; Regular hours =40,40,32,40;…

Q: Consider the relation R with the following functional dependencies: R(P,Q, R, D, E, F) FD = {P >…

A: Given: Relation R with the following functional dependencies: R(P,Q, R, D, E, F) FD = {P > Q,QR →…

Q: Given that 163 of 710 transactions included {bread, peanut butter, jelly}, what is the support of IF…

A: Task : Find the support for given transactions and items.

Q: The follow questions refer to the transaction schedule below, that records bookings of tickets for a…

A: The, given information is: TIME ID TRANSACTION ID OPERATION 1 A Read Tickets left =…

Q: Consider the following database schema for student game, where each team is led by a student of the…

A: Primary key means only one unique value and null not allowed. No duplicate values stored. Foreign…

Q: 1 a -[ ] ab - [ ) s for i in (Data.head(200) and Data1.tail(200)): 16 if i[-2] not in a:…

A: Here, it is a syntax error. Since += can't be write with spaces. so, here you are writing it with…

Q: 2.Apply the Apriori algorithm to the following transactional data. The data has been obtained from a…

A: Apriori algorithm is used in finding frequent item sets using association rules. Frequent Itemset…

Q: Exercise 4.4 Consider the Supplier-Parts-Catalog schema from the previous ques- tion. State what the…

A: 1. Selects the sname from sid whose colour is red and the cost is less than 100 from the parts and…

Q: QUESTION 15 Al Watan supermarket has hire-purchases scheme for locals and expats. The customers will…

A: Given condition:  The customer must hold the present job for more than 5 years and reside in the…

Q: Damon Davis was finalizing the paperwork for Drano Plumbing. He projected a net profit of $50,000.…

A: Answ

Q: Given the grocery store transactions example with minimum support = 33.34% and minimum confidence =…

A:

Q: Suppose that Iris and Kelvin are involved in a romantic relationship, unknown to anyone else in the…

A: INTRODUCTION: Ethical decision-making refers to the process of evaluating and selecting among…

Q: Given the following transaction database: Sales ID Items S1 {O, W, C, N, Z} S2 {O, C, K, N, Z}…

A:

Q: Question 1 - Apriori Algorithm - Given the following transaction database: Transaction ide Itemse…

A: a) Given minimum support = 50%. Total number of items = 5 So, minimum support count = (number of…

Q: Given the following transaction dataset: Tid Items 10 А, С, D 20 В, С, D 30 А, В, С, D 40 В, D 50 А,…

A: Here given the transactions containing transaction id and items with minimum support i.e.,…

Q: Damon Davis was preparing the worksheet for Drano Plumbing Company. He calculated the net income to…

A: The unadjusted trial balance, adjustments, adjusted trial balance, and financial statements,…

Q: Assuming a database has 4 transactions in a supermarket as shown below. ID Date Product ID001 Oct 8,…

A:

Q: From the given set of functional dependencies,determine that there can be more than one canonical…

A: Functional dependency is a relationship that is shown between two or more attributes of a table.…

Q: 18. 15% of the product sold by the company is returned. The company decides to recycle them to avoid…

A: Data means the information that is useful for us Company data is information that offers insight…

Q: Consider 4 transactions T1, T2, T3, and T4 Transaction T1 has 5 transactions, T2 has 4 transactions,…

A: Scheduling where the operations of multiple transactions are interleaved. This might lead to a rise…

Q: An analyst investigating University Student course registration system has found the following rules…

A: Actually, given information is: All applications for course registrations received by the campus are…

Q: !Consider the following table Policy No. Agreement No. Work_Hours Worker_Name Restaurant_Number…

A: i provide the answer below

Q: Answer the following questions based on the transaction data of a sports shop shown in Table 5.…

A:

Q: 1. The bank account balances before the following transactions are: a=100, b=50, c=1000. bank…

A: Given are two transactions: Transfer of 40 from a to c and transfer of 30 from b to c. We will first…

Q: Q6. Given below figure, answer the following questions a. What is the purpose of time, in steps 1…

A: The question has been answered in step2

Q: Given the following transaction dataset: Tid Items 10 A, C, D 20 B, C, D 30 A, B, C, D 40…

A: Given : Transactions with their IDS Tid Items 10 A, C, D 20 B, C, D 30 A, B,…

Q: Q3 Consider the following table Policy No. Agreement No. Work_Hours Worker_Name Restaurant_Number…

A: ANSWER: The given table is present in UNF so make it normalized by creating the Primary key in the…

Q: Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which…

A: Each transaction is considered as one unit and either runs to completion or is not executed at all.

Q: Consider the following lock requests as given below. S1(A),S2(B),X3(A),X2(C),S1(B),S1(C),X2(B)…

A: Given lock requests are: S1(A), S2(B), X3(A), X2(C), S1(C), X2(B) S() represents shared lock and…

Q: Given the following case you are to answer the two questions on the following pages. Bob’s Supply…

A: Solution:  Given scenario has 3 tables, 2 tables for entities and one table for relationship.    All…

Q: Consider the relational database of Figure 3.20. Give an expression in SQL for each of the following…

A: Modify the database so that Jones now lives in Newtown Answer: update employee set city = 'Newtown'…

Q: Consider the following schedule of transactions W1(A) W2(A) W1(A) W2(A) W1(A) Which of the following…

A: Given schedule of transactions, W1(A) W2(A) W1(A) W2(A)  W1(A),  It contains two transactions. T1…

Q: Consider the following database and its schema and write relational algebra expression to retrieve:…

A: Doing with MySQL query

Q: Given the Table 1 below, find ALL frequent itemsets using Apriori ONLY. (Minimum support = 3 and…

A: The Apriori algorithm is defined as the algorithm which is used to generate associate rules and is…

Q: A transaction database contains ten transactions shown below and minimum_support = 30%. Using…

A: Given :-  Minimum support =30%   =  30100*10  (No of transaction) = 3.

Q: 13. Draw a DFA which accepts exactly one "ab". Σ= {a,b} Or, Draw a DFA which accepts exactly two…

A: A deterministic finite state automaton is a 5-tuple (Q, Σ, δ, q0, F) where Q denotes the finite set…

Q: we first have to differentiate between the information-transaction-service (ITS) front desk, and the…

A: Lets see the solution.

Q: Using MySQL, populate the CUST_LNAME, CUST_FNAME, and CUST_BALANCE fields with the following…

A: NOTE: - Since the CUSTOMER table complete detail is missing, hence a table is created using the…

Q: How many valid keys are in the following model? A Fully trusted entity Partially trusted entity B C…

A: Given:

Q: Write the SQL trigger for 5.7 in the back of Ch.5 ………………………..   Consider the bank database of Fig.…

A: EXPLANATION: The create trigger command is used to create a trigger with the specified name that…

Q: The first question: What is the value of the first and second accounting defendant for each of the…

A: I have provided 1's and 2's compliment for each of the number below. 1's compliment is nothing but…

Q: Draw the associations that are described by the following business rules. Include the multiplicities…

A: Doctor patient relationship model one to many