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.
What Students Are Saying About Us.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."