Complete problem 2.1 #54. Record a video explain this problem as if you were teaching/explaining the process to a student.
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp
Order Paper Now
Please see below and answer with a minimum of 150 words and use references.
Discuss the relationship between data redundancy and normalization. What are the consequences if databases are not normalized? What problems is normalization addressing? Why is normalization crucial for effective database design and development?
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp
Order Paper Now
Search Engines are monster sized databases. They are not normalized by any means or are they? Explain how you believe a company such as Google or Microsoft can improve their search technology by starting with improving their database.
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp
Order Paper Now
Read the ModMeters Case Study on pages 82-85 in the textbook. Answer the Discussion Question at the end of the Case Study. Your responses must be complete, detailed and in APA format. See the sample assignment for expected format and length. The grading rubric is included below.*Case study paper must be completed in APA style format
Question is
Develop an IT planning process for ModMeters to accomplish the demands as set
out above.
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp
Order Paper Now
A murder in a downtown office building has been widely publicized. You’re a police detective and receive a phone call from a computer forensics investigator employed by the police department. His name is Gary Owens, and he says he has information that might relate to the murder case. Gary says he ran across a few files while investigating another case at a company in the same building. Considering the plain view doctrine, what procedures might you and he, as public officials have to follow? Write a one-page paper detailing what you might do.
No journal or book references, only websites, such as www.google.com as references.
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp
Order Paper Now
This assignment will test your understanding of conditional logic, views, ranking and windowing functions, and transactions, as shown in the videos. The prompt includes 10 questions.
You will need to create your own test database and tables using the criteria below. Please submit your answers using only one file. The preferable format is a text file with a .sql extension. You can easily edit the file using a text editor such as Notepad ++, which is available online for free.
Prompt: A manufacturing company’s data warehouse contains the following tables.
Region
region_id (p)
region_name
super_region_id (f)
101
North America
102
USA
101
103
Canada
101
104
USA-Northeast
102
105
USA-Southeast
102
106
USA-West
102
107
Mexico
101
Note: (p) = “primary key” and (f) = “foreign key”. They are not part of the column names.
Product
product_id (p)
product_name
1256
Gear – Large
4437
Gear – Small
5567
Crankshaft
7684
Sprocket
Sales_Totals
product_id (p)(f)
region_id (p)(f)
year (p)
month (p)
sales
1256
104
2020
1
1000
4437
105
2020
2
1200
7684
106
2020
3
800
1256
103
2020
4
2200
4437
107
2020
5
1700
7684
104
2020
6
750
1256
104
2020
7
1100
4437
105
2020
8
1050
7684
106
2020
9
600
1256
103
2020
10
1900
4437
107
2020
11
1500
7684
104
2020
12
900
Answer the following questions using the above tables/data:
tot_sales_large_gearstot_sales_small_gearstot_sales_crankshaftstot_sales_sprockets6200545003050
3. Write a query that retrieves all columns from the Sales_Totals table, along with a column called sales_rank which assigns a ranking to each row based on the value of the Sales column in descending order.
4. Write a query that retrieves all columns from the Sales_Totals table, along with a column called product_sales_rank which assigns a ranking to each row based on the value of the Sales column in descending order, with a separate set of rankings for each product.
5. Expand on the query from question #4 by adding logic to return only those rows with a product_sales_rank of 1 or 2.
6. Write a set of SQL statements which will add a row to the Region table for Europe, and then add a row to the Sales_Total table for the Europe region and the Sprocket product (product_id = 7684) for October 2020, with a sales total of $1,500. You can assign any value to the region_id column, as long as it is unique to the Region table. The statements should be executed as a single unit of work. Please note that since the statements are executed as a single unit of work, additional code is needed.
7. Write a statement to create a view called Product_Sales_Totals which will group sales data by product and year. Columns should include product_id, year, product_sales, and gear_sales, which will contain the total sales for the “Gear – Large” and “Gear Small” products (should be generated by an expression, and it is OK to use the product_id values in the expression). To accomplish this, you need a CASE statement. The product_sales column should be a sum of sales for the particular product_id and year, regardless of what kind of product it is. The gear_sales column should be a sum of sales only in the case where the product is either “Gear – Large” or “Gear Small”. Else in the case that the product is neither “Gear – Large” or “Gear Small”, the value for gear_sales should be 0.
8. Write a query to return all sales data for 2020, along with a column showing the percentage of sales for each product. Columns should include product_id, region_id, month, sales, and pct_product_sales.
9. Write a query to return the year, month, and sales columns, along with a 4th column named prior_month_sales showing the sales from the prior month. There are only 12 rows in the sales_totals table, one for each month of 2020, so you will not need to group data or filter/partition on region_id or product_id.
10. If the tables used in this prompt are in the ‘sales’ database, write a query to retrieve the name and type of each of the columns in the Product table. Please specify the ‘sales’ database in your answer.
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp
Order Paper Now
Use the following headings to organize your paper: Introduction, Question 1, Conclusion, References.
Submit your paper as a Word attachment in the discussion forum. I provide feedback within the paper and will not grade your post unless you submit it as an attachment. Your response to the discussion prompt should contain a minimum of 500 words
Follow the following writing requirements for all of your discussion prompt responses (note that these writing requirements DO NOT apply to your responses to other students):
Writing Requirements for all Assignments:
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp
Order Paper Now
This week’s journal article focuses on attribution theory and how it influences the implementation of innovation technologies. Two types of employee attributions are noted in the article (intentionality and deceptive intentionality), please review these concepts and answer the following questions:
Be sure to use the Library for scholarly research. Google Scholar is also a great source for research. Please be sure that journal articles are peer-reviewed and are published within the last five years.
The paper should meet the following requirements:
The writing should be clear and concise. Headings should be used to transition thoughts. Don’t forget that the grade also includes the quality of writing.
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp
Order Paper Now
The main goal of any business communication is to determine what message needs to be delivered, and how to deliver it clearly and concisely to the intended audience. In your post, explore how we identify what message needs to be delivered to the intended audience, and what methods we should employ to deliver the message concisely and with the highest level of clarity.
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp
Order Paper Now
Discussion: This week we focus on the movement of traditional IT staff. To facilitate cultural assimilation, IT and non-IT must become more integrated. What are some strategies to implement to allow this type of interaction to occur?
Note: The first post should be made by Wednesday 11:59 p.m., EST. I am looking for active engagement in the discussion. Please engage early and often.
Your response should be 250-300 words. Respond to two postings provided by your classmates.
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp
Order Paper Now
