HW 5

In an earlier class exercise you were asked to start doing the following:

  1. Build NORMALIZED pets database. (Keep your SQL in a FILE)
  2. Get comfortable with MySQL dates/times and related functions.
  3. Practice by... (Keep your SQL in a FILE)
    1. solving exam queries
    2. trying to solve the solvable queries from the 'interesting' list of queries
  4. Set up a web user on your database.
  5. Start working on a set of forms to ...
    1. Enter a new owner
    2. Enter a new pet
    3. Update pet info (ie, DOB, DOD, owner...)
    4. What would be involved in remove an owner altogether from database?

So, ideally, most of HW3 is already complete.

Following the "usual rules", build and send me a tar file which contains: 
   - "db.sql"
           An SQL file for #1(database) & #4(webuser) above. 
           Should include if-exists stmt. DB creation. Table creations. Insert to populate all tables.
           (There should be enough inserts to give interesting results for your queries. An empty set is NOT an interesting result.)

   - "3a.sql"
           An SQL file for #3a above. 
           Should include MySQL comments that repeat the pertinent exam questions.

   - "3b.sql"
           An SQL file for #3b above. 
           You only have to do 1,2,4,6,15
           Should include MySQL comments that repeat the number of the interesting query AND the written English query (cut-n-paste!)

   - All PHP files to accomplish 5(a-d) including a login.php that matches your webuser.
           The MAIN ONE should be named "index.php"  
           All others should be relative links from this "index.php" file.

Add a link to your HOMEPAGE.

  In future, I won't remind you to do this but *will* always expect it.