I have the database done from the previous module Ill send to you upon me accepting.

In the last module, you build your database.  But a database without any data isn’t useful at all!  In the last module, you build your database.  But a database without any data isn’t useful at all!  So now that you have had some practice in writing SQL queries and you have a functional database in at least third normal form (from the previous module), it’s time to populate your database and write some queries!

Step I

Populate your database that you created in module 5 with some representative testing data. Include at least 15 records for each of the tables (use INSERT commands or GUI tools provided by the DBMS you select).

Step II

Think of descriptions for six data querying requirements that could be answered from the data stored in your database, three requirements to change data already in the database, and three requirements to delete data already in the database.  Answers to your querying requirements should contain at least two JOINs; two aggregation functions; a GROUP BY clause; and three WHERE or HAVING clauses.  See the discussion instructions for examples.

Step III

In a Word document, prepare the following for each DML requirement you came up during Step II:

• The description for your requirement
• The DML statement (SQL command) that will get you the data you need – do not use a query generator or graphical tool to write this; write it on your own
• A screenshot of the resulting query output when executed on your database

Click on USA3-Steel.xlsx (this is the document that you will be formatting according to the instructions) 

Click on Excel Assessment.docx (this is the instruction sheet for formatting (USA3-Steel spreadsheet)

or HW 3, you should use a main() function to control the program you write. You should also use other functions as appropriate (or as specified). 

1. String Manipulation – Write a program that asks the user to enter a word or phrase and then displays the word or phrase with all occurrences of the letter “r” removed. Example: “Park the car in Harvard Yard” becomes “Pak the ca in Havad Yad.”
2. Special Number – Write a program that can find a four-digit number that has the four digits reversed when multiplied by four. For example, rstu * 4 = utsr. The program should report the number to the user. 
3. Check for Palindromes – Write a program that prompts the user to enter a word or phrase. Then check to see if the word is a palindrome. A palindrome reads the same forward and backward ignoring punctuation and spaces. For example, “racecar,” “Madam, I’m Adam,” and “Anna.” You can use these palindrome sentences (Links to an external site.) as a source for checking if your program works. 
4. Calculate the Factorial – The factorial of a positive integer is the product 1 * 2 * 3 * 4 … * n where n represents the positive integer. Write a program that asks the user to enter a positive integer and calculates the factorial. Use a main() function to control the program flow. Write a function to get an integer from the user and verify the user entered a positive integer value. Write a different function to calculate the factorial for a number. 
5. [REMOVED FROM PY HW 3 BECAUSE WE DID NOT COVER FILE I/O IN CLASS YET] Crayon Colors – The file “Colors.txt Download Colors.txt” contains the names of 123 crayon colors with one color per line. Write a program that asks the user to enter a letter of the alphabet and then displays all the colors that start with that letter. Write three separate functions: one to get the user input, one to read the colors.txt file into a list, one to build a list with the colors that start with the letter, and one to display the output. 
6. Anagram Checker – Write a program that asks the user to enter two words or phrases. Then check to see if the words or phrases are anagrams of each other. Two words or phrases are anagrams of each other if they use the same letter with the same frequency in both phrases. Examples include night & thing, inch & chin, elbow & below, little big man & labeling mitt, another day & a hearty nod. 
7. [REMOVED FROM PY HW 3 BECAUSE WE DID NOT COVER FILE I/O IN CLASS YET]Sorting States List – The data file “States.txt Download States.txt” contains the 50 US states in order they joined the union with one state per line. Write a program to read the file contents into a list. Then sort the list based on the number of consonants contained in the state name in ascending order. HINT: You will need to write a function to count the number of consonants in a word. 
8. Reading Numbers – Write a program that asks the user to enter a number with 27 digits or less. The convert that number into a set of three-digit numbers and associated place values. Display the results to the user. The following table shows the output if the user entered 293452000450041006950254586. 

1 page due Wed 

 A friend of yours is running his business on what is becoming a more complex linked spreadsheet.  He invited you to assess the situation and propose a solution.  After a thorough study, you have suggested that he start using a database.  How would you justify the use of a database?  He also asked you to explain what he called “buzz words” that are surging the IT field:  

• What is the difference, in terms of functions and roles, between DBMS and SQL?  
• Define and explain the difference between database, data warehouse, and big data?

In response to your peers, please fill in any gaps or add more detail to help support their answer, emphasizing the critical features and operations of the relational model and why it is the most popular database model. 

 Select any example of a visualization or infographic, maybe your own
work or that of others. The task is to undertake a deep, detailed
‘forensic’ like assessment of the design choices made across each of
the five layers of the chosen visualization’s anatomy. In each case
your assessment is only concerned with one design layer at a time.
For this task, take a close look at the annotation choices:

1. Start by identifying all the annotation features deployed, listing
them under the headers of either project or chart annotation
2. How suitable are the choices and deployment of these annotation
features? If they are not, what do you think they should have been?
3. Go through the set of ‘Influencing factors’ from the latter section of
the book’s chapter to help shape your assessment and to possibly
inform how you might tackle this design layer differently
4. Also, considering the range of potential annotation features, what
would you do differently or additionally?

Submit a two-page document answering all of the questions above. Be
sure to show the visualization first and then thoroughly answer the
above questions. Ensure that there are at least two-peer reviewed
sources utilized this week to support your work.