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

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

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.

Explanation / Answer

The sql code for the three new tables are below, As we are creating this tables to store the information of the persons we use IDNumber from the member table as we need to uniquely identify the data of the person. Otherwise we can't tell which address belongs to which person.

Above are the Three new tables for the required data.

After removing the data to the new tables the initial member table would be below.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.