Computer science

1. Answer the following questions based on the 'customer' table below. Remember to observe proper formatting practice if asked to write queries . And remember, if asked to show actual query output, to include all elements that would be shown.

2. Assume that the queries should be written for SQLite:

3.

4. Write a query to display the name of the company, the city, and postal code for our customers in Spain and the UK that do not operate in London or in Madrid.

2 points

1. Answer the following questions based on the 'customer' table below. Remember to observe proper formatting practice if asked to write queries . And remember, if asked to show actual query output, to include all elements that would be shown.

2. Assume that the queries should be written for SQLite:

3.

4. Please create the output table for the following query*:

5. SELECT DISTINCT Country FROM customer;

6.

7. *If you do not see the option to create a table, click on the double arrows on the corner of the text field to expand the text options.

2 points

1. Answer the following questions based on the 'customer' table below. Remember to observe proper formatting practice if asked to write queries . And remember, if asked to show actual query output, to include all elements that would be shown.

2. Assume that the queries should be written for SQLite:

3.

4. Write a query to display the contact name, company name, and cities for customers in Denmark, Sweden, Germany, France, and Poland.

2 points

1. Answer the following questions based on the 'customer' table below. Remember to observe proper formatting practice if asked to write queries . And remember, if asked to show actual query output, to include all elements that would be shown.

2. Assume that the queries should be written for SQLite:

3.

4. Write a query to display the total number of customers that we have in each country. Make sure to rename the output column names to enhance readibility.

2 points

1. Answer the following questions based on the 'customer' table below. Remember to observe proper formatting practice if asked to write queries . And remember, if asked to show actual query output, to include all elements that would be shown.

2. Assume that the queries should be written for SQLite:

3.

4. Please describe the output from the following query*:

5. SELECT CustomerID, ContactName, City, Country

6. FROM customer

7. WHERE Country = 'UK' AND City = 'Cardiff';

8.

9. *There is no need to create a table. Just offer a description of the output.

2 points

1. Which of the following items are foundational concepts of Information Security?

2 points

1. A firm shuts down its old COBOL legacy system and immediately starts up its new PeopleSoft ERP system. This process is called __________ conversion.

2 points

1. Which of the following systems acquisition methods saves the company’s time and enables the company to own software that has been used for similar problems in other organizations?

2 points

1. Business processes define:

2 points

1. A Denial of Service (DoS) and/or Distributed Denial of Service (DDos) attack ____________

2 points

1. Match the phase of the Systems Development Life Cycle with the correct phase number, according to the textbook and class discussion.

2 points

1. What are the official "Three V's" of Big Data?

2 points

1. The waterfall methodology is:

2 points

1. A firm implements a new information system in one of its plants, assesses the new system’s performance, and then implements the new system in its other plants. This is an example of __________ conversion.

2 points

1. To increase throughput or improve service levels it is often desirable to replace ___________ process(es) with ___________ process(es).

2 points

1. ______ determine(s) whether to pass each part of a message by examining its source address, destination address, and other related data.

2 points

1. _____ feasibility analysis addresses the human issues of an information systems project.

2 points

1. A small business receives travel reimbursements from their employees. The process starts when the travel manager receives a reimbursement request via email. Then, she checks to see if all the required information has been entered. If it has not, she contacts the employee to receive missing information to complete the process. Next, she allocates funds from and transfers them to the employee’s payroll account. Finally, she sends an email to the employee stating that their reimbursement has been processed.

2. In the business process described above how many activities are there?

2 points

1. A small business receives travel reimbursements from their employees. The process starts when the travel manager receives a reimbursement request via email. Then, she checks to see if all the required information has been entered. If it has not, she contacts the employee to receive missing information to complete the process. Next, she allocates funds from and transfers them to the employee’s payroll account. Finally, she sends an email to the employee stating that their reimbursement has been processed.

2. In the business process described above how many decisions/gateways are there?

2 points

1. A small business receives travel reimbursements from their employees. The process starts when the travel manager receives a reimbursement request via email. Then, she checks to see if all the required information has been entered. If it has not, she contacts the employee to receive missing information to complete the process. Next, she allocates funds from and transfers them to the employee’s payroll account. Finally, she sends an email to the employee stating that their reimbursement has been processed.

2. Which of the diagrams below accurately represent this business process?

2 points

1. Just-in-time (JIT) is:

2 points

1. In the _________, the production process begins with a customer order.

2 points

1. Which of the following is an information systems application used in sales and marketing?

2 points

1. Given this Python script:

2.

3. What is the result in the Python Interpreter (IDLE) when this is run?

2 points

1. The scope of a supply chain management (SCM) project/system is _________.

2 points

1. The following statement has already been executed:

2.

3.

4. Given this, what is the output from this statement:

5.

2 points

1. What is the difference between SCM and CRM?

2 points

1. E-commerce businesses dealing with sales between a supplier and a retail consumer are:

2 points

1. Which of the following arithmetic operators in Python performs division on two operands where the result is a quotient that has had the floating point numbers removed?

2 points

1. Given this Python script:

2.

3. How many times does this loop execute when this is run?

2 points

1. The single largest form of E-commerce, in terms of capital, is _________?

2 points

1. The elimation of the middle layers of the supply chain is called _________.

2 points

1. The phenomenon in which the variability in the size and timing of orders increases at each stage of the supply chain is known as the _________ effect.

2 points

1. _________ read data from a variety of sources, process that data, and produce and deliver formatted reports to users.

2 points

1. Because of a phenomenon called (the) _________, the more attributes there are, the easier it is the build a model that fits the sample data. However, this model is generally worthless as an actual predictor.

2 points

1. Sometimes, large organizations break out _________ from their data warehouses so they can be used for a specific functional area of the organization (like marketing or finance).

2 points

1. Business transactions that are processed as they occur is an example of

2 points

1. All of the following observations concerning a data mart are true except:

2 points

1. Which of the following is an example of a question that data mining will help address?

2 points

1. Which of the following knowledge management systems is designed to store human knowledge in the form of IF-THEN rules?

2 points

1. One common unsupervised data mining technique is:

2 points

1. Regression analysis is an example of _________.

2 points

1. A(n) _________ provides rapid access to timely information and direct access to management reports.

2 points

1. _________ is the process of creating value from organizational intellectual capital and sharing this knowledge with employees, managers, suppliers, customers, and others who may need it.

2 points

1. In the case of online analytical processing, the presentation of a measure with associated dimensions is referred to as an ________.

2 points

1. Your manager stopped by your cube today and said the following:

2. "I know we do most all of our business in the US and Germany, but we need to extend our reach. Can you put together a few reports for me?

3. I need to plan trips to the stores in the countries where we do the most business outside of the US and Germany.

4. Can you put together a report for me that shows the countries where we do business in terms of both quantity of orders and dollars sold? From that list, make a recommendation on which country you think I should visit.

5. Once you've done that, put together another report showing the stores that buy from us in that country, the top product types sold in those stores, and revenues from those product types over the last few years. From that report, make a recommendation on who I should visit and why."

6. Download the attached file (BI_Raw_Data_Final.xlsx) to create the reports for your manager. Create the two requested reports using PivotTables. In a cell off to the side of each of your PivotTables, write the requested recommendations to your manager. There should be two (2) tabs in your sheet, in addition to the raw data. Save your work in Excel and upload your file as your solution to this exam question.