Explanation of Solution
a.
Create an Access
The table Order_Data contains the following columns: Order_Number, ItemName, Quantity with the respective data types Number (LongInteger), Shorttext(50) and Number(LongInteger)...
Explanation of Solution
b.
Import the data from excel file ch09Ex02_U10e.xlsx into the Order_Data table:
The excel file ch09Ex02 contains attributes Order_Number, ItemName, and Quantity as attributes...
Explanation of Solution
c.
Run the query to perform market basket analysis:
The query is:
SELECTT1.ItemName as FirstItem,
T2.ItemName as SecondItem
FROMOrder_Data T1, Order_Data T2
WHERET1.OrderNumber = T2.OrderNumber
ANDT1.ItemName <> T2.ItemName;
In order to run the query, one need to click the red exclamation point in the toolbar and the query is saved under the name TwoItemBasket...
Explanation of Solution
d.
Enter another SQL Statement by clicking CREATE/Query Design:
The query is:
SELECTTwoItemBasket.FirstItem,
TwoItemBasket.SecondItem,
Count(*)AS SupportCount
FROMTwoItemBasket
GROUP BYTwoItemBasket.FirstItem,
TwoItemBasket.SecondItem;
First click on CREATE/ Query Design and when the Show Table dialog box appeared one needs to click close. One needs to select SQL View by right clicking in the gray section over the grid in window and enter the SQL statement...
Explanation of Solution
e.
By examining the two queries, verify whether the two query statements have correctly calculated the number of times the two items have appeared together.
Here the first query provides list of items bought together and the second query provides count of two items purchased together. Hence, second query can be used as a base to develop another query which in turn will provide more insight for order analysis...
Explanation of Solution
f.
Explain calculations one need to make to compute Lift:
- Lift is the probability of purchasing item A based on the base probability that item B is pur...
Explanation of Solution
g.
Explain the role of query in part C and part D:
- A table that consists of every pair of items in an order is created by the Query in part C...
Want to see the full answer?
Check out a sample textbook solution
- Write a short paper (1 page/about 500 words) summarizing what we as System Admins can do to protect the CIA of our servers. Outline the overall steps for configuring and securing Linux servers Consider and describe how a mixed Operating System environment will affect what you have to do to protect the company assets Describe at least three technologies that will help to protect CIA of data on Linux systems Required Resourcesarrow_forwardusing r language Estimate the MSE of the level k trimmed means for random samples of size 20 generated from a standard Cauchy distribution. (The target parameter θis the center or median; the expected value does not exist.) Summarize the estimates of MSE in a table for k= 1,2,...,9arrow_forwardusing r language Estimate the MSE of the level k trimmed means for random samples of size 20 generated from a standard Cauchy distribution. (The target parameter θis the center or median; the expected value does not exist.) Summarize the estimates of MSE in a table for k= 1,2,...,9arrow_forward
- using r language The data law82 in bootstrap library contains LSAT and GPA for 82 law schools. Compute a 95% bootstrap t confidence interval estimates for the correlation statisticsarrow_forwardusing r language The data law82 in bootstrap library contains LSAT and GPA for 82 law schools. Compute a 95% bootstrap t confidence interval estimates for the correlation statisticsarrow_forwardusing r langauge The data law82 in bootstrap library contains LSAT and GPA for 82 law schools. Compute and compare the three 95% bootstrap confidence interval estimates for the correlation statistics.arrow_forward
- What is the number of derangements of size k from the set {1,2,...n} to the set {1,2,...n} so that f(x) != x exactly k times with 1 <= k <= narrow_forwardTrace a State Space Tree introduced in the Chapter 5.1 using algorithms depth_first_search (page 205), checknode (page 207), and expand (page 210). Assume that State Space Tree is a two-level full binary tree (root is level 0). Node #2 (according to notation used in the Figure 5.1, page 204) is non-promising. Count the number of steps performed by each of those three algorithms. Consider execution of instructions like "visit node" or execution of "promising function" as one step, "write a solution" as an exit call. Note: no need to print or a draw a whole tree. Just provide three numbers as an answerarrow_forwardParking Tickets Table St ID L_Name ☐ F_Name Phone_No St_Lic Lic_No Ticket# Date Code Fine 38249 38249 82453 Green 82453 Green 82453 Green Brown Thomas 111-7804 FL BRY 123 15634 10/17/06 2 $25 Brown Thomas 111-7804 FL BRY 123 16017 11/13/06 1 $15 Sally 391-1689 AL TRE 141 14987 10/05/06 3 $100 Sally 391-1689 AL Sally 391-1689 AL TRE 141 TRE 141 16293 11/18/06 1 $15 17892 12/13/06 2 $25 The functional dependencies are: St_ID → L_Name, F_Name, Phone_No, St_Lic, Lic_No St_Lic → Lic_No Code → Fine St_ID, Ticket # → Date 1. In what normal form is the relation?| 2. Convert PARKING TICKET to a set of 3NF relations.arrow_forward
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education