For this assignment you have to create tables as reviewed in class Manufacturer table, Product table and Stock table. The code is in Week 7 PPT lecture. You are to add update as needed to make the tables the same as below and match Product, Manufacturer and Stock as below.
For this assignment you will be working with these same tables.
Please complete the following tasks and submit in word file or notepad.
1. First insert tuples into two of the tables and make sure the contents of the tables match below.
Write and execute the SQL to insert three records ProductID 844, 555 and 645 to the Product table (see below)
Write and execute the SQL to insert the one record to the Stock table (see below).
2. Write and execute the SQL select statements to do the following selections of ALL TUPLES IN A TABLE
a. Select all (attributes) tuples in Product
b. Select all (attributes) tuples in Manufacturer
c. Select all (attributes) tuples in Stock
3. Write and execute the SQL select statements to do the following selections of ONLY SOME TUPLED IN A TABLE
a. Select Manufacturer ID = 1 tuples in Product table.
b. Select ProductID of Products that have a quantity of 300.
c. Select ProductID of Products that have quantity of 300 and less.
4. Write and execute the SQL select statements that select attributes (not all) based on a condition.
a. Select ProductID for items with ManufacturerID of 4.
b. Select ProductName for items with ManufacturerID of 1.
c. Select Products with the productName 'Keyboard'
5. Write and execute the SQL select statements that SELECT with and without DISTINCT modifier
a. Select ProductName and ManufacturerID from Product
b. Select Product Name and ManufacturerID from Product with the Distinct modifier.
c. Explain the difference in the results from a and b.
In: Computer Science
You work in the corporate office for a nationwide convenient store franchise that operates nearly 10,000 stores. The per-store daily customer count (i.e., the mean number of customers in a store in one day) has been steady, at 900, for some time. To increase the customer count, the chain is considering cutting prices for coffee beverages. The question to be determined is how much to cut prices to increase the daily customer count without reducing the gross margin on coffee sales too much. You decide to carry out an experiment in a sample of 24 stores where customer counts have been running almost exactly at the national average of 900. In 6 of the stores, the price of small coffee will now be $0.59, in 6 stores the price of a small coffee will now be $0.69, in 6 stores, the price of a small coffee will now be $0.79, and in 6 stores, the price of a small coffee will now be $0.89. After four weeks of selling the coffee at the new price, the daily customer counts in the stores were recorded and stored as follows...
| $0.59 Sales | $0.69 Sales | $0.79 Sales | $0.89 Sales |
| 964 | 953 | 942 | 920 |
| 972 | 950 | 937 | 918 |
| 962 | 959 | 945 | 925 |
| 968 | 955 | 948 | 919 |
| 975 | 960 | 945 | 915 |
| 960 | 954 | 941 | 906 |
1) Analyze the data and determine whether there is evidence of a difference in the daily customer count, based on the price of a small coffee.
2) If appropriate, determine which mean prices differ in daily customer counts.
3) What price do you recommend for a small coffee?
Response should be computer-generated, such as in Word or Excel, not a photo of handwritten work. Preferably excel if at all possible. It should follow a basic memo format with introduction, analysis, and conclusions.
In: Statistics and Probability
Review the following PDF to learn more:
MMWR: Strategies for Reducing Health Disparities—Selected CDC-Sponsored Interventions, United States, 2014
Create a 4- to 5-page Microsoft Word document that addresses the following:
Compare the patterns of the major diseases of
Hispanic/Latino groups and their rates and health effects between
the other racial or ethnic groups living in the United
States.
Identify at least one consequence that a lack of
access to healthcare has on Hispanics/Latinos.
Explain why access to care issues will need to be
monitored even more closely within the U.S. healthcare system
beginning 2014.
Find at least two scholarly journal articles that
discuss all or at least one of the topic areas related to
Hispanic/Latino health disparities in the United States. Provide a
synopsis of each article.
Explain what type of barrier(s) (structural,
financial, or socio-cultural) each article examines? Describe at
least two policies or strategies that can be implemented to improve
access to healthcare services as they relate to the articles you
reviewed.
Compare the patterns of the major diseases of
Hispanic/Latino groups and their rates and health effects between
the other racial or ethnic groups living in the United
States.
Identify at least one consequence that a lack of
access to healthcare has on Hispanics/Latinos.
Explain why access to care issues will need to be
monitored even more closely within the U.S. healthcare system
beginning 2014.
Find at least two scholarly journal articles that
discuss all or at least one of the topic areas related to
Hispanic/Latino health disparities in the United States. Provide a
synopsis of each article.
Explain what type of barrier(s) (structural,
financial, or socio-cultural) each article examines? Describe at
least two policies or strategies that can be implemented to improve
access to healthcare services as they relate to the articles you
reviewed.
In: Nursing
In: Nursing
In: Nursing
Using Walmarts most recent 10-k report can you please add comparative information in reguards to its previous year as well as add more information to each section so I make the minimum word requirement (of 300 a section).
Part 1: In 1000 words total compute and analyze the following group of ratios for Walmart and explain how they affect the investors’ or creditors’ decisions regarding the company. Please include an introduction sentence referencing the sources of data for ratios. Provide a comparative analysis for each ratio. Make sure your analysis includes a comparison to the company’s prior year ratios OR the competitor’s ratios.
• Liquidity Ratios:
A. Current ratio = Current Assets / Current Liabilities
= 61897/77477
=0.80
The current ratio of the company is 0.80, this means that the current assets of the company are not enough to settle the current liabilities. A current ratio above 1 is optimal.
B. Accounts receivable turnover =Net Sale/Average AR
|
Average AR= |
5614+6283 |
|
2 |
|
|
Average AR= |
5948.50 |
Accounts receivable turnover=510329/5948.50
=85.79
The Accounts receivable turnover ratio shows the capability of the company to collect the credit sales made. The company (Walmart) has 85.7 as its accounts receivable ratio, which when compared to other companies in the industry (Normally 80 and below) has higher-quality customers that pay their debts quickly.
C. Inventory turnover =Cost of Goods Sold/Average Inventories
|
Average Inventory= |
43783+44269 |
|
2 |
|
|
Average Inventory= |
44026 |
Inventory turnover=385301/44026
=8.75
The inventory turnover ratio shows how many times the company has replaced the inventory as a reason for sales. Walmart has an inventory turnover ratio of 8.75, which means that it has replenished the inventory almost 9 times during the year due to its sales.
In: Accounting
Figure 1: The Demand Schedule for Barbeque Dinners
|
Price |
Quantity Demanded |
Total Revenue |
Elasticity Coefficient |
Elastic or Inelastic |
||||||||
|
$4 |
100 |
__________ |
XXXX |
XXXX |
||||||||
|
6 |
80 |
__________ |
__________ |
__________ |
||||||||
|
8 |
60 |
__________ |
__________ |
__________ |
||||||||
|
10 |
40 |
__________ |
__________ |
__________ |
||||||||
|
12 |
20 |
__________ |
__________ |
__________ |
||||||||
|
14 |
1 |
__________ |
__________ |
__________ |
||||||||
In: Economics
Medicare is an
even bigger problem and solving it is a political minefield. Some
ideas privatize as much as possible and encourage insurance only
for catastrophic health bills to encourage a more thrifty approach
to health care by seniors. This one is arguably the toughest fix of
all and arguably needs to make health care as a whole more
efficient and not just Medicare itself. How would you solve the
national debt problem? Also explain which solution you feel is the
most attractive?. What are the political obstacles? How does your
philosophy affect which choices you make?Also see the last word in
ch 13 for details of the entitlement options. . . One interesting
In the recent health care reform is health care exchanges. They
should have taken that aspect even further by creating a national
exchange(instead of 50 state exchanges which will work well in the
big states but not in the smaller states). We have to hope health
care reform works. One good sign is recent health care inflation
fell to a 20 year low at least before health care reform began.
Medicaid which is health care for the poor needs reforming as well.
Liberals would have the feds overhaul medicaid by merger with
medicare. Conservatives like state grants with reforms such as the
Rhode Island experience could be useful here as well. There the
state, the feds saved money and appear to have gotten better health
outcomes. In Rhode Island Bush gave the state an exemption from
lots of federal rules ultimately saving the states and fed money
has health care. What is the biggest obstacle to entitlement
reform? (10 points)
Can economics explain what type of incentives are needed to get politicians to do the right thing. Why?(10 points)
In: Economics
Umbrella Corp produces engine parts for large aircraft. The company uses a standard cost system for production costing and control. The standard cost sheet for one of its higher volume products (a valve) is as follows:
-Direct materials (7 lbs. @ $5.40) $37.80
- Direct labor (1.75 hrs. @ $18) 31.50
- Variable overhead (1.75 hrs. @ $4.00) 7.00
- Fixed overhead (1.75 hrs. @ $3.00) 5.25
- Standard unit cost $81.55
During the year, Umbrella had the following activity related to valve production:
a. Production of valves totaled 20,600 units.
b. A total of 135,400 pounds of direct materials was purchased at $5.36 per pound.
c. There were 10,000 pounds of direct materials in beginning inventory (carried at $5.40 per pound).
There was no ending inventory.
d. The company used 36,500 direct labor hours at a total cost of $656,270.
e. Actual fixed overhead totaled $110,000.
f. Actual variable overhead totaled $168,000.
Umbrella produces all of its valves in a single plant. Normal activity is 20,000 units per year. Standard overhead rates are computed based on normal activity measured in standard direct labor hours.
Required:
1. Compute the direct materials price and usage variances.
2. Compute the direct labor rate and efficiency variances.
3. Assume that the purchasing agent for the valve plant purchased a lower-quality direct material from a new supplier. Would you recommend that the company continue to use this cheaper direct material? If so, what standards would likely need revision to reflect this decision? Assume that the end product’s quality is not significantly affected.
4. Prepare all possible journal entries for direct materials and direct labor costs.
Note: please provide your answers and explanations on spreadsheet or Word format.
In: Accounting
Using C++,
Write a class KeywordsInFile. Create KeywordsInFile.h and KeywordsInFile.cpp.
The only required constructor for this class is
KeywordsInFile( filename_with_keywords, filename_with_text)
Consider a word to contain only upper- and lower- alphabet symbols. Any non-alphabet symbol is considered a separator.
Your class should be case-sensitive. So, “sun” and “Sun” are two
different words.
The processing of the files is done during the object construction.
All the data needed for the methods below is stored in the
object.
The processing should be done in O(N+M) time. Consider string hashing to be O(1) for this assignment.
The number of keywords can be large. The text can be large. Number of keywords in the text can be very large or very small. Design your class accordingly.
Disable the default non-parametrized constructor.
The following methods should be implemented:
KeywordFound( keyword ) – returns true if the specified keyword was found in the text. Returns false otherwise. The method should run in O(1) time.
KeywordInLine( keyword, line_number ) – returns the number of times the specified keyword was seen in the specified line of the text. The method should run in at most O(log L) time, where L is the number of times the keyword was found in the text.
TotalOccurrences( keyword ) – returns the total number of the occurrences of the given keyword in the text. The method should run in at most O(log L) time, where L is the number of times the keyword was found in the text.
Overload operator<< that allows you to use object of your class with cout. When in the program I use command cout
In: Computer Science