Software Development Project: Animals R Us & Veterinary School System (AVSS)

This Assignment assesses the following module Learning Outcomes:

2. have knowledge and understanding of appropriate tools and techniques for application building;

3. have an in-depth appreciation of the issues involved in working as part of a team.

4. be able to undertake complex software development tasks and select methodologies using advanced decision-making;

5. work effectively as part of a team and be able to adapt accordingly;

6. undertake practical design and programming skills for a software development project.

This second assessment simulates working in a software development team with fellow students to implement the proposed Animals R Us & Veterinary School System (AVSS) introduced in the first assessment (CW1).

Details on the project case study and data model is in part 2 below. Details on the tasks and demonstration viva you will need to complete are in parts 3 and 4. The UATs to guide your implementation is in part 5 and a mark breakdown in part 6.

• Carry out project planning, teamwork and management

• Review and refine the requirements specification

• Implement a data model for the prototype

• Implement the prototype using a PHP-based framework

• Test the prototype

• Demonstrate the prototype to the client

• Planning, time management and teamwork (including leadership and negotiation)

• Cope with a complex brief (with possible ambiguities and inconsistencies) from the client

• Technical skills to produce the prototype and understanding how system components work

• Interacting with the “client” on your solution via documentation and demonstration

You should also create, and submit, a database schema (diagram – not part of the word count) to reflect the final version of your implemented database.

• This looks like an Entity Relationship Diagram (ERD) but depicts what is built and must match the database structure seen in phpMyAdmin (MySQL) within EasyPHP.

• Ensure each table is depicted with its attributes (including data type and length) and relationships between tables. Primary and foreign keys must also be indicated.

• Your diagram could be exported from a tool such as MySQL Workbench, which can also import/export the data structure from/to phpMyAdmin

Carry out TDD with Agile’s ‘test-first’ method against functional UATs (see part 5 below) as a guide to your test cases. Test concurrently with implementation in small batches, i.e. add a test case to the test plan before anything is coded, then implement the functionality, and finally run the test documenting the results.

For each veterinary lesson, a unique number allocated and used to document the name of each animal and participating trainee, the date, time and cost offset for the lesson. The owner of Animals R Us & Veterinary School wants to allocate animals based on suitability for the lesson against each animal’s condition for trainee(beginners, intermediate, and advanced) and availability (weekdays, weekends or both). All the owners want to make sure that their animals are used suitably, i.e. an animal’s condition is safe for a particular lesson.

The following data is displayed:

The animal’s identity and name,

The trainee’s number and name,

Details of the owner of each animal.