Python

Project #1

Step 1.

Create a Phonebook Database using the MySQL command line.

Note: This database only allows one phone number per entry.

Step 2.

Write a Python script to do the same thing.

Step 3.

Modify the script to:

read the data below from a CSV file
standardize the data
1. first and last names should start with a capitol letter
2. phone numbers should be in the form xxx-xxx-xxxx
insert the data into the phonebook database
1. bad or partial data is not inserted into the database
print error messages

First  ,  Last       , Phone Number
Tom    ,  Terrific   , 213-888-8888
Judy   ,  wonderfull , 2138259164
pete   ,  perky      , (714) 354-6781
Lee    ,  Coyote     ,
George , Jungle      , 714-234-12a6

       ,             ,
       ,
,,,,,,,

Project #2

Create a simple menu interface to an existing phonebook database. It should:

display menues
ask the user for input
add entries to the database
delete entries from the database
search the database by
- first name
- last name
- phone number

Example menus

---------------------------------
         Phonebook
---------------------------------
option   description
---------------------------------
  1      add entry
  2      delete entry
  3      search by first name
  4      search by last name
  5      search by phone number
  9      exit program

  Enter option:

---------------------------------
         Phonebook
---------------------------------
option   description
---------------------------------
  a      add entry
  d      delete entry
  f      search by first name
  l      search by last name
  p      search by phone number
  e      exit program

  Enter option:

Project #3

Step 1.

Create a Phonebook Database using the MySQL command line.

Note: This database allows multiple phone numbers per entry.

Step 2.

Write a Python script to do the same thing.

Project #4

Create a simple menu interface to an existing phonebook database. It should:

display menues
ask the user for input
add entries to the database
add phone numbers to existing entries
delete phone numbers from existing entries
delete entries from the database
search the database by
- first name
- last name
- phone number