Customer ID 1 2 3 4 5 6 7 8 9 10 Items of transaction {A,B,E,D} {A,C,D,E} {D,E,A} {E,B,A,C} {B,B,E} {A,E,B} {E,D,E,C} {D,C} {B,D,E} {C,D,E,A} (a)  Use the table shown to compute the support for the itemsets {B,D} and {B,C,E}. (b)  Use the results in part (a) to compute the confidence for the association rules {b,d} {e} (c) How many itemsets can be generated from these items (d) How many association rules can be generated from the itemset {A,B,C,D,E,F}?

System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…

An online retailer stores information about the items purchased made by its customers. Each day the following information is summarized and stored in a publicly available database. • The date each item was purchased • The 5-digit product code of each item purchased • The prices in dollars at which the items were purchased • The number of purchases made of each item at each price A sample portion of the database is shown below. Date Product Code Purchase Price Number of purchases 21/05/2017 16342 23.95 7 21/05/2017 18442 23.95 7 21/05/2017 22345 5.88 22 21/05/2017 20964 32.14 10 22/05/2017 16342 24.45 22/05/2017 14224 42.99 1 Which of the following CANNOT be determined using only the information in the database? The number of purchases made by an individual customer O The average cost of an individual item purchase on the site. How many times a certain product was purchased in a given month. O The product code of the most-purchased item on the site in a given year.

What would be the worst case and best case time complexity for the selection algorithm, respectively? O 0(1), O(N^2) O(N^2), 0(1) O 0(1), 0(1) O(N^2), O(N^2) O None of the choices