\u00a0
\nIn this assignment, you will delve deeply into Structured Question Assignment Language (SQL) statements. You will review existing SQL statements and troubleshoot them. You would need to determine why the given statements are not functioning properly. At the conclusion of this assignment, you should be able to examine and troubleshoot basic SQL statements.
\nScenario:
\nA good friend of yours is starting a fantasy football league and has created a small database to track the team owners, teams, players, and games. Your friend knows that you are taking a database fundamentals class and has asked you to help. Your friend is not able to figure out why the database is not getting modified in any way. Your friend has given you a copy of the following:<\/p>\n
A database schema diagram. Click here to access the database schema diagram.
\nA Microsoft Access database. Click here to access the Microsoft Access database.
\nhttp:\/\/vizedhtmlcontent.next.ecollege.com\/pub\/content\/77d17d99-89f1-44c8-81e6-6291c94c294a\/AU_IST351_Football_Team_Details.accdb
\nThe following list of what he or she is trying to do: \u00a0\u00a0\u00a0\u00a0<\/p>\n
Add a new owner named Alice Wonderland with an owner ID of 1205 and a contact e-mail of [email\u00a0protected]
\nINSERT INTO Owner
\n VALUES (1205, ‘Wonderland’, ‘Alice’, ‘[email\u00a0protected]’)
\n\u00a0
\nUpdate player 323’s salary to $1,800,000
\nUPDATE Player
\n salary = 1800000
\n WHERE player_id = 323
\n\u00a0
\nDisplay all players whose salary is greater than $1,000,000
\nSELECT FROM Player
\n WHERE salary > 1000000
\n\u00a0
\nDelete owner Jerry Jones from the database
\nDELETE FROM Owner
\n last_name = “Jones” AND first_name = “Jerry”
\n\u00a0
\nUpdate game 0105 with the final score
\nUPDATE Game
\n SET home_score = 17,
\n \u00a0\u00a0\u00a0\u00a0visitors_score = 23
\n\u00a0<\/p>\n
Note: For this assignment, you will use Microsoft Access 2010 to open the database file provided. If you do not have Microsoft Access 2010, you may download a free trial version of Microsoft Office 2010, which includes Microsoft Access 2010, from the Microsoft website.
\nTasks:<\/p>\n
Open the Microsoft Access file “Football.accdb” by double-clicking on it. You will see the small database created for the fantasy football league.
\nFamiliarize yourself with the database by opening and examining the data in each table.
\nThere are two queries included with the database that will display some of the information contained in the tables. Double-click each of these to see the results of the Question Assignment.<\/p>\n
Once you are familiar with the database, proceed to the next section.<\/p>\n
Examine and Correct the Faulty SQL Statements\u00a0<\/p>\n
For each SQL statement listed above, identify the SQL statement errors.
\nOnce you have identified the errors, rewrite the SQL statements so that they will work.<\/p>\n
Note: Take special precautions with Statement 5 above. If you run the statement as it is written above, you will overwrite the scores of all of the existing games in the database.<\/p>\n
Execute the Statements\u00a0<\/p>\n
On the Create tab, in the Queries group, click Question Assignment Design.
\nWhen prompted to add tables, click the Close button.
\nOn the Question Assignment Tools Design tab, in the Results group, click on the down arrow below the word View and select SQL View. This is where you will compose your SQL statements. Feel free to type the statements above into the SQL View window and run them (see Step 4) to view the errors. (Note: Take special precautions with Statement 5 above. If you run the statement as it is written above, you will overwrite the scores of all of the existing games in the database.)
\nTo run your SQL statements against the database, click the Runbutton in the Results group. You will be prompted to confirm that you want to modify data in your database. Click Yes. Close the Question Assignment and save it as “Statement n”, where n is the statement number listed above. For example, you will save the first statement as “Statement 1”.
\nRepeat this process for each SQL statement provided above.
\nOnce you have completed correcting the SQL statements, save and exit the database.
\nSave your database as M4_A2_Lastname_Firstname.accdb.
\n\u00a0<\/p>\n
Explain the SQL Statement Errors\u00a0<\/p>\n
Create a Microsoft Word document explaining what was wrong with each of the five originally written SQL statements. Include any additional comments that you might have about the statements.<\/p>\n
Save your document as M4_A2_Lastname_Firstname.doc.<\/p>\n
Submission Details:<\/p>\n
Save your deliverables as M4_A2_Lastname_Firstname.zip.
\nBy Week 4 (your nursing study bay), Day 7, submit both the files to the M4 Assignment 2 Dropbox.<\/p>\n
Assignment 2 Grading CriteriaMaximum PointsCorrected the faulty SQL statements.40Explained the SQL statement errors.40Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources (i.e., APA); and displayed accurate spelling, grammar, and punctuation.20Total:100\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"
\u00a0 In this assignment, you will delve deeply into Structured Question Assignment Language (SQL) statements. You will review existing SQL statements and troubleshoot them. You\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[565],"tags":[195,194,191,202,204,189,200,198,197,192,201,205,190,76,203,196,193,199],"class_list":["post-6673","post","type-post","status-publish","format-standard","hentry","category-uk","tag-buy-cause-and-effect-essay","tag-buy-compare-and-contrast-essay","tag-buy-thesis-online","tag-case-study-writing-service","tag-nursing-apa-assignment-help","tag-nursing-care-plans-editing-services","tag-nursing-case-study-in-apa-writing-services","tag-nursing-evidence-based-practice-editing-services","tag-nursing-pico-project-editing-services","tag-nursing-research-proposal-editing-services","tag-nursing-term-paper-in-apa-writing-help","tag-nursing-thesis-in-apa-writing-help","tag-pay-for-thesis","tag-research-paper-writing-service","tag-write-my-case-study","tag-write-my-nursing-apa-essay-for-me","tag-write-my-nursing-paper-for-me","tag-write-my-research-paper"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/6673","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=6673"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/6673\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=6673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=6673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=6673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}