Create the tables for the database and Chapter 4 instructs you to add the constraints. Use SQL Developer to write a single script that accomplishes both tasks.

/in /by

Oracle 12c:sql chapter 3, end of chapter, case study: city jail exercise 01

This week’s lab is to complete the City Jail tasks described at the end of chapters 3 and 4.

The ERD (CityJailERD.pdf) for Lab 1 is provided in the Learning Activities of Module 4. You can use this ERD to create tables in the database. But before you start, compare the ERD with yours in Lab 1, and make sure you understand what entities are included and relationships among the entities. Then use CityJail_4Data.sql provided to insert data into the database.

Note that Chapter 3 has two parts: Section A and Section B.

Chapter 3, Section A asks you to create the tables for the database and Chapter 4 instructs you to add the constraints. You do not need to do this as a 2-step process. Use SQL Developer to write a single script that accomplishes both tasks. Then write a second script that performs the tasks outlined in Chapter 3, Section B on page 98.

Explain global supply chain quality six-sigma, just in time, the Pareto, total quality management, and Business Process Enterprises approaches in about 250 words – with about 4 references in APA Format.

/in /by

SUPPLY CHAIN 8

Explain global supply chain quality six-sigma, just in time, the Pareto, total quality management, and Business Process Enterprises approaches in about 250 words – with about 4 references in APA Format.

Review the Wisconsin Early Model Learning Standards’ domains to find which sub-domain your goal, objective, and activity will fit under. Write a brief reflection about why you selected this sub-domain.

/in /by

Module 04 Content

Scenario

For this assignment, you will explore Developmentally Appropriate Practice (DAP) goals, learning objectives, and activities. You will select goals for a group of children, write learning objectives to meet the goals, and plan activities that will support the learning objectives and the goals. For this assignment you will use the Wisconsin’s Early Model Learning Standards.

Directions

You will create a chart to demonstrate an understanding of Developmentally Appropriate Practice (DAP) goals, learning objectives, and activities for one age group – either Infant/Toddler or Preschool. You may use the templates provided (in Additional Resources) or you may create your own.Step 1: Goals

Select one age group – either Infant/Toddler or Preschool.

You will write two goals that are DAP for each of the five domains, creating a total of ten goals.

Step 2: Learning Objectives

  • For each goal, write one developmentally appropriate learning objective that supports each goal.
  • Each learning objective must be measurable, include conditions for the objective to be met, and include criterion for acceptable performance. You will have a total of 10 objectives.

Step 3: Activities

Plan a developmentally appropriate activity that supports both the goal and the learning objective. You will have 10 activities.

Include the following for each activity:

  • Title of activity
  • Length of the activity
  • Brief, detailed description explanation how to do the activity.

Step 4: Domain and Sub-Domain Reflection

Review the Wisconsin Early Model Learning Standards’ domains to find which sub-domain your goal, objective, and activity will fit under.

Write a brief reflection about why you selected this sub-domain.

All work should be formatted professionally and use correct spelling, grammar, and punctuation.

When the Bureau of Labor Statistics conducts a survey, it begins by partitioning the U.S. adult population into 2007 groups called primary sampling units. Assume that these primary sampling units all contain the same number of adults. If you randomly select one adult from each primary sampling unit, is the result a simple random sample? Why or why not? If it is not a simple random sample, what type of sample is it?

/in /by

Simple random sample

Answer each question individually.

a. What is a simple random sample?

b. When the Bureau of Labor Statistics conducts a survey, it begins by partitioning the U.S. adult population into 2007 groups called primary sampling units. Assume that these primary sampling units all contain the same number of adults. If you randomly select one adult from each primary sampling unit, is the result a simple random sample? Why or why not? If it is not a simple random sample, what type of sample is it?

c. Refer to the primary sampling units described in part (b) and describe a sampling plan that results in a simple random sample

Create several procedures to accept product number and produce the following result a. Procedure Get_Product_Num_Cust.

/in /by

My SQL Question

This assignment consisted of three parts.

Part 1: Using OES4 database, redo the following two queries (you did them in assignment 4) with PL/SQL:

  1. List number of orders for each state with their total purchase (SUBTOTAL), total shipping charge, total tax, and total purchases (there are 15 branches)
  2. List number of customers with their total purchases (SUBTOTAL), total shipping charge, total tax, and overall total purchases.
  3. List TOP 25% of employees (employee number, employee last name) based on total net sales ( their total subtotal – their total amount returned)
  4. List all product categories and total amount of products sold for each category for every year

 

Part2: Using OES4, answer the following queries with stored procedures

4 Create several procedures to accept product number and produce the following result  a. Procedure Get_Product_Num_Cust.

  1. Procedure Get_ Product_Cust_Purchases
  2. Procedure Get_product_Num_orders

5 Develop a driver program to call all the 5 above procedures and produce the following report  Note: Net sales=Total_sales_amount – total_return_amount

Part3: Using OES4, answer the following queries with user defined functions

  1. Create several user defined functions to accept product number and produce the following result a. Function Get_Product_Num_Cust
  2. Function Get_ Product_Cust_Purchases
  3. Function Get_product_Num_orders
  4. Develop SQL program to call these UDFs

Deliverables:
1. A notepad document to hold all queries, SQL code, and result

 

Analyze the information provided in the SNHUEnergy Inc. scenario to provide high-level assumptions about the design of the network.

/in /by

Milestone Two: Current Network Architecture

For the second milestone, you will analyze the information provided in the SNHUEnergy Inc. scenario to provide high-level assumptions about the design of the network.

Research and discuss basic Prevention Theories and their importance to social work practice. Prevention vs Intervention.

/in /by

Basic Prevention Theories

Research and discuss basic Prevention Theories and their importance to social work practice. Prevention vs Intervention.

How do you define operational excellence? What factors are involved in achieving operational excellence? Who (within an organization) is responsible for operational excellence and why is this important?

/in /by

Operational excellence

How do you define operational excellence? What factors are involved in achieving operational excellence? Who (within an organization) is responsible for operational excellence and why is this important?

Do you have a favorite green place that you like to visit? Or maybe a place you once visited on vacation and would like to go back to? Where is it and what makes that place special to you? If not, is there a place you would like to go?

/in /by

Out for a walk

Your assignment this week will be your first paper.  You are to address the following questions:

  • In the chapter “Health Coverage for Primates,” pgs. 92-115 in your text Four-Fifths a Grizzly, author Douglas Chadwick writes at length about the benefits we receive from being in green spaces, from time in the natural world.  What are the psychological, physical, and emotional benefits to humans?  Be specific.  What physical changes occur in the body that generate these benefits?  What are the psychological and emotional benefits?  Chadwick provides a great deal of material on this subject so there is much for you to use in this assignment.  The bulk of your paper should focus on this first question. You may use additional resources but make sure you cite them within the body of the paper and in the Works Cited.

 

  • Do you have a favorite green place that you like to visit? Or maybe a place you once visited on vacation and would like to go back to? Where is it and what makes that place special to you?  If not, is there a place you would like to go?

 

  • Douglas Chadwick argues that when we spend time in the natural world, we are stepping back into our heritage; that we are an integral and elemental part of the natural world, and that we share a kinship with every visible and the mostly invisible organisms that inhabit this planet.  Habitat loss through destruction, degradation, and fragmentation is the primary threat to the survival of wildlife, and with their loss, our natural spaces are being lost.  This ultimately will imperil our lives as well.  So how do we save our habitats in the face of increasing global demand for the resources they provide?

How has the evolution of the internet piloted the growth of e-contracts? With the implementation of legislation, the Electronic Signatures in Global and National Commerce Act (E-SIGN Act) and the Uniform Electronic Transactions Act (UETA), what is the impact and significance of digital signatures in cyberspace?

/in /by

Discussion: E-Commerce

In this module, we have explored the surge of e-commerce and the escalation of online contracts. How has the evolution of the internet piloted the growth of e-contracts? With the implementation of legislation, the Electronic Signatures in Global and National Commerce Act (E-SIGN Act) and the Uniform Electronic Transactions Act (UETA), what is the impact and significance of digital signatures in cyberspace?