Requirements

Introduction

Purpose of the Product Design Specification Document

The Kennel Database Management System will allow data entry and reporting abilities to assist in the control and management of day to day procedures and animal care management and protocols.

The Product Design Specification document documents and tracks the necessary information required to effectively define architecture and system design in order to give the development team guidance on architecture of the system to be developed. The Product Design Specification document is created during the Planning Phase of the project. Its intended audience is the project manager, project team, and development team. Some portions of this document such as the user interface (UI) may on occasion be shared with the client/user, and other stakeholder whose input/approval into the UI is needed.

General Overview and Design Guidelines/Approach

This section describes the principles and strategies to be used as guidelines when designing and implementing the system.

Assumptions / Constraints / Standards

Assume all fields specified below are able to be exported or imported to complete a record. Assume all reporting capabilities (based upon each field and below for specific reports) will export to PDF, CSV or XLS. Importing capabilities for records will also allow for CSV and XLS files.

System Design

Use-Cases

When new Dogs are received, their information (shown below) will be entered into the Kennel Database Management System for record. On a daily basis, for a AM, Noon and PM schedule, reports will need to be run to display the list of Dogs that will require Feeding and / or Medical attention. The ability to email an account holder (user) a reminder when a Dog’s Shots or Certification needs renewed or updated – assuming a two month reminder, one month reminder, and one week reminder. The account holder (user) will be able to pull a custom report based upon any of the given fields below to sort or filter on screen or export.

Database Design

The following fields will be open for new data entry and for modifications and reporting:

• Dog ID / Name
• Location where Dog came from
• Handler (Person) receiving Dog
• Note / Text box for Temperament Testing
• Note / Text box for Medical
• Picture of Dog
• Shots list (multiple fields – Shot name, Date given, Date of Expiration – calculation?)
• Certification Dates (multiple fields – Certification name, Date Received, Date of Expiration – calculation?)
• Feeding Requirements : AM, Noon and PM schedules (multiple fields – diet restrictions, amount, time, notes)
• Medical / Shot Requirements : AM, Noon and PM schedules (multiple fields – shot name, quantity, time given, Vet notes)
• Dog Class
• Ability to Upload and Attach files (such as MS office programs, PDF’s, JPGS, PNGs, and web links)