[u03a1] Unit 3 Assignment 1: Database Backup and Modification

Use the mysqldump command line tool to backup the data in your database. To access the mysqldump tool, start the mysql client command line tool. Use the quit command to exit to the system command prompt. Run mysqldump and direct the output of the backup to an appropriately named file. Create a new database and restore the database from the backup to the new database. Submit a screen shot to document the restoration of the data to a new database.

Part 2 Create 3 new tables for your volunteer database to hold the street address, phone number, and email address for each volunteer. Insert the relevant data for the volunteers in these tables. Modify the Person table to remove the columns for the data moved to separate tables

. Part 3 In a brief (2–3-page) paper, discuss why the tables created above for addresses, phone numbers, and email addresses are a better way to organize the data than having them in the Person database. Describe the structure of the tables that you added and how these tables are related to the Person table. 

#u03a1 #Unit #Assignment #Database #Backup #Modification

Table of Contents

Calculate your order
Pages (275 words)
Standard price: $0.00

Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

MGT 4600 Assignment: Disruptive Technologies

Disruptive technologies have been a mainstay of debates in strategic management since 1995. They have been used extensively by consultants as well as academics. The idea of disruptive innovation

Christopher Columbus : Villain

MLA format 5 paragraphs (intro-conclusion-3 body) 3 reasons why Columbus is a villain, not a hero – didn’t discover the American continent – how he

1) Read the provided YAWP readings. http://www.americanyawp.com/reader/23-the-great-depression/herbert-hoover-on-the-new-deal-1932/ http://www.americanyawp.com/reader/23-the-great-depression/huey-p-long-every-man-a-king-and-share-our-wealth-1934/ 2) Watch

  1) Read the provided YAWP readings. http://www.americanyawp.com/reader/23-the-great-depression/herbert-hoover-on-the-new-deal-1932/http://www.americanyawp.com/reader/23-the-great-depression/huey-p-long-every-man-a-king-and-share-our-wealth-1934/ 2) Watch the videos provided.  https://fod-infobase-com.occc.idm.oclc.org/p_ViewVideo.aspx?xtid=36219&loid=59394 4 3) Review the Dust Bowl presentation provided.  4) Read pages

New questions

Don't Let Questions or Concerns Hold You Back - Make a Free Inquiry Now!