Blog

What is difference between data warehousing and data mining

What is Data Warehousing? How is it different from operational/ production databases? Explain the difference between Data Warehousing and Business Intelligence and the difference between Data Warehousing and Data Mining?

Explain the roles of african americans

To complete this project

• Choose from one of the topics below and analyze its history from 1877 to the present.

• Select four specific events or developments that span the years covered by this course, based on their impact on the topic. Two of the events must be from before 1945 and two events must be from after 1945. You must assess how the events in relationship to the topic changed over time and explain how the changes occurred. Please refer back to your Week Three Assignment, consider your instructor’s comments and make any necessary revisions.

• Write an introduction with a thesis. Your thesis should summarize the main conclusions that you discovered while researching your topic and that you will support with a logical argument based on evidence (sources). Please refer back to your Week Three Assignment, consider your instructor’s comments, and make any necessary revisions to your thesis statement.

• Connect each of the events or developments you have chosen back to your main thesis. The information presented must be organized and in chronological order.

• You must use at least four sources in your paper other than the textbook, with at least two primary sourcesand at least two secondary sources. Please refer back to your Week Three Assignment, consider your instructor’s comments, and make any necessary revisions.

1. Must include a separate title page with the following:

a. Title of project
b. Student’s name
c. Course name and number
d. Instructor’s name
e. Date submitted

2. Must begin with an introductory paragraph that has a succinct thesis statement.

3. Must address the topic of the paper with critical thought.

4. Must end with a conclusion that reaffirms your thesis.

5. Must use at least four scholarly resources other than the textbook, including a minimum of two primary sources. Your secondary sources must come from the Ashford University Library.

6. Must document all sources, including images, in APA style as outlined in the Ashford Writing Center.

7. Must include a separate reference page, formatted according to APA style as outlined in the Ashford Writing Center.Writing the Final Project.

The Final Project:

For example, a student writing a paper about the topic African Americans might choose the Harlem Renaissance and the Black Power Movement as two of their events. In that case, the paper would provide a description of the two movements. It would explain what each one revealed about the role of African Americans in broader American society in, respectively, the 1920s and the late 1960s, explain how and why the roles of African Americans in the 1920s differed from their roles in the late 1960s, and explain how events in the 1920s may have contributed to developments in the later decade.

• Topic will be Immigrants

The Final Project:

1. Must include a separate title page with the following:

a. Title of project
b. Student’s name
c. Course name and number
d. Instructor’s name
e. Date submitted

2. Must begin with an introductory paragraph that has a succinct thesis statement.

3. Must address the topic of the paper with critical thought.

4. Must end with a conclusion that reaffirms your thesis.

5. Must use at least four scholarly resources other than the textbook, including a minimum of two primary sources. Your secondary sources must come from the Ashford University Library.

6. Must document all sources, including images, in APA style as outlined in the Ashford Writing Center.

7. Must include a separate reference page, formatted according to APA style as outlined in the Ashford Writing Center.

Page Length: 4-5.

Discuss role of athens in the history of greek civilization

Discuss the role of Athens in the history of Greek civilization. What kind of impact did they leave on history?

Compare and contrast the civilizations of china and egypt

Compare and contrast the civilizations of China and Egypt. Use the 6 characteristics of a civilization (on Week 1 notes) to compare these two civilizations. Use all 6 criterions. Which society proved to be more durable and lasting? Why? Explain.

Explain how subqueries and joins are interchangeable

Discussion: Subqueries versus JOINs

You are learning how to retrieve, manipulate, and compute data stored in multiple table structures. With this in mind, you can use a variety of ways to complete these tasks. Let’s discuss the similarities and differences between a subquery and JOIN and when you might want to use one over the other, taking into account the concept of special case JOINs.

Then, using the Bowling League table data in your Oracle account, create a scenario that retrieves data from multiple tables using either a constraint or computation. You should upload the SQL syntax into the discussion forum for review and discussion. Be sure that you run the code in the SQL command area inside of Oracle account and that it works properly.

In your discussion post:

• Explain how subqueries and JOINs are interchangeable. Provide SQL syntax examples. Upload your scenario, SQL query syntax, and a screenshot of the data results into the discussion board for review.

• Discuss when you might want to use a subquery over a JOIN explaining your reasoning. Feel free to use outside resources to find extra information but be sure cite your source in APA format and include the link to any outside resources for review.

Describe discretionary access control

Part -1:

Case: Training Case

You were hired as a database security expert to train the database administration team. At the first training session,you ask the trainees to perform the following tasks using Oracle Enterprise Manager or SQL*Plus. Describe what you expect your trainees to produce.

• Create a user named CH0306 with the password CH0306.
• Modify the user options using SQL*Plus to change the default tablespace and temporary tablespace to TOOLS and TEMP respectively.
• Lock the account.
• Using SQL*Plus change the user password to DBSEC. (Optional)
• View the account using the data dictionary.(You can provide a screenshot)
• View user quotas using the data dictionary.

At the second training session,you ask the students to outline a list of the best three practices of user administration.List what you expect your students to produce.

Case – Training Case (Modified)

You were hired as a database security expert to train the database administration team.At the first training session,you ask the trainees to perform the following tasks using Microsoft SQL Server Management Studio. Describe what you expect your trainees to produce. (You can use the following help)

• Create a login named CH0306 with the password CH0306.
• Create a database user of the same name for the login created above.
• Change the user password to DBSEC. (Optional)
• View the account using the data dictionary. (You can provide a screenshot)

Part -2:

Please describe DAC (Discretionary Access Control), MAC (Mandatory Access Control), and RBAC (Role-Based Access Control) ?

Discuss the serious data redundancy problems

1. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure.

2. Looking at the EMP_NAME and EMP_PHONE contents in Figure, what change(s) would you recommend?

3. Identify the various data sources in the file you examined in Problem 5.

4. Given your answer to Problem 7, what new files should you create to help eliminate the data redundancies found in the file shown in Figure  ?

Explain the benefits of normalization

Question 1: Describe two ways redundancy infiltrates a database. Hint: Think about the difference between text boxes as data inputs and drop-down selection lists – one better controls the quality of data you enter! Another hint is to reflect on lookup tables. Note: Please do not state by “not normalizing the database”. Be more specific and creative!

Question 2: Explain one characteristic of a database that has data redundancy. Note: Redundancy in our context is not a good thing!

Question 3: Briefly explain the benefits of normalization and why we should implement it when designing databases

Question 4: Provide an example of a table or database that is in first normal form and explain how you would bring it to 3NF.
Solve these questions in details and provide examples to support your rationale.

Information Technology Project Management

PART 1.

Perform a financial analysis for a project using the format provided in Figure 4-5 in the text. Assume the project costs and benefits for this project are spread over four years as follows: Estimated costs are $200,000 in Year 1 and $30,000 each year in Years 2, 3, and 4. Estimated benefits are $0 in Year 1 and $100,000 each year in Years 2, 3, and 4. Use a 9% discount rate, and round the discount factors to two decimal places. Create a spreadsheet to calculate and clearly display the NPV, ROI, and year in which payback occurs. Based on the financial analysis, please write a few lines on the spreadsheet explaining whether you would recommend investing in this project. (Tip: Use the spreadsheet format given, such that Year 0 is year 1 described above. So your spreadsheet should include columns for years 0, 1, 2, and 3.)

 

PART 2.

Develop an imaginary project charter for a web development project. Assume you are going to develop a website from scratch for a small retail business of your choosing. Assume the web site will include a home page with links to information about products and services. It will also include a bulletin board, chat room, and provide information about the company and how to contact people in the company. Assume you are a self-employed software developer and your client is the owner and founder of the business. The owner wants a copy of the charter to circulate among her employees so they can be made aware of the project and prepare to support it. You may use Table 4-1 in the text as a template for creating headings and organizing information in the charter.

Cisneros & Imagery

Images represent much more than the literal–they also suggest figurative meanings as well.   Images can describe setting and characters, creating mood and tone for understanding their significance.

Focusing on your favorite chapter, choose one image to analyze from Cisneros’ novel and write a persuasive critical reading response exploring its significance as it relates either to setting, character development, and/or major themes in the story.  Your response must contain a thesis statement—i .e., an original claim—and utilize evidence from the text, referencing page numbers so we can follow your argument. 

Text Book Sandra Cisnero. The house on Mango Street.