DBM405A Lab 6 Stored Procedure HomeTeamScore and AwayTeamScore and Event to Backup DB

Description

I. OBJECTIVES
Understand how to add, change, and delete records.
II. PARTS LIST
EDUPE Omnymbus Environment (https://devry.edupe.net:8300); and/or
MySQL (dev.mysql.com/downloads).
III. PROCEDURE
By now you have set up either the Omnymbus environment or the MySQL Server Community environment, or both. You may do the labs in this class on your own computer equipped with MySQL or you may use the MySQL environment hosted by the vendor Omnymbus. You may even use both.
Lab Procedure Continued (common to both environments)
Create a Store Procedure to update the HomeTeamScore and the AwayTeamScore for the current record every time the procedure is called.
Write a program to step through the “Season” table displaying each record and allowing the user to enter the final score for the game. Call your stored procedure from within the program updating the “Season” table.
Set up an event to back up your database at midnight every Friday night.
SCREENSHOTS
SOLUTION
PAYMENT
The solution includes a zip document.
Attachments [Move over files to preview content of those files]
DBM405A_Week_6.zip (233.44 KB)
DBM405A_Week6_Script.sql
DBM405A_Week_6_iLab-Solved.docx
Program.cs
Visual Studio project (C#)
DBM405A_Week6
App.config
bin
Debug
DBM405A_Week6.csproj
DBM405A_Week6.IsolatorCache.user
DBM405A_Week6.sln
DBM405A_Week6.v12.suo
Program.cs
Properties
AssemblyInfo.cs
Preview DBM405A_Week6_Script.sql
xxx xxxxxxxx;
xxxxxxxxx $$
xxxxxx xxxxxxxxx xxxxxxxxxxxxxxxxx(xx xxxxxxxxx xxxxxxx(5), xx xxxxxxxxx xxxxxxx(5),xx xxxxxxxxxxxxxx xxx, xx xxxxxxxxxxxxxx xxx)
xxxxx
SET SQL_SAFE_UPDATES = 0; UPDATE Season SET HomeTeamScore = pHomeTeamScore, AwayTeamScore = pAwayTeamScore WHERE HomeTeam = pHomeTeam AND AwayTeam = pAwayTeam; END$$ DELIMITER ; — Call to verify stored procedure
xxxx xxxxxxxx.xxxxxxxxxxxxxxxxx(‘xxxx1’, ‘xxxx2’, 1, 1);
— xxxxxx xx xxxx xxx xxxxxxx xxxx
xxxxxx *xxxx xxxxxx xxxxx xxxxxxxx = ‘xxxx1’ xxx xxxxxxxx = ‘xxxx2’;
xxx xxxxxxxx;
Preview Program.cs
{
xxxxxx xxxxxxx = “xxxxxx=xxxxxxxxx;xxxx=xxxx;xxxxxxxx=xxxxxxxx;xxxxxxxx=****;”;
xxxxxxxxxxxxxxx xxxx = xxx xxxxxxxxxxxxxxx(xxxxxxx);
xxx
{
Console.WriteLine(“Connecting to MySQL…”); conn.Open();
MySqlCommand cmdSeason = new MySqlCommand(“Select *from Season;”, conn); cmdSeason.CommandType = CommandType.Text;
MySqlDataReader rdr = cmdSeason.ExecuteReader(); int macthCounter = 1; var matchesList = new List
>(); //Load all the data from Season table; while (rdr.Read()) {
xxxxxxxxxxx.xxx(xxx xxxxxxxxxxxx
(xxx[“xxxxxxxx”].xxxxxxxx(), xxx[“xxxxxxxx”].xxxxxxxx()));
}
xxx.xxxxx();
xxxxxxx (xxx xxxxx xx xxxxxxxxxxx)
{
Preview Program.cs
{
xxxxxx xxxxxxx = “xxxxxx=xxxxxxxxx;xxxx=xxxx;xxxxxxxx=xxxxxxxx;xxxxxxxx=****;”;
xxxxxxxxxxxxxxx xxxx = xxx xxxxxxxxxxxxxxx(xxxxxxx);
xxx
{
Console.WriteLine(“Connecting to MySQL…”); conn.Open();
MySqlCommand cmdSeason = new MySqlCommand(“Select *from Season;”, conn); cmdSeason.CommandType = CommandType.Text;
MySqlDataReader rdr = cmdSeason.ExecuteReader(); int macthCounter = 1; var matchesList = new List
>(); //Load all the data from Season table; while (rdr.Read()) {
xxxxxxxxxxx.xxx(xxx xxxxxxxxxxxx
(xxx[“xxxxxxxx”].xxxxxxxx(), xxx[“xxxxxxxx”].xxxxxxxx()));
}
xxx.xxxxx();
xxxxxxx (xxx xxxxx xx xxxxxxxxxxx)
{
Price: $19
Buy Now
Checkout
Added to cart
Buy More Save More
Buy at least TWO items & save up to 30% OFF your ENTIRE order!
Rack up instant rebates in your shopping cart. Simply add items to your cart, and see the savings add up.
Discounts will automatically be applied on eligible orders.
DBM405A Lab 6 Stored Procedure HomeTeamScore and AwayTeamScore and Event to Backup DB – $19.00
DBM405A Lab 7 Reports in C# Programming Language for Upcoming Schedules and Team Rosters – $19.00
Add to Cart
Checkout
Added to cart
You May Also Like:
DBM405A Lab 1 Baseball Database and Team data
DBM405A Lab 2 Baseball Database Count Orderby and Where clause
DBM405A Lab 3 Baseball Database and Season Table
DBM405A Lab 4 NextSeason Season Tables Indexes and Report
DBM405A Lab 5 Views Backup and Restore Procedures
DBM405A Lab 7 Reports in C# Programming Language for Upcoming Schedules and Team Rosters