Create a simple database for tracking information, using a provided template. Fo

Create a simple database for tracking information, using a provided template.
For this third assessment, you will learn how to backup our Volunteer database by using the command-line utility mysqldump.exe. After you have a database backup, you will then practice database normalization by splitting the PERSON table into smaller tables containing our volunteers contact information. For this assessment, you will learn to use various SQL commands:
Use the mysqldump.exe command line tool to backup the data in your Volunteer database.
Create three new tables (ADDRESS, PHONE, AND EMAIL) for your volunteer database. These new tables will hold the street address, phone number, and email address for each volunteer.
Use the SQL INSERT INTO statement to populate your new tables with information for the volunteers in the PERSON table.
Modify the PERSON table to remove the columns for the data moved to the new tables.

Leave a Reply

Your email address will not be published. Required fields are marked *