Company XYZ owns a social network web site dedicated for wind surfers. They plan to launch a new online ad delivery and management service web site that will be coupled with their existing social network platform. The online ad management service will enable them to accept online orders for online ads from advertisers. The system will also deliver the ads to the main social network site. The ads will be displayed on the social network site but the content of the ads (the images and/or text objects containing the ad message) will be served by the new web site server. The company forecasts that the web site will receive an average of 10,000 visits from potential or current advertisers and 600 online ad purchase orders per week. They expect to have 30,000 registered online advertisers during the first month of the launch of the web site. Company XYZ dedicate a separate server and database for the new online service. The users of the ad management site and the users of the social network will be managed separately. The data of the two groups will be stored on separate databases. Similarly, web ad management site content and the social network site content will be hosted on separate servers. Company XYZ prefers to manage those two sites separately. The social network site will pull online ads from the database of the online ad management system. The users will experience a seamless presentation of ads within the social network pages without noticing the ads are fed from a different server.

Company XYZ awarded a contract to your company (Company ABC) to develop the web site, web service, and the database that will provide the capability of the online ad delivery and management service. You are the project manager of this project. Your task is to manage a team of three (one graphic designer, one database developer, and one software developer). As the project manager you are required to answer the following questions that provide insight about the project plan.

Explain how the online ads will be stored and served.

Create your own data. Ensure the data will test all criteria and prove all sorts worked as required. Be sure that all tables and queries have descriptive names. “Query 1” and “Step 1” are examples of poor names.

Step 1

Build a Database named DBMS Course Project. The database should include the following tables:

• First Table – Students
  • ID
  • First Name
  • Last Name
  • Address
  • City
  • State
  • Zip Code
  • Phone Number with area code
• Second Table – GPA
  • ID Current GPA (two decimal positions)
  • Class (numeric field, 1 = Freshman, 2 = Sophomore, etc.)
    • Freshman
    • Sophomore
    • Junior
    • Senior
    • Graduate Student
• Third Table – Scholarships
  • ID
  • Major course of study
  • Academic Scholarship (Use Yes/No data type)
  • Athletic Scholarship (Use Yes/No data type)

Step 2

Extract the First and Last Name, Address, City, State, Zip Code and Phone Number of each Senior on the database. Sort by Last Name, then First Name (1 sort).

Step 3

Extract the First and Last Name, and GPA of each student who qualifies for the Dean’s List. Sort by GPA, then Last Name, then First Name (1 sort). A GPA of 3.25 is required to make the Dean’s List.

PART 2

Build a query of all students on athletic scholarship. Additionally, produce a report with descriptive report and column headings. Be sure there is enough data to prove the selection and sort worked as required. Submit the database in unzipped format as well as submitting screenshots of the query and the report.

Step 1

Extract the First and Last Name, Student ID, Course Major and GPA of all students on athletic scholarship. Sort by Course Major, Last Name, then First Name in a single sort.

Step 2

Produce a report with the data from Step 1 and use good headings.

2. Enter the following record into the Inventory table using data listed below:

3. The Chevrolet Lumina was sold on 5/20/08 by Bauer for $9,300. Update the INVENTORY table and modify date sold, selling price, and repnumber.
4. Write SQL statements to query the following information
   1. All vehicles available for sale with a selling price less than $6,000, sorted by cost in descending order.
   2. All vehicles sold, grouped by Sales Rep.
   3. All vehicles made by Ford and Toyota.

Identify two classes of diuretics with regard to mechanism of action, indications, dosage, routes of administration, adverse effects, toxicity, cautions, contraindications, and drug interactions. Using a minimum of two scholarly article to support it, describe how these diuretics work in the kidney and how they lower blood pressure in individuals. Please answer with a minimum of 250 words and in APA essay format, not a list. Do not forget to add two citations in APA.

Discuss why correlations does not necessarily means causality. After performing some research using JSU library and other online resources, identify some pertinent variables that may be highly correlated, and then discuss using actual data citations and references about their causality or lack of it. Under what circumstances correlation leads to causality? Your response should be comprehensive using up-to-date information and scholarly references.

Describe the difference between inpatient and outpatient facilities. Describe the difference between public, voluntary, and private hospitals. Find the hospital closest to your home, and define what type of hospital it is.

Minimum 400 words please

Intext citations and reference please

Ref:

An Introduction to Community Health. 8th ed.

McKenzie, J.F., Pinger, R.P., Kotecki, J.E.

Jones & Bartlett Learning. 2015  

ISBN: 978-1284036596

Provide your answers to the following questions in a 2-page paper. Use APA Editorial Format for all citations and references used.

What should the "culture and environment of safety" look like when preparing and administering medications?

Discuss a common breach of mediation administration.

Identify three (3) factors that lead to errors in documentation related to medication administration.

What can I do to prevent medication errors?

Discuss why correlation does not necessarily means causality. After performing some research using JSU library and other online resources, identify some pertinent variables that may be highly correlated, and then discuss using actual data citations and references about their causality or lack of it. Under what circumstances correlation leads to causality? Your response should be comprehensive using up-to-date information and scholarly references.

Please I need assistance with this assignment- Select one of the United Nations' (U.N.) Millennial Development Goals (MDGs). Visit the website and report on the UN's progress in achieving this goal? How will meeting this goal positively impact the health of the world? What suggestions would you make to help the UN achieve this goal? Please write from scratch, include citations and at least 3 references. Thank you

Describe Bronfenbrenner’s Theory and evaluate its connections to Role Strain and Parenthood with single parents versus two parent households with current societal examples.

Refer to any scholarly article that connects to the topic to write a Word document with a 500-750 word count. Include factual connections with in –text citations and a reference page. All writing must adhere to APA standard format. A mminimum of two references is required.