Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

Assignment # 5

Databases:

Q1: What is the difference between a database and a database management system?

Q2: What are the advantages and disadvantages of object-oriented databases?    

Q3: What is SQL?  In which database model does it operate?  Why is it so popular?    

Q4: What is a data warehouse?   How is it different from a transactional or relational database?   

Q5: What are the phases of adding data to a data warehouse?  

SQL Filtering:

IMPORTANT INSTRUCTIONS: For each query below, please copy and paste your queries into the word document and answer the question.  For example, if the question asks “How many products do we have?”  Your answer should state:  “109 products:  SELECT * FROM products”.  You do NOT need to submit screenshots of your queries, just copy and paste your query into a word document and save it as a PDF. 

Q1.  What unique statuses do we have for sales orders?  

Q2. How many sales transactions were canceled?   Create a list.

Q3. How many transactions were canceled that are over $3000 in sales?  Create a list.

Q4. How many transactions over $3000 are for items that cost between 80 and 100?  Create a list.

Q5. How many transactions were canceled or on hold for orders over $3000 and items that cost between 80 and 100?  Create a list.

Q6.  How many unique orders were canceled that had sales over $3000 on any transaction? Create a list.

Weather.com Case:  (Case on Classes):

Omit:  Do not worry about reading the sections titled “The Outsider App Development Team” and “The Outsider App Development Methodology” on pgs 6-7 for this case.  We will not be discussing those (but will be discussing app development methodologies after Exam # 1).  

Discussion Questions:

1. Now that public weather datasets were becoming available, how would TWC be able to maintain its competitive advantage with its weather-centric running app?   How exclusive was the weather content?  As well as location and weather, what other data could TWC incorporate into the Outsider app to make it the go-to running app and a source of premium advertising revenue?

2. How exactly does the Weather Channel strive to provide best in class weather information?  What sources of information does it use besides the data National Weather Service?  How is this data stored and analyzed?

3. Should The Weather Company expend its efforts developing consumer apps, or should it focus on its professional services division, offering weather and biometeorological analytics to its business customers?  Could they effectively do both?