Write the formula from the name of the compound. a)  potassium nitrite b)  Iron (II) chloride c)  carbon monoxide d)  calcium carbonate  

Name the following compounds (A)  MgCl2  (B)  Na2SO4  (C)  Al2O3  (D)  FeCO3    

Systemic lupus erythematosus is characterized by what laboratory or clinical findings:

Which test uses labeled antibodies to detect tumor antigens in tissue samples?

A 16-year-old male goes to his physician for an annual checkup. A routine urinalysis indicates the presence of blood, an increase in protein, and an increase in urea. The young man reports that he has been feeling tired and has a persistent cough. The doctor orders additional laboratory testing, including a serum test for rheumatoid factor, antinuclear antibody testing, anti-streptolysin O testing, and testing for the presence of anti–GBM. Only the latter test was positive. What disease is the most likely cause of the symptoms?

A 54-year-old male visits his physician with complaints of fatigue and weakness. He reports previously having a healthy appetite but that recently he’s been feeling full in his abdomen, making eating uncomfortable. Upon physical examination, the physician finds that the patient’s spleen is enlarged. The patient reports no history of blunt contact to the abdomen that would cause such enlargement. The physician orders laboratory work. The most striking results are anemia, leukopenia, and thrombocytopenia. The results also indicate that lymphocytes with abnormal morphology are within the peripheral blood. The lymphocytes are identified as having cytoplasmic projections. The physician is concerned that the patient may have a leukemia, which commonly presents with the classic triad of anemia, leukopenia, and thrombocytopenia. Based on the patient’s age and gender, which of the leukemias is most likely?  

STOP!!! Please remain on this page. Do not proceed until the teaching team instructs everyone to continue. [1] Some useful resources: SQL Basics Chapter 6 – Basic SQL Instructions for 2-File Autograder.pdf [2] All of the queries are based on the following “global company” scenario: Global Company Database Handout Global Company Database EERD Global Company Database Relational Schema [3] In this autograder format, you will need to download two files: sum26_exam2_da_init.sql and sum26_exam2_da_student.sql. Once you have downloaded the files, run sum26_exam2_da_init.sql once. Now, you can start writing your solutions in sum26_exam2_da_student.sql and run this file only when you hope to see your grade. You do not need to run the database initialization file again.   [4] Submit your answers using this format (one of these per question): create or replace view practiceQuery as ; This is the same format that you’ve used when practicing with the company autograder in class. [5] Also, please be sure to use the “as” operator to rename any duplicate columns in the select clauses of your queries.  All column names must be unique for our evaluation system.  Leaving duplicate column names in your query definitions can cause the evaluation and testing of your submission to fail.  Also, your column names do NOT have to match the expected output. [6] Finally, all of the queries involve the select command.  Do not submit any other queries or transactions involving these commands or their variants: insert, update, delete, create (other than creating views), alter, drop.   [7] Make sure your queries work using the Autograding System and the Magic Tables as we have been doing in class.  [8] Upload only the  sum26_exam2_da_student.sql file to the Daily Activity 11.3 Gradescope assignment. Only the code uploaded to Gradescope will be graded, so make sure you really saved your latest version!! There are 3 points in total. Both the local autograder and Gradescope show your final score.  STOP!!! Please remain on this page. Do not proceed until the teaching team instructs everyone to continue.

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?