Order custom papers, masters thesis and dissertation in 3 guided steps; human written!
Posted: February 28th, 2022
In this assignment, you will delve deeply into Structured Query 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.
Scenario:
A 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:
A database schema diagram. Click here to access the database schema diagram.
A Microsoft Access database. Click here to access the Microsoft Access database.
http://vizedhtmlcontent.next.ecollege.com/pub/content/77d17d99-89f1-44c8-81e6-6291c94c294a/AU_IST351_Football_Team_Details.accdb
The following list of what he or she is trying to do:
We handpick every writer with care, ensuring they bring the perfect mix of academic qualifications and writing skills for top-notch results in essays, research papers, and dissertation help. Each one has a university degree, more than a third with Masters certification; they’ve tackled tough tests and training to excel in thesis writing and research paper assignments at any time. They’ll team up with you diligently, keeping things easy and stress-free as they relate to being immediate students. That’s what makes us the best assignment help website for "help me write my essay, research paper, or dissertation" for college coursework. Trust our team—professional research essay writers and editors—to deliver your dissertation or thesis writing within your grading criteria and deadline.
Add a new owner named Alice Wonderland with an owner ID of 1205 and a contact e-mail of [email protected]
INSERT INTO Owner
VALUES (1205, 'Wonderland', 'Alice', '[email protected]')
Update player 323's salary to $1,800,000
UPDATE Player
salary = 1800000
WHERE player_id = 323
Display all players whose salary is greater than $1,000,000
SELECT FROM Player
WHERE salary > 1000000
Delete owner Jerry Jones from the database
DELETE FROM Owner
last_name = "Jones" AND first_name = "Jerry"
Update game 0105 with the final score
UPDATE Game
SET home_score = 17,
visitors_score = 23
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.
Tasks:
Open the Microsoft Access file "Football.accdb" by double-clicking on it. You will see the small database created for the fantasy football league.
Familiarize yourself with the database by opening and examining the data in each table.
There 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 query.
Once you are familiar with the database, proceed to the next section.
No matter what citation style you need for your research paper or dissertation, our skilled writers have you covered! We provide thesis writing and dissertation help in formats like APA, AMA, MLA, Turabian, Harvard, IEEE, and more. We’re dedicated to customizing your order to the exact guidelines of your chosen style, ensuring it fits your unique academic needs—whether it’s a dissertation, research paper, or essay for a specific course. We’ve got the flexibility to make it work for you!
Examine and Correct the Faulty SQL Statements
For each SQL statement listed above, identify the SQL statement errors.
Once you have identified the errors, rewrite the SQL statements so that they will work.
You can absolutely reach out to your academic writer using our simple, user-friendly chat feature. It’s there so you can add details, clarify instructions, or tweak adjustments for editing your research paper or dissertation according to your grading rubric—even after you’ve submitted "help me with thesis writing or dissertation help" and they’ve started working on your project.
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.
Execute the Statements
On the Create tab, in the Queries group, click Query Design.
When prompted to add tables, click the Close button.
On the Query 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.)
To 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 query 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".
Repeat this process for each SQL statement provided above.
Once you have completed correcting the SQL statements, save and exit the database.
Save your database as M4_A2_Lastname_Firstname.accdb.
Explain the SQL Statement Errors
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.
Save your document as M4_A2_Lastname_Firstname.doc.
Submission Details:
Save your deliverables as M4_A2_Lastname_Firstname.zip.
By Week 4, Day 7, submit both the files to the M4 Assignment 2 Dropbox.
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
You Want Quality and That’s What We Deliver
We’ve put together our writing team with care, choosing talented writers who shine in their fields. Each one goes through a tough selection process, where we look for folks with deep expertise in specific subjects and a solid history of academic writing. They bring their own mix of know-how and flair to the table, making sure our content hits the mark—packed with info, easy to read, and perfect for college students like you.
We don’t do AI-written essays or copycat work—everything’s original. Competitive pricing is a big deal for us; we keep costs fair while delivering top-notch quality. Our writers are some of the best out there, and we charge rates that stack up well against other services. This means you get stellar content without draining your wallet. Our pricing is straightforward and honest, built to give you real value for your money. That’s why students turn to us for high-quality writing services that won’t break the bank.
Academic integrity is at the heart of what we do. Every paper starts from scratch, with original research and writing tailored just for you. We write 100% authentic—no plagiarism research essays. Our strict quality control process includes scanning every draft with top tools like SafeAssign and Turnitin, so you get a similarity score and proof of originality. We’re obsessive about proper citation and referencing too, crediting every source to keep things legit. It’s all about giving you peace of mind with content that meets the highest standards.
When you decide to place an order with Dissertation Writer, here is what happens: