Food Material Costing:2011 Spring Team Meetings

=4/14/11=

Agenda

 * Alex: Write up the abstract on the wiki and write up the agenda for next week.
 * Matt: Write up parent-of dependency graph and of child-of dependency graph.
 * Mike: Write up requirements specification for the wiki.
 * Bego: Write up documentation for normalization once John e-mails him the user views.
 * John: Working on class diagram and write up the user views.

Minutes
In class, 11:35-12:00.
 * Went over UML diagram that was drawn up by John last week. We decided the class agenda for next week.
 * Double checked next weeks class agenda to make sure we are all on the same page as far as individual responsibilities go.

=4/21/11=

Agenda
We currently have the relational concept drawn up and completed. In addition, it has been completely normalized. Child and Parent dependency graphs have also been completed for ease of use in creating the SQL code to develop the database. The agenda for this week is as follows:
 * Finalize the relational model and discuss any concerns about it.
 * Relevance/Necessity of entities
 * Relevance/Necessity of attributes in entities
 * Parent/Child diagrams
 * Review the Normalization process
 * Begin to delegate responsibility for creating the SQL code to develop the database.
 * Most likely a collaboration of individuals whom will each take a part of the database.
 * Go over the types of queries that will need to be developed for the end-user.
 * Make sure the Google Code and Google Group sites are up-to-date.
 * Address any concerns about workload and/or lack of effort among individuals in the team.

Minutes
9:45-10:35


 * Facilitator: Alex
 * Minutes Taker: Matt
 * Present: Alex, Bego, John, Matt, Mike


 * Assigned Roles:
 * Alex: SQL Create Tables
 * John: SQL Insert Tables
 * Bego: Normalization Design
 * Mike: Logical Modeling
 * Matt: Requirements and User Views


 * Group or Secondary Roles
 * Review of SQL (Group)
 * Update of wiki (Mike)
 * Tortise (Matt)
 * Writing SQL Queries (Group)
 * Issues Addressed:

- Completed. Minimal concerns: Missing FK needs to be added.
 * Finalize the relational model and discuss any concerns about it.

- Completed.
 * Relevance/Necessity of entities

- Completed.
 * Relevance/Necessity of attributes in entities

- Completed.
 * Parent/Child diagram

- Normalization reviewed / completed.
 * Review the Normalization process

- Began discussing roles for who will be responsible for SQL queries and code.
 * Begin to delegate responsibility for creating the SQL code to develop the database.

- Postponed until more development on the DB completed.
 * Go over the types of queries that will need to be developed for the end-user.

- Google code site needs to be recreated and Google Group site is current.
 * Make sure the Google Code and Google Group sites are up-to-date.

- Completed.
 * Address any concerns about workload and/or lack of effort among individuals in the team.


 * New Items:
 * Discussed need for new Google code site
 * Discussed where to upload files as they're created
 * Plan to generate sample data for next week

=4/28/11=

Agenda

 * Discuss the draft of the SQL script
 * Errors
 * Go over the possible need for changes in the database
 * More tables/Less tables
 * Potential queries
 * For the user
 * Make sure Parent/Child diagrams and UML is in up-to-date form
 * Group communication
 * Good/Bad
 * Who needs to communicate better

Meeting
No meeting took place. The entire class time was used for T2 review and SQL programming practice.