PYTHON, question.

You are a volunteer worker for a not-for-profit organization called Southeast Helping Hands (SHH). SHH serves as a central clearinghouse for temporary shelter information and promotes activities such as home insulation and repair for the elderly and less fortunate. Every organization that joins the SHH as a sponsor is called a member. In addition, each member may have several contacts. Four types of memberships can be purchased on an annual basis. The database consists of two tables: the Members table, which contains data about each member organization, and the Contacts table, which contains data on the individuals who serve as contacts.

Instructions: The structure and data for the Members table is shown in Tables A1B 1 and A1B 2, respectively. The structure and data for the Contacts table is shown in Tables A1B 3 and A1B 4, respectively.

1. Create a new database to store the tables related to the not-for-profit organization data. Call the database SHH.

2. Create the Members table using the structure shown in Table A1B 1. Make the Member ID the primary key, no duplicates. Use the name, Members, for the table.

3. Add the data shown in Table A1B 2 to the Members table.

4. Create the Contacts table using the structure shown in Table A1B 3. Make the Member ID an index with duplicates. Use the name, Contacts, for the table.

6. Add the data shown in Table A1B 4 to the Contacts table.

7. Create a Query using the Members table. Include only Member ID, Company, and Member Type. Save the query as qryYournameMembers. Print the result.

Create a Query using the Contacts table. Display only the contacts whose last name starts with the letter H. Include all fields. Save the query as qryYournameContacts, print the result.

Create a Query using both tables to display the Member ID, Company, State, and Telephone for those who lives in GA state. Save the query as qryYournameGA. Print the result.

Structure of the Members table Primary Key? Field Name Description Member D Text 4 Yes Member number primary key) Company Text 201 Company name Text 201 Address Street number and name City City Tex 21 State (two-character abbreviation) State Text 101 ZIP Code 4 Member Type Text Membershiptype code (R WAR, or Ex Date Date/Time Memberships are sold in 1-year increments Num Employees Number Number of employees determines dues Table A1B 1 Data for the Members table Date Num Employees Member ID Company Address State Zip Membe Expo Plain 4750 Smith's Pus I Tog Mitchell Ave Mobile Al 36601-2030 Y 35000 Mobil LAL 3500001-500003 R 6132003 150 Table A1B-2 Structure of the Members table Primary Key? Field Name Description Member D Text 4 Yes Member number primary key) Company Text 201 Company name Text 201 Address Street number and name City City Tex 21 State (two-character abbreviation) State Text 101 ZIP Code 4 Member Type Text Membershiptype code (R WAR, or Ex Date Date/Time Memberships are sold in 1-year increments Num Employees Number Number of employees determines dues Table A1B 1 Data for the Members table Date Num Employees Member ID Company Address State Zip Membe Expo Plain 4750 Smith's Pus I Tog Mitchell Ave Mobile Al 36601-2030 Y 35000 Mobil LAL 3500001-500003 R 6132003 150 Table A1B-2