ACC340 Week 4 Team Assignment - Database Tables Exercise

ACC 340 Week 4 Team Assignment – Database Tables Exercise

Using the same step of the accounting cycle selected for your previous Learning Team Meeting Assignments, design at least two tables that could be used in a database for the hosting of data of your selected accounting cycle. Use keys to demonstrate the relationships among your database tables. Be sure to use fictitious data when entering information into the tables.

Also read:

ACC340 Week 4 Individual – Database Definition Exercises
ACC340 Week 3 Team Assignment – Hardware and Software Selection
ACC340 Week 2 Team Assignment – Accounting Cycle Description Pa
Using the Microsoft Access database, you created in Week Three: Customer Service Database, complete :
ACC340 Week 5 Team – Integrated Accounting Cycle Final Report
ACC340 – All Discussions, Individual & Team Assignments
Question: Q: Chapter Chapter 11 of Mertler and Vannata; answer exercises on pages 306 and 307: This exercise utilizes the SPSS data setprofile-e.sav, which can be downloaded from this Web site: www.Pvrczak.com/data Conduct a Forward: LR logistic regression analysis with the following variables: IV—age, educ, hrsl, sibs, rincom91, life2 (categorical) DV—satjob2 Note: The variable Iife2 is categorical such that dull = 1, routine/exciting = 2, and all other values are system missing. Develop a research question for the following scenario. Conduct a preliminary Linear Regression to identify outliers and evaluate multicollinearity among the five continuous variables . Complete the following: a. Using the Chi-Square table in Appendix B, identify the critical value atp< .001 for identifying outliers. Use Explore to determine if there are outliers. Which cases should be eliminated? b. Is multicollinearity a problem among the five continuous variables? Conduct Binary Logistic Regression using the Forward: LR method. IV—age, educ, hrsl, sibs, rincom91, life2 (categorical; last is the reference category) DV—satjob2 Note: Make sure that any outliers identified in Exercise 2a are removed from data before running the logistic regression. Also, designating life2 as a categorical covariate with the last category as the reference, essentially makes "routine/exciting" = 0 and "dull" = 1, so interpret the results accordingly. a. Which variables were entered into the model? b. To what degree does the model fit the data? Explain. c. Is the generated model significantly different from the constant-only model? d. How accurate is the model in predicting job satisfaction? e. What are the odds ratios for the model variables? Explain. Module 14 – Multi-level linear analyses: When do you use multi-level linear analyzes? Chapter 8 of Cronk (chapter below I wasn’t sure what was being asked) and answer all practice exercises; post your results here:
ACC340 Week 5 Individual Assignment – Sarbanes-Oxley Act