Question: A continuation of my previous question Part 2 Create 3 new tables for your volunteer database to hold the street address, phone number, and email

A continuation of my previous question

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. For the street address use basic street names such as Main Street and First Street, etc... The other personal information is below.

A continuation of my previous question Part 2 Create 3 new tables

Normalizing Data for Data Entry Assume the following table structure MariaDB [ (none) ]> describe test.members; I Fielcd | Type | Null I Key I Default l Extra I I int (11) I varchar (30) I YESI IDNumber I NO I PRI | NULL LastName | FirstName Ivarchar (30) YES | Emai.1 | MemberSince date NULL NULL NULL NULL I varchar (50) IYES I YES I 5 r?ws in set (0.01 sec) You should create this table using the following SQL: CREATE TABLE members ( IDNumber LastName FirstName Email MemberSince DATE INT PRIMARY KEY VARCHAR (30), VARCHAR (30), VARCHAR (50), You should clean up and normalize the following data found in various sources. After normalizing the data, write and run SQL INSERT statements to enter the rows into the database table that you created above. In a brief paper, describe the process for normalizing the data and why you made the changes that you did

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!