Part 1 Use the mysqldump command line tool to backup the data in your database.

Question

Part 1
Use the mysqldump command line tool to backup the data in your database.
1. To access the mysqldump tool, start the mysql client command line tool.
2. Use the quit command to exit to the system command prompt.
3. Run mysqldump and direct the output of the backup to an appropriately named file on the U: drive (mapped to the My Files folder). Data saved to other locations will be lost!
4. Use the File Transfer button on the top side of the Toolwire desktop window to download the backup file for submission
5. 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. Describe the structure of the tables that you added Part 1
Use the mysqldump command line tool to backup the data in your database.
1. To access the mysqldump tool, start the mysql client command line tool.
2. Use the quit command to exit to the system command prompt.
3. Run mysqldump and direct the output of the backup to an appropriately named file on the U: drive (mapped to the My Files folder). Data saved to other locations will be lost!
4. Use the File Transfer button on the top side of the Toolwire desktop window to download the backup file for submission
5. 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. Describe the structure of the tables that you added Part 1
Use the mysqldump command line tool to backup the data in your database.
1. To access the mysqldump tool, start the mysql client command line tool.
2. Use the quit command to exit to the system command prompt.
3. Run mysqldump and direct the output of the backup to an appropriately named file on the U: drive (mapped to the My Files folder). Data saved to other locations will be lost!
4. Use the File Transfer button on the top side of the Toolwire desktop window to download the backup file for submission
5. 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. Describe the structure of the tables that you added

Explanation / Answer

Note:[As many of the details were missing in the question , I have tried to provide a general solution .Please comment with the whole info so that i can help you better.]

1. To access the mysqldump tool, start the mysql client command line tool.
locate the mysql installation directory and go into the bin and trigger below command

mysql -u root -p [For login into mysql]

2. Use the quit command to exit to the system command prompt.
quit

3. Run mysqldump and direct the output of the backup to an appropriately named file on the U: drive (mapped to the My Files folder). Data saved to other locations will be lost!
mysqldump -uroot -p database -r U:database-dump.sql [For taking a backup/dump of database into a file. I have taken database name as database as it is not mentioned in the question.]

4. Use the File Transfer button on the top side of the Toolwire desktop window to download the backup file for submission

Use the File transfer application Toolwire to download the backup file[Not mentioned what to do in the question]

5. 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.

CREATE DATABASE new_database; [Create a new database with name as new_database as nothing is mentioned in question]
mysql -u username -p new_database < database-dump.sql [dumping the sql file into the 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.

[Creating the new tables as mentioned in question for volunteer database]

use volunteer;
create table Address
(
houseNo number,
streetName varchar(20),
city varchar(20),
state varchar(20),
pincode number
)

create table PhoneDetails
(
phoneNumber number
)

create table email
(
emailAddress
)

alter table Person drop column Address,Phone,Email; [Removing the columns from Person table]

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. Describe the structure of the tables that you added

[This will remove composite attributes from our existing table and help us in normalizing the table further helping in efficiency in handling the SQL queries.]

Note:[Please provide all the details with the schema of the tables so that i can elaborate my answer to 2-3 pages. Please comment the details i can help you accordingly.]

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---