Retrieving Data From Multiple Tables Week 5 CIS 336

First, make sure to make any necessary revisions to your logical model based on Task 1 feedback. Using MySQL, write the statements to develop a physical model of your database by creating the tables and constraints based on your Task 1 logical model. Be sure to use your ERD and data dictionary and create all constraints appropriately.  Once your tables are created, you will populate them with data using MySQL statements to insert records into the database. You should insert a minimum of five records into each table and more where necessary to ensure that the data in the database is sufficient to allow for each of your reports to be tested. The result will be a script file that includes statements to Name this file yourname_task2.txt.Also create a Word document that shows the structure of each table and the data in each of your tables (copy and paste from MySQL). Name this file yourname_tables.docx.Note that your deliverables each week include any revisions to a previous task.Submit your Task 2 deliverable as a zip file including the following.

the similarities on the three cources

on the paper that i will up load
For this journal entry discuss three similarities shared among your memorable courses. These similarities might relate to the content of the courses; the effect the courses had on how you think; etc. What might these similarities suggest in describing you as a learner?

the three cources is on the paper

For A-Plus Writer

  In Week One, you will choose a generic organization (manufacturing plant, hospital, etc.).  Assume that you are a hired consultant for this organization.  You have been asked by the president of the organization to prepare a background paper on the results of your research and to make recommendations to improve group productivity in the organization.Your research has identified the following problems:In an eight- to ten-page paper, include the following: 

Elements of a Marketing Plan Report

 the video case study \”Geek Squad: A New Business for a New Environment\” on pp. 88-89 attached.  Keep this case study in mind as you complete this assignment.   a 700- to 1,050-word paper using acompany or one with which you are familiar Answer the following questions for your chosen organization.at least three references.. your paper consistent with APA guidelines.

Effects of StressProvide a 1-page description of a stressful event currently occurring in your life.

Assignment 1: LASA 2: Effects of StressProvide a 1-page description of a stressful event currently occurring in your life. Then, referring to information you learned throughout this course, address the following:In addition to citing , you are also required to cite a minimum of . Please see the  section under to use the  to find appropriate scholarly sources. For reputable web sources, look for .gov or .edu sites as opposed to .com sites. Please do not use Wikipedia.Your paper should be double-spaced, in 12-point Times New Roman font, and with normal 1-inch margins; written in APA style; and free of typographical and grammatical errors. It should include a title page with a running head, an abstract, and a reference page. The body of the paper should be at least 6 pages in length.Save the response as AU_PSY350_M5_A1_LastName_FirstInitial.doc. Submit your response to the  by 

The rows should include revenue, expenses, calculated profit, and calculated profit margin.

 Draft a one-page spreadsheet showing financial history and projected performance for the company have chosen  The rows should include revenue, expenses, calculated profit, and calculated profit margin. The columns should be years: two years of history, plus three years of your reasonable future projections. Include a few sentences of key assumptions and conclusions. The spreadsheet must have accurate calculations and the cells of the spreadsheet should show your calculation formulas. Your spreadsheet should look professional on screen and when printed (including a heading and meaningful number formatting). Submit this assignment as an Excel spreadsheet file, not a PDF document.    

4 Video Case Studies

Book ReferenceUnit II Case StudyVideo Case: Strategic Management: Joie de Vivre HospitalityInstructions: Read the video case in your textbook titled “Strategic Management: Joie de Vivre Hospitality,” then watch the corresponding video in the Unit Study Guide. Answer two of the Discussion Questions on page 81. Be sure to restate each question in your own words before answering in essay format. Your total assignment response must be at least 400 words in length. You must use at least your text book to complete this assignment. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations. All references and citations used must be in APA style.PearsonMyLab Video: Joie de Vivre Hospitality: Strategic ManagementPearson Link:  Unit III Case StudyVideo Case: Interviewing Candidates (Zipcar)Instructions: Read the video case in your textbook, titled “Interviewing Candidates (Zipcar),”then watch the corresponding video in the Unit Study Guide. Answer two of the Discussion Questions on page 209. Be sure to restate the question in your own words before answering in essay format. Your total assignment response must be at least 400 words in length. You must use at least your textbook to complete this assignment. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations. All references and citations used must be in APA style.PearsonMyLab Video: ZipCar: Interviewing CandidatesPearson Link: Unit IV Case StudyVideo: Training (Wilson Learning)Instructions: Read the video case in your textbook, titled “Training (Wilson Learning),” then watch the corresponding video in the Unit Study Guide. Answer four of the Discussion Questions on page 251. Be sure to restate each question in your own words before answering in essay format. Your total assignment response must be at least 400 words in length. You must use at least your textbook to complete this assignment. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations. All references and citations used must be in APA style.PearsonMyLab: Wilson Learning: TrainingPearson Link:Unit VII Case StudyVideo Case: Union-Management Relations (UPS)Instructions: Read the video case in your textbook, titled “Union-Management Relations (UPS),” then watch the corresponding video in the Unit Study Guide. Answer Discussion Questions 15-13 and 15-16 on page 483. Be sure to restate each question in your own words before answering in essay format. Your total assignment response must be at least 400 words in length. You must use at least your textbook to complete this assignment. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations. All references and citations used must be in APA style.UPS: Union-Management Relations  

Assignment 3: Business Intelligence and Data Warehouses

Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a manner that optimizes processing large amounts of data.Write a two to three (2-3) page paper in which you:Your assignment must follow these formatting requirements:The specific course learning outcomes associated with this assignment are:Click  to view the grading rubric for this assignment.

Victims and Crime Evaluation

 a 1,050- to 1,400-word paper that describes roles and functions of individuals in the criminal justice system and how victimization affects each role. the roles of prosecutor, defense attorney, criminal, and victim. how victimization affects each role. the following questions: your paper consistent with APA guidelines. No Paper mill papers will be Exceted

Assignment 1: B2C vs. B2B Buying Behavior

We market to consumers differently than we do when we market to businesses. There are some marketing basics that are the same but there are also many differences. The decision to buy is derived in different ways and requires a whole different approach from marketers. In this assignment, you are to explain these similarities and differences.Be sure to provide supporting evidence for your statements. Write your initial response in a minimum of 200–300 words. Apply a standard business writing style (headers/ sub heads/ bullets) to your work but be sure to cite your work in the APA format.