1. Week 5 – Data Management Project: Physical DesignThe final project requires a physical design of the database you have selected for your project (Car Rental MySQL Database. this assignment just builds on this project each week that you have submitted to me. i attached what you wrote week one, in case you need the previous weeks answer you submitted to me i can send you ) .This database should be normalized in 3rd normal form. Write the CREATE TABLE statements for all the entities in the database you have been designing. Make sure to include the primary keys and foreign keys, plus the data types for each attribute. In addition, write INSERT statements to input 10 rows of data into at least one of your tables. Please make sure your physical data model is included with the submission. 2. Week 5 – Data Management Research PaperYour research paper, based on the topic you selected in week 3 ( topic: Mining Social Media Data attached below). Submit a research paper regarding an aspect of data management. Use this website to help with APA formatting. Here is a sample paper in APA format.Requirements:The paper must concentrate on a topic chosen in week 3 ( Mining Social Media Data) . APA 6.0 format should be followed in regard to the completion of this paper. That means there must be a title page and a separate reference page. The paper must be double spaced using Times New Roman 12 pt. font. Not counting the title and reference pages, the body of the research paper should be 5 - 7 pages. A minimum of three references should be cited in the body of the paper and shown on the reference page. assignment will be graded according to Data Management Research Paper Rubric (attached below)Resources:Google Scholar

Complete the following assignment in one MS word document:Discuss the process that generates the power of AI and discuss the differences between machine learning and deep learning. In 2017, McKinsey & Company created a five-part video titled “Ask the AI Experts: What Advice Would You Give to Executives About AI?” View the video and summarize the advice given to the major issues discussed.Watch the McKinsey & Company video (3:06 min.) on today’s drivers of AI at youtube.com/ watch?v=yv0IG1D-OdU and identify the major AI drivers. Write a report. Explore the AI-related products and services of Nuance Inc. (nuance.com). Explore the Dragon voice recogni-tion product.(limit to one page of analysis for question 15)When submitting work, be sure to include an APA cover page and include at least two APA formatted references (and APA in-text citations) to support the work this week.All work must be original (not copied from any source).

Discuss the assumptions that must be made about the data in order to use the Wilcoxon. What is the rationale for the test statistics used in the Wilcoxon Signed-Rank test? Please make your initial post and two response posts substantive. A substantive post will do at least TWO of the following: Ask an interesting, thoughtful question pertaining to the topic Answer a question (in detail) posted by another student or the instructor Provide extensive additional information on the topic Explain, define, or analyze the topic in detail Share an applicable personal experience Respond to these 2 posts from my peers plz 1)Discuss the assumptions that must be made about the data in order to use the Wilcoxon. The Wilcoxon Sign Test requires two repeated measurements on a commensurate scale, that is, that the values of both observations can be compared. If the variable is interval or ratio scale, the differences between both samples need to be ordered and ranked before conducting the Wilcoxon sign test (Park, 2015). The Wilcoxon Sign test makes four important assumptions: 1. Dependent samples – the two samples need to be dependent observations of the cases. The Wilcoxon sign test assess for differences between a before and after measurement, while accounting for individual differences in the baseline. 2. Independence – The Wilcoxon sign test assumes independence, meaning that the paired observations are randomly and independently drawn. 3. Continuous dependent variable – Although the Wilcoxon signed rank test ranks the differences according to their size and is therefore a non-parametric test, it assumes that the measurements are continuous in theoretical nature. To account for the fact that in most cases the dependent variable is binominal distributed, a continuity correction is applied. 4. Ordinal level of measurement – The Wilcoxon sign test needs both dependent measurements to be at least of ordinal scale. This is necessary to ensure that the two values can be compared, and for each pair, it can be said if one value is greater, equal, or less than the other. What is the rationale for the test statistics used in the Wilcoxon Signed-Rank test? The Wilcoxon test is a nonparametric statistical test that compares two paired groups, and comes in two versions the Rank Sum test or the Signed Rank test. The goal of the test is to determine if two or more sets of pairs are different from one another in a statistically significant manner (Park, 2015). Reference: Park, H. I. (2015). A generalization of Wilcoxon rank sum test. Applied Mathematical Sciences, 9, 3155–3164. https://doi.org/10.12988/ams.2015.52129 2) Four important assumptions must be made about data to use the Wilcoxon Sign test; ordinal level of measurement, continuous dependent variable, independence, and dependent samples (Abid et al., 2018). In the dependent samples assumption, the Wilcoxon Sign test requires that the two samples are dependent on each other to evaluate variances amid before and after measurement while considering for particular variances in the reference line. The Wilcoxon Sign test presumes individuality in the independence assumption, denoting that the two observations are independently and randomly attained. In the continuous dependent variable assumption, the Wilcoxon sign test assumes that the measurements are continually theoretical to rank the variances concerning their size (Hayes, 2020). A continuity correlation is used to justify the detail that the dependent variable is distributed binomially in most scenarios. In the ordinal level of measurement assumption, the Wilcoxon Sign test presumes that the two dependent measures are at the slightest ordinal scale. The assumption is essential to certify that both values can be likened and that each pair can be said to be less or greater than the other. The Wilcoxon Signed-Rank test is a nonparametric statistical test, and it is used to test the null hypothesis that the continuous distribution of two populations is alike. The test fundamentally calculates the variance between pair sets and evaluates the variances to determine if they are statistically significantly diverse from each other. According to King & Eckersley (2019), the straightforward idea supporting the Wilcoxon signed-rank test is to create a null and alternate hypothesis, decide a confidence degree, compute the statistic test, and equate a critical value to the test statistic. If the determined test statistic is barely as much as the critical value, then the null hypothesis gets rejected. References Abid, M., Nazir, H. Z., Tahir, M., & Riaz, M. (2018). On designing a new cumulative sum, Wilcoxon signed-rank chart for monitoring process location. PLOS ONE, 13(4), e0195762. https://doi.org/10.1371/JOURNAL.PONE.0195762 Hayes, A. (2020, April 13). Wilcoxon Test Definition. https://www.investopedia.com/terms/w/wilcoxon-test... King, A., & Eckersley, R. (2019). Statistics for Biomedical Engineers and Scientists. In Statistics for Biomedical Engineers and Scientists. Elsevier. https://doi.org/10.1016/C2018-0-02241-0