For Hospital-Based Care

Describe the types of care provided.

Identify the national organization(s) and the healthcare standards for the setting.

Identify your home state for state specific information

Summarize the state specific health record (i.e., medical record) documentation guidelines for the healthcare setting, including the statute, regulation and administrative code reference number.

Summarize the state specific health record (i.e., medical record) retention guidelines for the health care setting, including the statute, regulation and administrative code reference number.

Summarize the documentation requirements from The Joint Commission, including the standard and section (only for hospital-based care).

Describe the reimbursement method for the healthcare setting.

Describe a minimum of two coding or classifications systems utilized.

Summarize at least one commonly reported database associated with the health care setting.

Indicate whether the following research sampling methods are convenience samples or random samples: I select 150 students from my local university for a study on stress among college students. I randomly assign 25 persons from my place of work to a control group and 25 to an experimental group for a study on workplace satisfaction. Using a random number generator, I select a minimum sample size study population of male U.S. citizens with a passport from a passport database obtained from the U.S. State Department. I survey all certified public high school teachers in the city of Chicago, Illinois. I administer a rapid HIV antibody test to the first 50 consenting adults older than age 18 who stop by my booth at the health fair.

Q1.Generate an ERD diagram for the following scenario using Lucidchart. I need to know what the diagram should look like.

(I am not sure there should be any kind of relationship between entities.)

Scenario: Southlands Electric

Southlands Electric wishes to create a database with the following information:

Customer with attributes Customer ID, Name, Address (Street, City, State, Zip Code), and Telephone
Location with attributes Location ID, Address (Street, City, State, Zip Code), and Type (values of Business or Residential)
Rate with attributes Rate Class and RatePerKWH
After interviews with the owners, you have come up with the following business rules:

Customers can have one or more locations
Each location can have one or more rates, depending on the time of day

1. Suppose you are a project manager using waterfall approach on a large and complex project. Your manager has just read the latest article in Computerworld that advocates replacing waterfall with Extreme Programming (EP) and comes to your office requesting you to switch. What would you say?

2. Imagine you were an analyst developing a new EIS (Executive Information System) intended to provide key strategic information from existing corporate database to senior executives to help in their decision making. What methodology would you use and why?

3 .Think about your analyst position. Write a newspaper ads to hire someone for that position. What skill and experience would be required ? How would the applicants demonstrate that they have the appropriate skill and experience ?

1. Which of the following best description of ERP system?

Select one: a. It enables company to provide services and conduct marketing activities online b. It is a combination of hardware and software system to prevent unauthorized system access c. It involves the computer-to-computer exchange of business documents in electronic form between organizations d. It is a modular software system that enables organizations to integrate their business processes using a single operating database

2.

Which of the following is a risk source that will likely cause the greatest concerns from auditor during a risk-based audit?

Select one:

a. Increased transaction volume

b. Newly developed logistics and supplier system

c. New orders from existing customers

d. Increased dollars processed in accounts payable

A study entitled "Antidepressant Medication and Breast Cancer Risk" (Amer. J. of Epi, late 1990's) stated in the methods section of the paper that "Cases were an age-stratified (< 50 and ≥ 50 years of age) random sample of women aged 25-74 years diagnosed with primary breast cancer during 1995 and 1996 (pathology report confirmed) and recorded in the population-based Ontario Cancer Registry. As the 1-year survival for breast cancer is 90%, surrogate respondents were not used. Population controls, aged 25-74 years, were randomly sampled from the property assessment rolls of the Ontario Ministry of Finance; this database includes all home owners and tenants and lists age, sex, and address."

Question: Discuss the authors' approach to the identification of cases with respect to the potential for selection bias.

This assignment focuses on:

CO3:   Demonstrate effective written and technological communication (PO 4, PO 6)

CO4:   Apply scholarly evidence to nursing care (PO 1, PO3)

Key Concepts:

Synthesizing current evidence

Evidence Based Practice

CO7:   Demonstrate electronic database search strategies to obtain scholarly evidence (PO3)

Key Concept:

Scholarly Resource Analysis

1. What area of nursing are you interested in? And why? Reflective of your research, is there a need for more nurses in your area of interest?
2. Describe the importance of evidence-based practice. How do nurses in your area of interest use evidence-based practice? Give two examples.
3. Describe the impact that your example of evidence-based practice has on patient care, nursing practice, and patient outcomes.

5. Write the SQL query that accomplishes the task in the ZAGI Retail Company Sales Department Database:

5.1.3. Display the CustomerName and CustomerZip for all customers, sort alphabetically by CustomerName.

5.1.4. Display the RegionID of regions where we have stores (use only table STORES and do not display the same information more than once).

5.1.5 Display all the information for all stores whose ReigionID value is C

5.1.8 Display the ProductID, ProductName, ProductPrice, and VendorName for all products. Sort the results by ProductID.

5.1.10 Display the ProductID, ProductName, and ProductPrice for products in the category whose CategoryName value is Camping. Sort the results by ProductID.

5.1.11 Display the ProductID, ProductName, and ProductPrice for products that were sold in the zip code 60600. Sort the results by ProductID

Listed below are system development activities. Identify the stage of the system development life cycle that each activity belongs to

SYSTEM DEVELOPMENT ACTIVITIY

SDLC STAGE

1. Create the data dictionary for the system.

2. For each table in the database, identify the primary key.

3. While the system is in operation, change the frequency of output of the sales report. The report was output weekly. It is now changed to daily output.

4. Create the Level 0 DFD based on the content DFD.

5. Interview the client to find out how is a customer’s order processed.

6. Convert the flowchart into source code for a process.    

7. Conduct meetings with clients to decide what should be the layout of the invoice.

8. Conduct the present value analysis to determine if the system development should be proceeded.

1. Determine the length of a data element.

10. Decide how frequent should an expenditure report be generated.

-

Business intelligence can detect fraudlant practise in finance, banking, Insurance etc

Select one:

a. True

b. False

2-

A spreadsheet is a computer application for organization, analysis and storage of data in tabular form.

Select one:

a. True

b. False

3-

Business Intelligence system is used by higher level of management in strategic decision making.

Select one:

a. True

b. False

4-

Which of the following is not a type of information system?

Select one:

a. Management Information System

b. Transaction Processing system

c. Operating System

d. Decision support system

5-

During extraction, the desired data is identified and extracted from many different sources, including

Select one:

a. Database systems and applications

b. Business and operating systems

c. Operating system and Application