Part 1:Directions: Use the following information to complete the questions below. While APA format is not required for the body of this assignment, solid academic writing is expected, and documentatio

Part 1:Directions: Use the following information to complete the questions below. While APA format is not required for the body of this assignment, solid academic writing is expected, and documentatio
PRJ 2 – Database Design – 75 Points This deliverable appl ies database des ign patterns that we leaned in class ( transaction s and objects , categor y, and intersection tables ) in creat ing and query ing the data base schema for your process. The following 4 items are needed : 1. A data /relationship diagram showing tables, attributes, primary keys, and foreign key relationships . 2. At least one category table and a t least one intersection table . 3. The number of object and transaction tables will vary depending upon the complexity of your process. 4. A data design explanation section . o For each object , transaction , category and intersection table that you include in the data diagram , include 1 paragraph e xplaining the purpose served by the table and the logic for including the attributes. Clearly identify the primary key and foreign key(s) (if applicable) for each table. Also specify the purpose served by each foreign key. o For each intersection table , ALSO copy this paragraph filling in the parameters as appropriate : – Th e A_B_Intersection_Table_Name intersection table supports a many -to-many relationship between the Table_One table and the Table_Two table. Th e intersection table , itself, is not a list of individual events or objects of interest , rather its purpose is to record an association between items in the other tables . It has its own primary key and has two foreign key attributes Att_A which points to the primary key of Table_One and Att_B which points to the primary key of Table_Two . o Example data from ALL the tables in your Access database . Include enough data to demonstrate how the table works, e.g., category tables include at least 2 different categories and intersection tables show M:M relationships in action . A minimum of 2 rows for a category table , a minimum of 5 rows for object and transaction tables , and a minimum of 10 rows for intersection tables. – A copy of your Access database file which includes the data /relationship diagram and the tables with example data , so we can verify your work . – Also include the REVISED version of your PRJ1 document with your submission.
Part 1:Directions: Use the following information to complete the questions below. While APA format is not required for the body of this assignment, solid academic writing is expected, and documentatio
PSY-520 Graduate Statistics Topic 1 – Descriptive Statistics Project Directions: Use the following information to complete the questions below. While APA format is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center. A researcher was interested in the anxiety present in students just prior to the midterm exam. The research used an anxiety self-quiz to gage the student’s anxiety. The score for 30 students are given here. 69 99 91 66 70 98 70 53 40 58 61 66 94 77 70 56 88 85 86 40 84 86 54 48 86 43 78 53 79 89 Construct a frequency table with class, frequency, relative percent, and cumulative percent that has 6 classes to describe the distribution of the data in SPSS. Use the frequency table created in problem to construct a histogram in SPSS. Use SPSS to calculate the numerical descriptive statistics mean, median, standard deviation, and variance of the anxiety scores.