1. In the General Social Survey, an ongoing nationwide survey done by the National Opinion Research Center at the University of Chicago, a question asked is whether a respondent favors or opposes capital punishment for persons convicted of murder. The data compares the proportions who said that they were opposed to the death penalty in the year 2000 and the year 2014:

Construct a 95% Confidence Interval for (p₁ – p₂) and interpret the interval.

a.) Based on the Confidence Interval, there is no significant change in the

   proportion of the population opposing capital punishment for persons

convicted of murder between the years 2000 and 2014.

b.) The proportion of the population opposing capital punishment for persons

convicted of murder was between 6% and 11% lower in 2000 than in 2014.

c.) The proportion of the population opposing capital punishment for persons

convicted of murder was between 6% and 11% higher in 2000 than in 2014.

d.) The proportion of the population opposing capital punishment for persons

convicted of murder has increased by between 2% and 8% between the

years 2000 and 2014.

e.) The proportion of the population opposing capital punishment for persons

convicted of murder has decreased by between 2% and 8% between the

years 2000 and 2014.

2. A component of cholesterol called high-density lipoprotein (HDL) is known as ‘good cholesterol’ because high levels of HDL are thought to lower the risk of coronary heart disease. It is believed that runners have increased HDL levels. The data below give details of an HDL study comparing male runners with a control group of male non-runners. At the 5% level of significance, test the claim that male runners have a higher mean HDL level than male non-runners. Assume that the populations are approximately normal.

   Runners Non-runners

   N = 40 N=45

   = 56 = 49

s = 12.1 s = 10.0

   Conduct the hypothesis test and state your conclusion.

1. p= 0.0051. Male runners do not have a higher level of HDL than male non-runners.
2. p =0.0051. Male runners do have a higher level of HDL than male non-runners.
3. p = 0.0025. Male runners do not have a higher level of HDL than male non-runners.
4. p = 0.0025. Male runners do have a higher level of HDL than male non-runners.

Please I have two questions (1). What countries are fairing better or worse than the others in management of Respiratory non communicable disease (2). What are the existing disparities (including race,age and gender as appropriate) in relation to the issue of Respiratory non communicable disease; describe the populations that have emerged as being disadvantaged and why. Write from scratch and provide at least 4 current citations each. I will Turn it in. 2 pages each. Please use APA 6TH Edition.Thanks

We have provided you the Hotel database to be used with SQLite DBMS. You should use this database in SQLite to extract the necessary information as per the following query requirements.

The sqlite script is based on the following relational schema:

•Hotel (hotelNo, hotelName, city)

• Room (roomNo, hotelNo, type, price)

• Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

•Guest (guestNo, guestName, guestAddress)

Note the following details of the hotel database;

•Hotel contains hotel details and hotelNo is the primary key;

•Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key;

•Booking contains details of bookings and (hotelNo,guestNo,dateFrom) forms the primary key;

•Guest contains guest details and guestNo is the primary key.

Write an SQLite script for querying data.

•List hotelNo, type and price of each double or deluxe room with a price more than $99.

•List hotelNo who have more than 2 double rooms.

•List number of different guests who visited Ridge Hotel.

•What is the total income from bookings for the Grosvenor Hotel? .

•List all the guests who have stayed in a hotel.

Task 3 [3 marks]

Perform the following tasks.

•Write commands to insert rows in each of the Hotel database tables .

•Write a command to delete the row you inserted in the table Guest .

•Write a command to update the price of all rooms by 10% (1 mark).

Identify a wealth creator and wealth destroyer on both stock and wealth destructor stock during 2000 to 2018.

In data normalization, the removal of partial dependencies is associated with the transition from ________.

Select one:

a. Poorly structured data to first normal form (1NF)

b. First normal form (1NF) to second normal form (2NF)

c. Second normal form (2NF) to third normal form (3NF)

d. Third normal form (3NF) to Boyce-Codd normal form (BCNF)

Although the idea of a foreign key is useful for conceptual data modeling purposes, it is not actually possible to implement a foreign key in a real-world DBMS.

Select one:

a. True

b. False

Compared to the non-normalized design from which it was derived, a normalized database design will typically contain ________ inter-table relationships.

Select one:

a. More

b. Fewer

c. An equal number of

d. Zero

All of the following anomalies EXCEPT ________ can arise when using a list to store data.

Select one:

a. Deletion problems

b. Update problems

c. Query problems

d. Insertion problems

A referential integrity constraint can be used to verify that the values of a column in one table are valid in light of the values of a column in another table

Select one:

a. True

b. False

Establishing a method for collecting rent each month will make it easier to keep track of the rent collection process. Choose the number of houses and rent per house by your choice. Develop a python program to maintain the rent collection process. Update the database with the details of every month like the name of the tenant, house number, month of the rent, rent amount, EB bill amount, maintenance charge, etc., Print the details of rent collection for all houses from January 2019 to December 2019. Also, print the details of the month in which the tenant has joined/vacated house wise.

Discuss how the UBS Inventory and Billing system could be beneficial to businesses in 2000 words.

Good marks will be awarded based on the relevant answers and examples provided where necessary into your discussion. In addition, your discussion should include the following:

• Appropriate citations and adequate scholarly research.
• Readability including proper organization of answers.
• Cover page (image form), mark sheet (image form), table of content (image form) proper heading/title for each part answered, list of references (Use APA referencing system)

This assignment refer to the “om” database (or Schema).     

1.Write an INSERT statement that adds this row to the Items table:  

a.       Artist:               Newly Added

b.       Title:                      Assignment 3

c.        unit_price:         0.0

d.       ID:                          12

2.       Write an UPDATE statement that modifies the row you just added to the Items table. This statement should change the artist column to “RockOn”, and it should use the ID column to identify the row.   

3.       Write a DELETE statement that deletes the row you added to the Items table in above queries. This statement should use the ID column to identify the row.  

4.       Write an INSERT statement that adds this row to the Customers table:   

a.       Customer_id:   26

b.       last_name:       Raven

c.       address:            XYZ

d.       City:                 town

e.       State:                ON

f.        ZIP:                  ABCD

g.       Phone:              987654321

5. Write an UPDATE statement that modifies the Customers table. Change the first_name column to “Rick” and last_name to “Fun” for the customer with Phone number: 987654321  

This assignment has you researching 2 specific databases (not EMR or EHR generic, but 2 actual specific databases). The most missed part of this assignment is the in-text citations in addition to your References (remember, for every reference you must have an in-text citation as well). References are required to give credit as to where you are getting your information from, but each Reference must have at least one in-text citation showing where you used that reference. If you are struggling to find a database you use, they are all around you. What do you use that requires a password to log in? Whatever you think of….it’s a database!

Many health care organizations and other businesses use database software to manage the flow of information and make important decisions.

This assignment requires Level 2 Writing Guidelines.

Assume you have been asked to serve on a project team for end-users of database software. Your current employer or a fictitious local medical office wants to use an electronic method to store demographic information (person’s name, address, contact information, insurance information, etc) as well as personal health history (clinical diagnosis, tests results, appointment notes, etc). This software needs to be accessible by all employees in the office. Research various database applications used in health care settings. Prepare a 1-2 page report to:

1.     Identify all of the types of information you would need related to patients (e.g. address, insurance information, test results, etc.)

2.     Research various health care database applications currently available. Select two to compare that may satisfy the medical office’s information management needs.

·         Describe how the two databases work and why they are used.

·         Your comparison should end with your assessment of which would work better for your facility.

At the end of your paper, provide complete references of all sources of information used in your paper.