** SQL DATABASE .. Using MySQL, Oracle, Microsoft SQL Server, Access etc.. **

• Create a table to have the fields:
  • First Name
  • Last Name
  • Street Address
  • City
  • State
  • Zip
  • Mobile Phone
  • Home Phone
  • Date of Birth
  • Biologic Gender
• Add or identify the tables primary key and make sure those fields can not be empty or null.
• Insert 10 rows of people.
• Select all rows
• Select all females
• Select all males
• Write and execute 3 select statements to uniquely select specific people using the primary key fields.
• Change some values on each of 4 specific people using the primary key fields with update statements.
• Select all rows
• Delete 4 specific people using the primary key fields with delete statements
• Select all rows
• Delete all males
• Select all rows
• Delete all females
• Select all rows
• Upload all your SQL statements and results