Have a Question ?

Expert Answers

Search solutions for your assignments from our database.
We have 20+ millions solutions for question that will help you improve your grades

1

(Solved): CIS 355 Assignment 4 ...


Using the same subject area as you did for Assignment #3 (unless directed by your instructor to choose another subject area), you will create a star schema SQL Server model, with tables pasted as in Assignment 3, containing both types of factless fact tables, as discussed in the course lecture:

Case 1: business activity ("something happened”), but nothing to measure

Case 2: “conditions, coverage, or eligibility” – a “state of being” – but nothing to measure

If you had any points deducted for your dimension tables in Assignment #3, you will need to "fix" any issues for Assignment #4.

You will remove your transaction-grained fact tables from your model and replace them with factless fact tables, as described above.

You also may need to add a DATE/TIME-related dimension table if you didn't have one in Assignment #3; if you do, you can EITHER delete one of your Assignment 3 dimension tables and replace with DATE/TIME, or just add the new DATE/TIME one to the existing 3; your choice based on what makes sense for your model.

You will upload your PPTX (or PDF) deliverable that contains your model to this link before the due date/time.

GRADING RUBRIC:

25 points total: 9 points for dimension tables, 8 points for each of your faceless fact tables

  • Dimension tables: 3 points for each one (including DATE/TIME dimension; if you have 4 total, all 4 will factor into this portion of the grading), "all or nothing" correctness: 
    • surrogate key as primary key with correct data type and NOT NULL clause
    • correct PRIMARY KEY clause
    • no FOREIGN KEY clause or other syntax violations
  • Fact tables: 8 points for each, based on:
    • SQL syntax: 4 points, "all or nothing" including PRIMARY and FOREIGN KEY clauses/constraints; correct primary key designation; no facts/measurements, only keys; other syntax
    • Correct fact table usage: 4 points
      • For both fact tables: your dimensions are correctly and fully related to the business subject area that you selected - (example: if you were to do "SEASON TICKETS" then you must have one or more appropriate dimensions related to SEASON TICKETS  - in other words, you need to have more than just syntactically correct PK and FK columns, your model needs to "make sense")
      • "Business event with nothing to measure" must be correct and related to health care/hospital
      • "Coverage/eligiblity/'state of being'" must be correct and related to ASU ATHLETICS - make sure that your relation(s) to your date/time dimensions are syntactically and semantically correct

View Buy Answer $25 Sign In -- OR --

1

(Solved): Knowledge Check 1 | Managerial Economics (JWI515006JWONL-12...


Knowledge Check 1

Managerial Economics

(JWI515006JWONL-1224-001)

Attempt Score    4 out of 4 points  

QUESTION 1
GDP is expressed in inflation adjusted dollars.

  • True
  • False

0.4 points  

 
QUESTION 2
Which of the following statements in NOT true?
    A.    Raising the Interest rate decreases the rate of Inflation.
    B.    Lagging Indicators can predict the economy's future direction.
    C.    Perfect Competition involves many sellers offering similar goods.
    D.    Cost-push is one of the causes of Inflation.
0.4 points   


QUESTION 3
GDP calculation does not reflect depreciation of machinery and other capital assets. Therefore, it is considered to be a ______ measure.
    A.    Net
    B.    Nominal
    C.    Gross
    D.    Annual
    E.    Marginal
0.4 points   


QUESTION 4
The Federal Reserve regulates banks and enacts U.S. monetary policy.

  • True
  • False

0.4 points   


QUESTION 5
Decreasing the Interest Rate ...
    A.    Slows down the Rate of Inflation.
    B.    Makes it harder for consumers to borrow money.
    C.    Increases the flow of cash into the marketplace.
    D.    Makes it harder for businesses to borrow money.
0.4 points  

 
QUESTION 6
Which of the following is NOT a significant Indicator in Macroeconomics?
    A.    The Unemployment Rate.
    B.    The Gross Domestic Product.
    C.    Consumption of Goods and Services.
    D.    The Rate of Inflation.
0.4 points   


QUESTION 7
The Consumer Price Index (CPI) is reported once every quarter.

  • True
  • False

0.4 points   


QUESTION 8
A basket of goods bought by a typical consumer is used to ...
    A.    Calculate the Interest Rate.
    B.    Measure the Gross Domestic Product.
    C.    Calculate the Consumer Price Index.
    D.    Illustrate the law of Supply and Demand.
0.4 points   


QUESTION 9
Prior to policy changes due to COVID-19, to be counted in the Unemployment Rate, a person must ... 
    A.    Have given up trying to find employment.
    B.    Be less than the retirement age of 65 years old.
    C.    Have lost a job through involuntary layoffs.
    D.    Have been actively seeking a job for the past 4 weeks.
0.4 points   


QUESTION 10
The Federal Reserve (FED) sets the Interest Rate for the U.S.A. In this function, the Fed operates as a ...
    A.    Monopoly.
    B.    Coincident Indicator.
    C.    Regulating entity.
    D.    Market Structure.
 


View Buy Answer $10 Sign In -- OR --

1

(Solved): Business data analytics|jmp|tableau|excel|Create Pricing For...


Task: Create Pricing Formula for renting Airbnb in Chicago.

create a new column in the data where you do a formula that would calculate all the fees together and create a "cost per day" or something that could be used to determine the spectrum of cost for each rental from least to most expensive.

Hypothesis:  All areas have the same average cost?

USE DATA: Fees: (cleaning, minimum nights required, security deposit, cancellation fee)

  • Use JMP Pro Excel, and Tableau
  • Must perform some data cleaning (outlier analysis)
  • Test correlations between data variables
  • Perform appropriate statistical test (t-test, ANOVA, Regression, Cluster analysis)

 

 

Questions

Q1: Is the hypothesis true explain why in a few sentences.

Q2: Use tableau and show the areas with rentals from least to most expensive. Explain in your own words why they are expensive and why they are cheap.

Q3: If hypothesis is not true, explain why its not true in a few sentences.

 

 


View Buy Answer $30 Sign In -- OR --

1

(Solved): 202202 BUS278 21583 - Employment Law Chapter 12 Practice Te...


202202 BUS278 21583 - Employment Law

Chapter 12 Practice Test

Attempt 20 out of 20 points  

 

QUESTION 1

Can a state (such as Iowa or Michigan) pass legislation that contradicts ERISA law?          2 points  

  • Yes. Insurance and pensions are largely regulated by state laws.  ERISA is a federal law that supplements - not replaces - state laws.  Regardless if a state law is deemed to be "reasonable" and "fair" then a state may pass legislation that contradicts ERISA regulations.        
  • No. ERISA regulations may not be contradicted by state laws. ERISA preempts or supersedes any state law that attempts to contradict those plans covered by ERISA.

 

QUESTION 2

Which of the following is a qualifying event necessitating an offer of COBRA continuation coverage?     2 points          

  • an employee is reprimanded        
  • an employee leaves on vacation        
  • an employee adopts a child        
  • an employee quits his job

 

QUESTION 3

About ERISA, the Employee Retirement Income Security Act, it is correct to say that:        2 points        

  • the law governs only pension plans        
  • the law only applies to "welfare" plans         
  • the law governs benefit plans broadly, not just pension plans 

  

QUESTION 4

An employee whose wife suffered from breast cancer was terminated after a change of ownership of the company. He asked whether their health insurance would continue, and was told verbally that it would. Nine months later when his wife sought treatment, she was advised the policy had been terminated. He and his wife sued for a violation of COBRA. The court should rule: ?        2 points          

  • ?for the employer, since the employee never requested in writing that their insurance be continued        
  • ?for the employee, since he was not given notice of his COBRA rights in writing        
  • ?for the employee’s wife, because she was also an insured, but was given no notice of her COBRA rights        
  • ?for the employer, since it was a new owner, and not the employer of the employee.

 

QUESTION 5

The Affordable Care Act ("ObamaCare") was written so that the basic strategy for expanding health care coverage was to increase enrollment in        

  • Medicare.        
  • Medicaid.        
  • Social Security        
  • All the above are correct answers.

   

QUESTION 6

Defined benefit pension plans:                2 points  

  • promise a specific pension benefit upon retirement        
  • are not insured through the Pension Benefit Guaranty Corporation (PBGC)        
  • are less regulated pension plans        
  • require a specific contribution each pay period

 

QUESTION 7

Under ObamaCare (Affordable Care Act)        

  • health care plans are required to cover dependent children up to age 26 years.        
  • pre-existing conditions exclusions in health plans are prohibited.        
  • health care plans may not place a lifetime dollar benefit payable to a person.        
  • All the other answers are correct.

 

QUESTION 8

In Chapter 12 of the Walsh book (at the very end of the chapter) the author discusses wellness programs. These programs are often used as a way to keep group health insurance costs lower by improving employee health.  Which of the below statements is a correct overview of the author's views about such programs?          2 points          

  • He is a strong advocate of such programs and calls them a win-win situation.  He especially likes the fact that such wellness programs are pretty much free of any possible government laws or requirements as they are most always voluntary on the part of employees.  In short, the author sees no problems with such programs since better health can only lead to better results for everyone.        
  • The author appears to take a cautious approach to wellness programs.  He states such programs can violate HIPAA and PPACA nondiscrimination requirements since employees may be charged more for their health insurance coverage based on their health factors.  He points out that such programs, while certainly well intended, need to be carefully implemented by employers.

 

QUESTION 9

An employee would likely prefer this kind of pension plan:         

  • a hybrid plan         
  • a defined benefit plan         
  • a defined contribution plan

 

QUESTION 10

An employee is terminated for poor attendance. The employer sends a letter on May 1 notifying him of his right to receive continuation health insurance coverage.  The letter states that the former employee must respond by May 30 to be eligible for up to 6 months of continuation coverage.  The employer’s letter:        

  • should state that the employee has 60 days to decide on coverage that would last up to 18 months        
  • should state that the employee has 60 days to decide on coverage that would last up to 3 years        
  • should state that the employee has 45 days to decide on coverage that would last up to 3 years        
  • accurately states the former employee’s rights under COBRA

 

QUESTION

Which of the following is a qualifying event necessitating an offer of COBRA continuation coverage?                2 points  

  • an employee is reprimanded        
  • an employee leaves on vacation        
  • an employee adopts a child        
  • an employee quits his job

 

QUESTION 

The Affordable Care Act ("ObamaCare") was written so that the basic strategy for expanding health care coverage was to increase enrollment in          2 points

  • Medicare.        
  • Medicaid.        
  • Social Security        
  • All the above are correct answers.

 

QUESTION 

Which of the following is a qualifying event necessitating an offer of COBRA continuation coverage?        

  • an employee is reprimanded        
  • an employee leaves on vacation        
  • an employee adopts a child        
  • an employee quits his job

 

QUESTION 

In Chapter 12 of the Walsh book (at the very end of the chapter) the author discusses wellness programs. These programs are often used as a way to keep group health insurance costs lower by improving employee health.  Which of the below statements is a correct overview of the author's views about such programs?        

  • He is a strong advocate of such programs and calls them a win-win situation.  He especially likes the fact that such wellness programs are pretty much free of any possible government laws or requirements as they are most always voluntary on the part of employees.  In short, the author sees no problems with such programs since better health can only lead to better results for everyone.        
  • The author appears to take a cautious approach to wellness programs.  He states such programs can violate HIPAA and PPACA nondiscrimination requirements since employees may be charged more for their health insurance coverage based on their health factors.  He points out that such programs, while certainly well intended, need to be carefully implemented by employers.

 

QUESTION 

Wells Fargo lost the case of Harrison v Wells Fargo Bank (4th Cir 2014) (Pages 465-468 Walsh text). What was the main reason the employer lost this case?        

  • Wells Fargo did not meet the "full and fair review" requirements imposed by ERISA.  In other words, Wells Fargo did not engage in proper review of Nancy Harrison's case or properly obtain the necessary medical records to have a full understanding of her situation / case.        
  • It was proven that Wells Fargo had a systematic plan to automatically deny any person's claim for benefits until at least the second appeal level.  Once a case reached a second appeal then Wells Fargo would come up with a technical reason to deny the claim of most any claimant.  Nancy Harrison was just one of many, many employees Wells Fargo had treated this way.        
  • The U.S. Department of Justice got involved in this case - which it called a scheme - and prosecuted the employer for violating federal ERISA law.  The employer was ordered to make full restitution to all the victims of this scheme (including Nancy Harrison).        
  • All the other answers are correct.

 

QUESTION

In Chapter 12 of the Walsh book (at the very end of the chapter) the author discusses wellness programs. These programs are often used as a way to keep group health insurance costs lower by improving employee health.  Which of the below statements is a correct overview of the author's views about such programs?        

  • He is a strong advocate of such programs and calls them a win-win situation.  He especially likes the fact that such wellness programs are pretty much free of any possible government laws or requirements as they are most always voluntary on the part of employees.  In short, the author sees no problems with such programs since better health can only lead to better results for everyone.        
  • The author appears to take a cautious approach to wellness programs.  He states such programs can violate HIPAA and PPACA nondiscrimination requirements since employees may be charged more for their health insurance coverage based on their health factors.  He points out that such programs, while certainly well intended, need to be carefully implemented by employers.

 


View Buy Answer $10 Sign In -- OR --

1

(Solved): CIS 365 – Business Database Systems HW7.2 – Stored Proce...


CIS 365 – Business Database Systems
HW11.2 – Stored Procedure and Trigger (200 points)
This is an individual exercise, NOT a group assignment.


Calculate Adam McLean's final invoice bill for his family visit started on 2019-08-03. Adam McLean's guest ID is G5. The family visited FamCation once before in 2017. Make sure your calculation doesn't include their 2017 activities. Follow the steps below to complete this assignment.


View Buy Answer $50 Sign In -- OR --

1

(Solved): CIS 365 – Business Database Systems HW11.1 – View (50 po...


CIS 365 – Business Database Systems
HW11.1 – View (50 points)
This is an individual exercise, NOT a group assignment.


1. View and subquery (30 points)
Create a view named 'Top_Guide' listing guides who have led more than 10 reservations. The view will display guide ID, last name, hired date, and total count of reservations.
Use the created view to list all guests (first name and last name) who have made reservations with these top guides via a 'noncorrelated' subquery. Don't show duplicate guest names.
Show the following three query statements –
1. View creation (10 points)
2. The result of your view, Top_Guide. (10 points)
3. The query to list all guests led by these top Guides (10 points)


2. View and subquery (20 points)


Use the same Top_Guide view to find the manager of these top guides.
Due Date: 11/12 EOD Friday
• Take a screenshot of your query statement and result in MS SQL. Paste all queries/results in your Word doc. (SnagIt available in ASU software tool library is a good screen shot tool)
• Convert the entire document into one pdf file for submission.
• Save your file name as HW11.1 - Student Name.pdf.
• Submissions must be posted to Canvas to be graded.


View Buy Answer $15 Sign In -- OR --

1

(Solved): CIS355 Quiz #1 (2022)...


Quiz #1 

Points 40 

  • Questions 20 

Time Limit 75 Minutes

Score for this quiz: 40 out of 40

 

Question 1

2 / 2 pts

True or False: An “independent data mart” requires the existence of a data warehouse to provide data content.

  •   TrueCorrect!
  •   False

Question 2

2 / 2 pts

True or False: If you were to build a data warehouse today, you would use almost the exact same technology as if you had built a first-generation data warehouse back in the early 1990s.

  •   TrueCorrect!
  •   False

Question 3

2 / 2 pts

The “E” in “EDW” stands for:

  •   Error-free orrect!
  •   Enterprise
  •   Extended
  •   None of the answer selections

 

Question 4

2/ 2 pts

The primary difference between a CIF architecture and a Data Warehouse Dimensional Bus architecture is:

  •   The CIF has no data marts, only an EDW, while the DW Bus architecture has data martsYou Answered
  •   The DW Bus architecture has an “EDW” component that contains integrated data from all sources, while the CIF has only data marts
  •   The CIF architecture has an “EDW” component that contains integrated data from all sources, while the DW bus has only data marts
  •   The CIF and the DW Bus architectures are identical; there are no differences between the two

 

Question 5

2 / 2 pts

The “front-end data mart” architecture:u Answered

  •   Sends data from source applications and systems into an enterprise data warehouse, and then a subset of that enterprise data is extracted and sent to one or more data marts 
  •   Sends data from source applications into data marts, and then all data from all data marts is further sent downstream to an enterprise data warehouse
  •   Sends data from source applications directly into data marts, which are then “declared” to be an enterprise data warehouse even though the data marts are totally independent from one another
  •   None of the answer selections are correct

Question 6

2 / 2 pts

A persistent staging layer:

  •   Purges all of the staging layer data after the data has been successfully loaded into the data warehouse’s “performance layer”orrect!
  •   Retains data in the staging layer, even after the data has been successfully loaded into the data warehouse’s “performance layer”
  •   Is only used in data marts – never in an enterprise data warehouse
  •   None of the answer selections are correct

 

Question 7

2 / 2 pts

True or False: “Initial ETL” is the term used when you are first loading a brand new empty data warehouse with dataect!

  •   True 
  •   False

 

Question 8

2 / 2 pts

Which ETL pattern adds recently created data but also removes or deletes the oldest data from the data warehouse?

  •   Complete replacement
  •   AppendCorrect!
  •   Rolling append
  •   In-place update

Question 9

2 / 2 pts

True or False: You are required to use the same ETL pattern (e.g., in-place update, append, etc.) on all database tables within your data warehouse; you are not permitted to “mix and match” on the same incremental ETL job.orrect!

  •   False 
  •   True

Question 10

2 / 2 pts

Suppose that you are bringing in customer data from one application that has the customer’s last name stored as “CHAR (30)” and the customer’s first name stored as CHAR (20)” – and then you are also bringing in customer data from another application that has the customer’s last name stored as “CHAR (35)” and the customer’s first name stored as CHAR (25).”

Which of the following statements is most true?

  •   You will store the customer data in the performance layer of the data warehouse with the same data types and sizes as in the respective sources, which means that some customer data will have the last name stored as CHAR (30) and other customer data will have the last name stored as CHAR (35). You Answered
  •   You will use the “data value substitution” transformation pattern to store all customer with the same data types/sizes for the last name and first name in each database row 
  •   You aren’t permitted to bring customer data with different types and sizes into the data warehouse; you instead would contact the application maintenance team for one of the two systems and have them make changes to how they store their customer data
  •   None of the answer selections are true

Question 11

2 / 2 pts

If you have two identical applications running in different parts of your company – for example, one payroll system for your western region, and the same payroll system software for your eastern region – which of the following ETL transformation models would you most likely use to bring the payroll data together in the data warehouse?

  •   Dropping columns
  •   Value-based row filteringCorrect!
  •   Source data merging 
  •   None of the answer selections are true

 

 

Question 12

2 / 2 pts

True or False: Address matching and standardization is a valuable ETL transformation model to ensure that you don’t have unwanted duplicate customer data in your data warehouse.

  •   TrueCorrect!
  •   False

 

Question 13

2 / 2 pts

A federated data warehouse architecture:You Answered

  •   Is highly centralized and monolithic in nature 
  •   Is made up of a collection of dependent data marts
  •   Is made up of a collection of independent data marts
  •   None of the answer selections are true

Question 14

2 / 2 pts

True or False: “Data warehouse” and “data virtualization” mean the same thing, and can be used interchangeably.

  •   TrueCorrect!
  •   False

Question 15

2 / 2 pts

True or False: You will never find a relational database management system (e.g., Microsoft SQL Server) being used for a data warehouse’s platform.

  •   TrueCorrect!
  •   False

Question 16

2 / 2 pts

True or False: An advantage of a non-persistent staging layer is that if a data warehouse performance layer “blows up” you can try to reconstruct the data warehouse’s contents from within the data warehouse, rather than having to reacquire all data from its original source applications.

  •   Trueorrect!
  •   False

Question 17

2 / 2 pts

“ETL” stands for:

  •   Extraction, Targeting, and Loading 
  •   Engineering, Transformation, and Loading
  •   Engineering, Targeting, and LayoutCorrect!
  •   None of the answer selections are correct

Question 18

2 / 2 pts

Which of the following “tell me…” types of business intelligence is not considered to fall under the “data mining” grouping?

  •   Tell me what is likely to happenorrect!
  •   Tell me what happened
  •   Tell me what might have happened if we had done something differently
  •   Tell me something interesting and important
  •   All of the above fall under “data mining”

Question 19

2 / 2 pts

True or False: The modern era of business intelligence began a decade before the modern era of data warehousing.ou Answered

  •   True
  •   False

Question 20

2 / 2 pts

Which of the following is not one of the original 4 “Inmon rules” for data warehousing?

  •   Subject-oriented 
  •   Non-volatile 
  •   Time-variant 
  •   Integrated
  •   All of the above are “Inmon rules”

 

 


View Buy Answer $15 Sign In -- OR --

1

(Solved): Assignment 02 – Due on 02/16/22, 11.59pm...


Assignment 02 – Due on 02/16/22, 11.59pm

ii) SQL Practice

Import the My Guitar Shop database into MySQL workbench using attached create_my_guitar_shop.sql file for answering these questions. The expected output file is also attached (HWK2 – Expected Output.pdf). Write the following queries in a single sql file. You must submit the .sql file named hwk02-part-ii-lastname.sql (Example hwk02-part-ii-kumar.sql) for this section.
All answers must be formatted for easy comprehension. MySQL Workbench has a format command (Edit -> Format -> Beautify Query).


1. Write a SELECT statement that returns four columns from the Products table: product_code, product_name, list_price, and discount_percent. Then, run this statement to make sure it works correctly.

Add an ORDER BY clause to this statement that sorts the result set by list price in descending sequence. Then, run this statement again to make sure it works correctly. This is a good way to build and test a statement, one clause at a time.

Only submit the final query including the ORDER BY clause.


2. Write a SELECT statement that returns one column from the Customers table named full_name that joins the last_name and first_name columns.

Format this column with the last name, a comma, a space, and the first

name like this: Doe, John

Sort the result set by last name in ascending sequence.

Return only the customers whose last name begins with letters from M to Z.

NOTE: When comparing strings of characters, ‘M’ comes before any string of characters that begins with ‘M’. For example, ‘M’ comes before ‘Murach’.


3. Write a SELECT statement that returns these columns from the Products table:

product_name       The product_name column
list_price               The list_price column
date_added           The date_added column

Return only the rows with a list price that’s greater than 500 and less than 2000.

Sort the result set in descending sequence by the date_added column.


4. Write a SELECT statement that returns these columns from the Orders table:

order_id         The order_id column
order_date     The order_date column
ship_date       The ship_date column

Return only the rows where the ship_date column contains a null value. (Hint: use IS NULL)


5. Write a SELECT statement that joins the Categories table to the Products table and returns these columns: category_name, product_name, list_price.

Sort the result set by category_name and then by product_name in ascending sequence.


6. Write a SELECT statement that joins the Customers table to the Addresses table and returns these columns: first_name, last_name, line1, city, state, zip_code.

Return one row for each customer, but only return addresses that are the shipping address for a customer.


7. Write a SELECT statement that joins the Customers, Orders, Order_Items, and Products tables. This statement should return these columns: last_name, first_name, order_date, product_name, item_price, discount_amount, and quantity.

Must use aliases for the tables to get full credit. Sort the final result set by last_name, order_date, and product_name.

 

 

 

 


View Buy Answer $15 Sign In -- OR --

1

(Solved): CNE400 : Writing Assignment #10...


CNE400: Writing Assignment #10

 

It is now five years from when you graduated.  You have, like most of your peers, been appointed to a management position in your organization (whether governmental, private industry, or NGO).  Write a one-page op-ed for your local newspaper talking about what you wish you’d learned in university, and offering a few ideas about what your professors could have taught you that would have been more useful. No references required for this paper.


View Buy Answer $15 Sign In -- OR --

1

(Solved): CNE 400 Writing Assignment #9...


CNE 400: Writing Assignment #9

 

 

One page essay on how science fiction impacts and shapes the development of future technologies, using Old Man’s War as an example.


View Buy Answer $15 Sign In -- OR --

Showing Page 1 of 154 Pages