Overview
Throughout this course, you will be creating a simple database for tracking information about volunteers working and raising money for a community organization. This assessment requires you to create the initial table, called PERSON, to hold basic information about individual volunteers.
Instructions
Your assessment will be scored on the following criteria. Use the Weekly Solutions Submission Template to submit your assessment.
1. 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.
Briefly summarize (2–3 paragraphs) your design for this table.
Explain your decisions about the structure of the table and the data types used.
2. 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.
3. 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.
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.
4. Write a SQL creation table statement and run it to create a PERSON table in your database (as discussed 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.
Please use MariaDB (10.5 (x64) for windows (free download)
https://downloads.mariadb.org/mariadb/+releases/
