Expert Answers

CNE 400: Assessment #2: Dubai Case Study

For the case study, students will prepare an assessment of between 1100 and 1200 words of text, 1.5 spaced. Each case study should have a separate bibliography including at least 2 references beyond lecture material, using APA format. Bibliography does not count towards word count.  Each assessment should have:

1. Title
2. Topic sentence (a single sentence or two which summarize the student’s understanding of the situation, the actions taken by the consulting engineer, and lessons learned)
3. Situation assessment (What was the factual situation on the ground? What were the main challenges? What role could, and should, the consulting engineer play? What ESEM principles are present?)
4. Lessons learned (this should include not just the lessons learned by the consulting engineer as expressed in the case study, but the lessons learned by the student looking at the case study as a whole)

CNE 400:Writing Assignment #6

Due by 4:30 PM

What assumptions around the way technology and humans relate to each other are embedded in The Matrix?  Do you agree with them or not?  Justify your answer.

CNE400: Writing Assignment #5

Due by 4:30 PM

Pick an ESEM principle and write a one page essay on it applying it to one of the topics covered in class to date. 

CNE 400: Writing Assignment #4

Due by 4:30 PM

One page essay on the definition of technology, taking into consideration the relationship of technology to culture and human interaction with the physical environment. 

CNE 400

Writing Assignment #3

Due by 4:30 PM

One page essay answering the question: what is the difference between science and faith, using environmental science as the example.  The last paragraph should explain why understanding this difference is important to ESEM. 

CIS 355
Data Warehousing and Dimensional Modeling
Spring 2022
Assignment #1 – 25 Points

See Canvas and/or course schedule for due date/time
Situation:
You work for a retail company that has stores and operations across Arizona and California. Currently your company has no data warehouses, data marts, operational data stores, or any other integrated stores of data used for reporting, BI, and analytics. Your company also has an Internet presence with a website from which customers can purchase products.

For purposes of this assignment, you are interested in the following seven applications:

1. Supply Chain Operations, Arizona Region – this application manages all supply chain functions for the company’s Arizona Region. The functions
managed by this application include materials and inventory management; vendor management; materials ordering and defective material return; shipping and logistics; warehouse management; etc.

2. Supply Chain Operations, California Region – this application is identical to the Supply Chain/Arizona Region application described above, except that
it performs the supply chain functions for all of California. 

3. Customer Relationship Master System, California Region – this application contains a master list of all of the company’s customers who live in the California Region. For each customer we also a complete sales history, the names of their top officers and key employees, and other important information that gives us a complete picture of “everything we need to know” about that customer.

4. Customer Relationship Master System, Arizona Region – this application is identical to the one described above, except that it contains the
aforementioned information about all of the company’s customers who live in provinces and territories that are included in the Arizona Region.

5. In-Store Sales System, California Region – Each of the company’s stores has a point-of-sale (POS) system that handles all product purchases, payments, returns, and refunds. All of the stores in the company’s California Region feed data daily from each POS system to a centralized In-Store Sales System for the entire California Region, which summarizes all sales within the California Region and also maintains a history of past sales as well.

6. In-Store Sales System, Arizona Region – This application is identical to the one described above, except that it consolidates and organizes sales data
from all of our stores in the Arizona Region.

7. Online Sales System, Arizona and California (combined) – This application handles all Internet sales for all customers regardless of where they live in Arizona or California, and is a separate sales system than either of the in-store sales systems described above. (For purposes of this assignment, assume that only California and Arizona residents can purchase products online.)

_____________________________

Question #1 (15 Points)
For the scenario described above, draw the high-level architecture from the listed source systems through data marts for an enterprise data warehousing
environment that follows the Corporate Information Factory (CIF) architecture approach. Make sure you clearly show your ETL and data delivery data flows from each source to each target. You will decide which specific data marts your environment will include.

After you draw your diagram, you will then:

• List and describe at least two (2) very specific advantages of the CIF approach for enterprise-scale data warehousing for this company, versus the federated approach (not generalities about data warehousing benefits, etc.)

• List and describe at least two (2) very specific challenges/disadvantages of the CIF approach for enterprise-scale data warehousing for this company versus the federated approach (not generalities about data warehousing challenges, etc.)

Question #2 (15 points)
Now presume that your company’s Chief Information Officer (CIO) is a strong believer in smaller-scale efforts rather than large, enterprise-intensive ones such as CIF or the Dimensional Data Warehouse Bus Architecture. The CIO directs you to define the architecture for a Federated Enterprise Data Warehouse comprised of multiple independent data marts.

Draw the high-level architecture from the source systems listed at the beginning of this assignment through the data marts for a Federated EDW. Make sure you clearly  show your ETL data flows from each source to each target. You will decide which specific data marts your environment will include. (Hint: for this question and also for Question #1, defining the data marts might be trickier than you think!)

After you draw your diagram, you will then:

• List and describe at least two (2) very specific advantages of the Federated EDW approach for enterprise-scale data warehousing for this company versus the CIF approach (not generalities about data warehousing challenges, etc.)

• List and describe at least two (2) very specific challenges/disadvantages of the Federated EDW approach for enterprise-scale data warehousing for this
company versus the CIF approach (not generalities about data warehousing challenges, etc.)

Submission Format
Your choice: for example, a Microsoft Word document with your diagrams prepared in PowerPoint and then pasted into your Word document. Or you may use any other software as well. If you use anything other than Microsoft Word and/or PowerPoint, save your file as a PDF and upload your PDF.

ABCC - Quiz | Chapter 8 Knowledge Check

CIS 365 – Business Database Systems
HW9.2 – Advanced DML (75 points)
This is an individual exercise, NOT a group assignment.

1. Show all the guests stays in 2019 who didn’t reserve any activities. The result will show the guest ID, first name, last name, and reservation ID (should be Null). (15 points)

2. Show all the guide's full name, hired date, their manager’s full name, manager’s hired date, and personnel type. (15 points)

3. Display Condos in building A that have more expensive weekly fee than the average of all condos in FamCation. Display Condo ID, Weekly Fee, and Average Weekly Fee in the query result. Label the average fee as "Average Weekly Fee" and only display 2 significant digits. (15 points)

4. Use the UNION clause to list the highest weekly fee for building A, lowest weekly fee for B, and average weekly fee for C. Display the "Category" (Highest Weekly Fee, Lowest Weekly Fee, Average Weekly Fee), "Building number" and "Weekly fee" as showed below. The result is sorted by building number. (15 points)

5. Recreate a new_Condo_A table by inserting all building A records from the Condo table. Write a CASE statement to change the weeklyfee in New_Condo_A by adding 15% weeklyfee to condos with 3 bedrooms, 10% to condos with 2 bedrooms, and 5% to condos with 1 bedroom. Display the query result BEFORE the change and AFTER the changes. Show all the attributes in New_Condo_A. (15 points)

Due Date: EOD Thursday 11/4
• 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 screenshot tool)
• Convert the entire document into one pdf file for submission.
• Save your file name as HW9.2-Student Name.pdf.
• Submissions must be posted to Canvas to be graded.

CIS 365 – Business Database Systems
HW9.1 – Advanced DML (70 points)

How to put comments in your homework submission -

1. Display Condo id, building number, booking id, and booking start date in year 2020. (10 points)

2. Show all building C condos cleaned in August 2019. Display the condo ID, date cleaned, housekeeper’s first and last name. Display and label the first name and last name together in one column as Housekeeper. (10 points)

3. Display guides who didn't renew their certificates within 2 years. List their ID, first name, last name, certificate date, and renew date. (10 points)
4. Show guides who have led more than 8 reservations. Display guide id, last name, hire date, the number of reservations (label as "Reservations per Guide"). The highest count will be displayed first. (10 points)
5. Display the guest id, guest first name and last name, booking start date, and condo id. Label the 'Guest Name' and order the result by guest ID and then start date. (15 Points)
6. Count the number of girls and boys in each age group. The result will show age group, relationship, and count number. All the girls will be listed first, and then boys. Within each boy and girl group, order the age from the youngest to the oldest. (15 points).
Due Date: EOD Thursday 10/28
• 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 HW9.1-Student Name.pdf.
• Submissions must be posted to Canvas to be graded.

CIS 105 Boolean Functions Practice Problem