After you accomplish all the above tasks, save the database. Upload it to Canvas by 11:59 pm, Monday (Nov. 12th). Download WPC.accdb from Blackboard. Open the database and examine relationships between the four tables first. DEPARTMENT (DepartmentName, BudgetCode, OfficeNumber, Phone) EMPLOYEE (EmployeeNumber, FirstName, LastName, Department, Phone, Email) PROJECT (ProjectID, Name, Department, MaxHours, StartDate, EndDate) ASSIGNMENT (ProjectID, EmployeeNumber, HoursWorked) Recently WPC has decided to keep track of computers used by the employees.In order to do this, two new tables will be added to the database.The schema for these tables as related to the existing EMPLOYEE table is: EMPLOYEE (EmployeeNumber, FirstName, LastName, Department, Phone, Email) COMPUTER (SerialNumber, Make, Model, ProcessorType, ProcessorSpeed, MainMemory, DiskSize) COMPUTER_ASSIGNMENT (SerialNumber, EmployeeNumber, DateAssigned, DateReassigned) The referential integrity constraints are: SerialNumber in COMPUTER_ASSIGNMENT must exist in SerialNumber in COMPUTER EmployeeNumber in COMPUTER_ASSIGNMENT must exist in EmployeeNumber in EMPLOYEE EmployeeNumber is a surrogate key and never changes.Employee records are never deleted from the database.SerialNumber is not a surrogate key since it is not generated by the database.However, a computer’s SerialNumber never changes, and, therefore, there is no need to cascade updates.When a computer is at its end of life, the record in COMPUTER for that computer and all associated records in COMPUTER_ASSIGNMENT are deleted from the database. Run SQL statements in Access to obtain your results for the following questions.For each SQL statement you write, save it as XXXQueryname (You need to name each query as appropriate.) in WPC.accdb. If necessary, you need to manually modify the database to add data requirements and constraints not supported by Access SQL. Figure 1 shows the column characteristics for the WPC COMPUTER table.Using the column characteristics, use Access SQL to create the COMPUTER table and its associated constraints in the WPC database.Are there any table characteristics that cannot be created in SQL?Use the Access GUI to finish setting table characteristics if necessary.The data for the COMPUTER table is in Figure 2.Use Access SQL to enter this data into your COMPUTER table. Save each query.Figure 3 shows the column characteristics for the WPC COMPUTER_ASSIGNMENT table.Using the column characteristics, use Access SQL to create the COMPUTER table and its associated constraints in the WPC database.Are there any table characteristics or relationship settings or characteristics that cannot be created in SQL?Use the Access GUI to finish setting table characteristics and relationship settings if necessary.The data for the COMPUTER_ASSIGNMENT table is in Figure 4.Use Access SQL to enter this data into your COMPUTER_ASSIGNMENT table. ****SEE ATTACHMENT FOR FULL INSTRUCTIONS*****

The purpose of this assignment is to perform association rules analysis to determine whether or not the information generated can be used to address a specific business problem.For this assignment, you will use the "Bakery" data set from the Topic Materials. Most data categories are self-explanatory. Clarifying notes are as follows.ReceiptID: Unique receipt ID (note that all items with the same receipt ID were purchased together)Item: Name of the food item that was purchasedA bakery is interested in increasing sales by optimally displaying and arranging its various baked goods and drinks. The bakery would like to know which items are typically purchased together so it can place the correlated items closer together in its display cases. The bakery has randomly selected 1,000 receipts and compiled a list of items that were purchased together for each receipt.As an analyst, you have been asked to examine the data, summarize your findings, and recommend how the bakery can use these findings to strategically arrange its bakery products to increase sales. Use associative rules analysis to explore the various dependencies among purchased items. Use the Apriori method to do the analysis with a minimum antecedent support of 4%, minimum confidence of 70%, and maximum number of antecedents of 5. Analyze and interpret several of the resulting rules. Present your finding in the form of a 250-word executive summary that includes relevant data, charts, and tables, and addresses the following.Question 1: How would you explain the concepts of support, confidence, and lift to an executive who is unfamiliar with association rules analysis? Include the Apriori method output chart when submitting the answer.Question 2: What would you say about the support of the rules derived from the Apriori analysis?Question 3: If both an apple tart and an apple Danish were purchased, how likely is it that an apple croissant is also purchased? Explain your answer.Question 4: Does it make sense for the bakery to place all of its apple-flavored items together in the display or is it better to spread them out in the display? Explain why.Question 5: If the bakery wanted to increase the sales of cherry soda, what cross-promotional offers could it employ? Explain why.General Requirements:Submit the executive summary as Word document.APA format is not required, but solid academic writing is expected.