Case 6 – Accessing Database Data and Unit Testing

Think-Design-Write Test-Code

• DescriptionWestern Nursing Services has given preliminary approval of the user interface prototype. This is and the review of the use cases your company generated earlier has resulted in a database implementation that you can now write code against.The team, of which you are a member, has been tasked with exploring what code will be required to access and insert data appropriately into this database. Your team lead decides to divide up the twelve initial tasks evenly amoung your team members. This involves the design, test, and code creation of functions for each task.
• Deliverables
  1. A test matrix for your data access functions.
  2. Pseudo code of the data entry and lookup functions.
  3. Quality unit tests to test each of the functions in your solution.
  4. Solutions that passes your unit tests
• Resources
  1. Testing functions with SimpleTest
  2. Inserting data into MySQL
  3. Retreiving data from MySQL
  4. Retreiving one record from a MySQL result set