[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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

The paper is to be clear and concise  The paper should be formatted per current APA and 7-10 pages in length, excluding the title, abstract and references

The paper is to be clear and concise  The paper should be formatted per current APA and 7-10 pages in length, excluding the title, abstract and references page. Incorporate a minimum of 3 current (published within last five years) scholarly journal articles  or primary legal sources (statutes, court opinions) within your work. You will

  Critical Research Appraisal Assignment Goal: You will

  Critical Research Appraisal Assignment Goal: You will critically appraise a research design Content Requirements:  You will select one research report with a qualitative design and one with quantitative design and answer the following questions regarding the following categories: 1. Discuss what is meant by the term Qualitative Research ·