Programming Homework Help

Creating the Initial Table for the Volunteer Database

Overview

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.

Instructions

Your assignment will be scored on the following criteria. You will use the Weekly Solutions Submission Template to submit your assignment.

1. Think about the design of the table to hold VolunteerVolunteer_IDVolunteer_NameVolunteer_PhoneVolunteer_AddressVolunteer_CityVolunteer_StateVolunteer_ZipCodeVolunteer_EmailVolunteer_Organization TransactionsTrans_IDEvent_DateDonor_IDVolunteer_IDTrans_Amount DonorsDonor_IDDonor_FirstNameDonor_LastNameDonor_AddressDonor_CityDonor_StateDonor_ZipCodeDonor_PhoneDonor_Email EVENTEvent_IDEvent_NameEvent_LocationEvent_DateEvent_TimeEvent_DurationPOC_FirstNamePOC_LastNamePOC_PhonePOC_Email
   Briefly summarize (2–3 paragraphs) your design for this table.
   • Explain your decisions about the structure of the table and the data types used.
   • Discuss how you would go about gathering and normalizing the information that you need for putting the volunteer database together and how that fits into the database life cycle. Consider your vocabulary and communication style in your response. Your target audience would be the volunteer organization’s leadership.
2. Write a SQL statement to create a new database named VOLUNTEER.
   • Save your SQL to a text file using the MySQL tee command and document the process with screenshots.
3. Write a SQL table creation statement and run it to create the PERSON in your database (as noted 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 using the MySQL tee command and document the process with screenshots.