GP’s Progress Report 5

This week we have accomplished:

• Beth Mercado: Make necessary changes in the project’s prototypes
• Rona Tadlas: Make ‘create table’ queries
• Perla Loro: Encrypted passwords using sha1 and handled sessions
• KC Ferre: Make ‘insert table’ queries with all the sufficient sample data

Our next week goals:

• Connect the database to the user interface

Our most important concerns/issue:

· There are some problems regarding foreign keys in our queries

We learned:

• Beth Mercado: how to connect database to the project
• Rona Tadlas: MySQL queries
• Perla Loro: use sha1 and make sessions
• KC Ferre: one cannot insert data in some tables if it refers to a non-existent foreign key of another table; and to validly insert data, one should consider the types of variables, constraints, etc.