EXTRA CREDIT – 10PTS Guidelines on Extra Credit: Partial credit will be applied based on effort shown. Establish a relationship between tables… In the previous 2 questions you added a ClientProfile table to your client management system database to track basic client information and populated it with the initial profiles. Now you need to create a second table that tracks services provided to those clients. Each client may receive multiple services, but each service record should belong to a valid client profile. The program needs to track: A unique identifier for each service record The client who received the service The date the service was provided The type of service provided The only service types that should be allowed are: Case Management Transportation Referral Write a SQL  statement that makes a table called ClientServices under the same schema as ClientProfile. HINT: You should only have 4 columns in your table. Make sure your table includes appropriate: Column names Data types Column definitions, including any constraints (table or column level) Relationships

Essay Question Instructions: Make sure you show all work on the four essay questions on scratch paper. Upload a PDF of your written work to the Canvas Upload module immediately after you finish the test. Most of the points are awarded based on your written work, not the final answer that you submit to each question. Essay Question 3: Four friends are starting a business with the goal to provide food and beverages to individuals down on their luck. To help with startup costs for the business, each of them contributed some money to the project. Schmidt contributed $180,000. Winston contributed $100,000. Jess contributed $80,000. Nick contributed $20,000. To make decisions as a group, they instituted a weighted voting system where they each get one vote for each $10,000 contributed.  (A) Describe this situation with weighted voting system notation using a simple majority quota. (B) Write out all the winning coalitions. Underline the critical player(s). (C) Find the critical counts for each player. (D) Calculate the Banzhaf power distribution of this weighted voting system.

Given the weighted voting system [17:8,7,6,4], in which sequential coalition is the fourth player pivotal?

Essay Question Instructions: Make sure you show all work on the four essay questions on scratch paper. Upload a PDF of your written work to the Canvas Upload module immediately after you finish the test. Most of the points are awarded based on your written work, not the final answer that you submit to each question. Essay Question 1: The manager of a local hospital has recently received 160 new HDTVs for the patients’ rooms as a result of recent donations. However, there are thousands of old TVs that need to be replaced. The manager does not want to simply give 40 TVs to each wing of the hospital since each services a different number of patients. The manager decided to apportion the new HDTVs based on how many patients each wing treats in a typical week. The north wing typically has 36,720 patients per week. The south wing services 24,101 patients per week. The east wing services 7,746 and the west wing services 29,033 patients per week.  (A) Find the standard divisor. Write the standard divisor in the box below. (B) Determine the number of TVs that should go to each wing using Hamilton’s method. Show all work. (C) A suitable divisor for Jefferson’s method is d=602. Find Jefferson’s apportionment. (D) Explain why you got a different answer for Part (B) and (C). Explain using a complete sentence.

Essay Question Instructions: Make sure you show all work on the four essay questions on scratch paper. Upload a PDF of your written work to the Canvas Upload module immediately after you finish the test. Most of the points are awarded based on your written work, not the final answer that you submit to each question. Essay Question 1: The manager of a local hospital has recently received 160 new HDTVs for the patients’ rooms as a result of recent donations. However, there are thousands of old TVs that need to be replaced. The manager does not want to simply give 40 TVs to each wing of the hospital since each services a different number of patients. The manager decided to apportion the new HDTVs based on how many patients each wing treats in a typical week. The north wing typically has 36,090 patients per week. The south wing services 24,931 patients per week. The east wing services 8,336 and the west wing services 29,043 patients per week.  (A) Find the standard divisor. Write the standard divisor in the box below. (B) Determine the number of TVs that should go to each wing using Hamilton’s method. Show all work. (C) A suitable divisor for Adam’s method is d=623. Find Adam’s apportionment. (D) Explain why you got a different answer for Part (B) and (C). Explain using a complete sentence.

Section 1: Fill in the blank (11 pts) Fill in the blank with the correct answer. All shorthand electron configurations begin with a [blank] in brackets. The energy of the reactants is higher than the energy of the products in an [blank] reaction. Oxygen typically forms [blank](#) bonds and has [blank](#) lone pairs. The maximum number of dots allowed around a symbol in a Lewis dot symbol is [blank]. In an [blank] electrons are signified with up and down arrows. The term used to describe the heat capacity of 1 gram of substance is [blank]. In a covalent bond, electrons are [blank]. Halogens have [blank] valence electrons. [blank] energy is the energy of movement while [blank] energy is stored energy. Section 2: True/False (4 pts) Answer true or false. If the answer is false, correct the statement. Lewis structures can have double, triple, and quadruple bonds. Heat always flows from system to surroundings. The s sublevel is higher in energy than the d sublevel. An exothermic reaction has a negative DH. Section 3: Multiple Choice (6 pts) Indicate the letter of the correct answer on your paper. Which of the following has the correct order of orbitals? 1s 2s 2p 3d 1s 2s 2p 3s 1s 2s 2p 3p The valence electron configuration for alkaline earth metals is: ns1 ns2np6 ns2 Which of the following is an exothermic process? Melting ice. Water condensing on side of glass. Boiling water. Section 4: Short Answer (29 pts) Show all work. Be sure to clearly indicate your answer. Draw a Lewis dot symbol for chlorine and for chloride and explain the difference. (3 pts) Write out the full and shorthand electron configuration and draw an orbital diagram for element number 34. (8 pts) A student must use 225 mL of hot water in a lab procedure. Calculate the amount of heat required to raise the temperature of 225 mL of water from 20.0°C to 100.0°C. Show ALL work, don’t forget units and SF. c of water = 4.184 J/g°C, density of water is 1.0 g/mL. (4 pts) Complete the following table. (8 pts) Molecule Lewis Structure CO2 NF3 H2S CH2O A 12g piece of aluminum (c= 0.215 cal/g°C) is at 70°C. It is placed in a beaker that contains 35g of 15°C water (c= 1 cal/g°C). At what temperature will they come to thermal equilibrium? Show ALL work, don’t forget units and SF. (6 pts)  

A company has provided the following data from its activity-based costing system:  Activity Cost PoolActivity Rate    Assembly$ 13.54 per machine-hour   Processing orders$ 25.89 per order   Inspection$ 76.50 per inspection-hour   The company makes 470 units of product WW50 a year, requiring a total of 660 machine-hours, 50 orders, and 40 inspection-hours per year. The product’s direct materials cost is $40.30 per unit and its direct labor cost is $42.22 per unit. The product sells for $118.00 per unit.According to the activity-based costing system, the product margin for product WW50 is:Note: Round your intermediate calculations and final answers to 2 decimal places.

A company has two products: A and B. The company uses activity-based costing. The total cost and activity for each of the company’s three activity cost pools are as follows:Activity Cost PoolTotal CostTotal ActivityProduct AProduct BTotalActivity 1$ 32,6007003001,000Activity 2$ 17,600600200800Activity 3$ 52,500400100500The activity rate under the activity-based costing system for Activity 3 is closest to: 

A company has two divisions: Retail Division and Wholesale Division. The following data are for the most recent operating period:   Total CompanyRetail DivisionWholesale DivisionSales$ 510,000$ 153,000$ 357,000Variable expenses$ 312,120$ 87,210$ 224,910Traceable fixed expenses$ 113,360$ 35,280$ 78,080   The common fixed expenses of the company are $65,040.The Wholesale Division’s break-even sales is closest to:

A business has two major business segments–North and South. Last month, the North business segment had sales revenues of $260,000, variable expenses of $145,000, and traceable fixed expenses of $33,000. During the same month, the South business segment had sales revenues of $930,000, variable expenses of $488,000, and traceable fixed expenses of $177,000. The common fixed expenses totaled $262,000 and were allocated as follows: $131,000 to the North business segment and $131,000 to the South business segment.A properly constructed segmented income statement in a contribution format would show that the segment margin of the South business segment is: