Question
Part 2 Through the remaining assignments in the course, you will be creating a simple database for tracking information about volunteers working and raising money
Part 2
Through the remaining assignments in the course, you will be creating a simple database for tracking information about volunteers working and raising money for a community organization. This assignment requires you to create the initial table, called Person, to hold basic information about individual volunteers. You will be refining the design and building the database in the assignments for upcoming units.
Think about the design of the table to hold a volunteer's ID number, name, mailing address, phone number, email address, and three more fields of your choice. In a very brief paper (23 pages) describe your design for this table. Explain your decisions about the structure of the table and data types used. Discuss how you would go about gathering the information that you need for putting the volunteer database together and how that fits into the database life cycle.
Part 3
Write a SQL table creation statement and run it to create the Person table in your database (as discussed in Part 2 above). After creating the table, write and run SQL statements to insert rows in the table for 10 volunteers. Save your SQL to a text file and document the process with screen shots.
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 didStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started