Week 1 Lab

1. ERD

2. All Pages

country_insert

country_update

directors_insert

directors_update

index

login

org_update

organization_insert

orgcontact_display

orgfounded_display

orgstate_display

register

type_insert

type_update

3. Evaluated Pages

Working As Intended

• index
• login
• register

Working, but not as intended

• country_insert
• country_update
• directors_insert
• directors_update
• org_update
• organization_insert
• orgcontact_display
• orgfounded_display
• orgstate_display
• type_insert
• type_update

Not Working

Currently none from what I can tell but there may be something I'm missing.

4. What Database Tables Are Used Within Each Page

1. country_insert
   • country
   • login
2. country_update
   • country
   • login
3. directors_insert
   • directors
   • login
4. directors_update
   • directors
   • organization
   • login
5. org_update
   • organization
   • country
   • type
   • login
6. organization_insert
   • organization
   • country
   • type
   • login
7. orgcontact_display
   • organization
   • directors
   • login
8. orgfounded_display
   • organization
   • type
   • login
9. orgstate_display
   • organization
   • country
   • login
10. type_insert
    • type
    • login
11. type_update
    • type
    • login

5. Currently no database tables not in use.

6. What is Missing

• I would like to update my project so that when the user isn't logged in it redirects them to the login page.
• I would like to go back and change when I had to delete certain entries for the database so that they have a numerical order without spaces.

7. What I Want The Site To Do

I want the site to have a more dynamic feel to it. Right now it feels just very plain and non-interactive. I also want more display pages and database tables to insert data into.