Docstoc

Doggy World

Document Sample
Doggy World Powered By Docstoc
					Doggy   World
                                     Index


SYSTEM REQUIREMENTS ...................................................................... 3
SYSTEM FLOW CHART ........................................................................... 3
DATA DICTIONARY .................................................................................. 4
   CUSTOMER DETAILS ..................................................................................... 4
   PETS DETAILS ............................................................................................... 5
   VETS DETAILS .............................................................................................. 5
   VISIT DETAILS .............................................................................................. 6
RELATIONSHIP BETWEEN TABLES.................................................... 6
DATA ENTRY FORMS ............................................................................... 7
   CUSTOMERS FORM ....................................................................................... 7
   PETS ENTRY FORM ....................................................................................... 8
LIST OF USER DOCUMENTS .................................................................. 9
   CUSTOMER DETAILS ..................................................................................... 9
   PETS DETAILS ............................................................................................. 10
   CUSTOMER DETAILS + SUB FORM .............................................................. 11
   PETS DETAILS + SUB FORM ........................................................................ 12
   VETS DETAILS ............................................................................................ 13
VERSION CONTROLL ............................................................................ 14
SIGN OFF .................................................................................................... 15
Jason Bonaccorso                                                         7900 084 390



System Requirements
P III
250 MB Ram
64 MB Video Card
Windows XP




System Flow Chart



        Customer          Vets                Pet Details          Visit
        Details           Details                                  Details



         Create            Creates                Creates               Creates
         Customer          Vets                   Pet                   Visit
         Details           Details                Details               Details




                                     Doggy
                                     World
                                     Info Files             Creates
                                                            Customer
                                                            Report



                                                            Prints
                                                            Customers
                                                            Report




a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                 Page 3 of 16
Version 1.02.00
         Jason Bonaccorso                                           7900 084 390



         Data Dictionary

         Customer Details

Data           Type           Length         Validation   Formate   Description
Element

CustomerID     Auto Number    Long Integer   CustomerID   Number    Unique Number for
                                                                    each Member

First Name     Text           25             First Name   Text      Customers First Name
Last Name      Text           30             Last Name    Text      Customers Last Name
H-Phone        Text           12             H-Phone      Text      Customers Home
                                                                    Phone
W-Phone        Text           12             W-Phone      Text      Customers Work
                                                                    Phone
Mobile         Text           14             Mobile       Text      Customers Mobile
                                                                    Phone
Unit No        Text           6              Unit No      Text      Customers Unit No
St No          Text           6              St No        Text      Customers Street No
St Name        Text           25             St Name      Text      Customers Street
                                                                    Name
Suburb         Text           25             Suburb       Text      Customers Suburb
State          Text           6              State        Text      Customers State
Postcode       Text           6              Postcode     Text      Customers Postcode
City           Text           25             City         Text      Customer City
Country        Text           25             Country      Text      Customer Country




         a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                          Page 4 of 16
         Version 1.02.00
         Jason Bonaccorso                                                   7900 084 390


         Pets Details

Data Element       Type         Length         Validation      Formate      Description

PetsID             Auto         Long Integer   PetsID          Number       Customer PetsID
                   Number
CustomerID         Number                      CustomerID Number            CustomerID
First Name         Text         25             First Name Text              Animals
                                                                            First Name
Last Name          Text         30             Last Name       Text         Animals Last Name
Type Of Animal     Text         25             Type Of         Text         Type Of Animal
                                               Animal
Breed              Text         20             Breed           Text         Breed Of Animal
D.O.B.             Date         25             D.O.B.          DD/MM/YYYY   Animals D.O.B.
Gender             Text         10             Gender          Text         Animals Gender
Desexed            Yes / No                    Desexed         Yes / No     Desexed
Colour             Text         15             Colour          Text         Animals Colour
Comments           Memo                        Comments        Memo         Vets Comments



         Vets Details

Data Element     Type          Length             Validation      Formate   Description

VetsID           Auto Number   Long Integer       VetsID          Number    VetsID
First Name       Text          25                 First Name      Text      Vets First Name
Last Name        Text          30                 Last Name       Text      Vets Last Name
H-Phone          Text          12                 H-Phone         Text      Vets Home - Phone
Mobile           Text          14                 Mobile          Text      Vets Mobile
Unit No          Text          6                  Unit No         Text      Vets Unit No
St No            Text          6                  St No           Text      Vets St No
St Name          Text          25                 St Name         Text      Vets St Name
Suburb           Text          25                 Suburb          Text      Vets Suburb
State            Text          6                  State           Text      Vets State
Postcode         Text          6                  Postcode        Text      Vets Postcode
City             Text          25                 City            Text      Vets City
Country          Text          25                 Country         Text      Vets Country




         a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                          Page 5 of 16
         Version 1.02.00
        Jason Bonaccorso                                                   7900 084 390


        Visit Details

Data Element    Type          Length          Validation      Formate       Description

VisitsID        Auto Number   Long Integer    VisitsID        Number        VisitsID
Visit Date      Date                          Visit Date      DD/MM/YYYY    Visit Date
Visit Details   Text          250             Visit Details   Text          Visit Details
Treatment       Text          125             Treatment       Text          Treatment
Medications     Text          125             Medications     Text          Medications
Notes           Memo                          Notes           Memo          Notes



        Relationship Between Tables




        a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                         Page 6 of 16
        Version 1.02.00
Jason Bonaccorso                                7900 084 390



Data Entry Forms


Customers Form




a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                 Page 7 of 16
Version 1.02.00
Jason Bonaccorso                                7900 084 390


Pets Entry Form




a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                 Page 8 of 16
Version 1.02.00
Jason Bonaccorso                                7900 084 390



List Of User Documents


Customer Details




a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                 Page 9 of 16
Version 1.02.00
Jason Bonaccorso                                7900 084 390


Pets Details




a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                Page 10 of 16
Version 1.02.00
Jason Bonaccorso                                7900 084 390


Customer Details + Sub Form




a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                Page 11 of 16
Version 1.02.00
Jason Bonaccorso                                7900 084 390


Pets Details + Sub Form




a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                Page 12 of 16
Version 1.02.00
Jason Bonaccorso                                7900 084 390


Vets Details




a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                Page 13 of 16
Version 1.02.00
    Jason Bonaccorso                                                  7900 084 390



    Version Controll


Version        Date          Prepared By     Comments
1.00.00        19/04/2006    Jason           First Draft
1.02.00        21/04/2006    Jason           SecondDraft with Workshop 1 changes




    a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                    Page 14 of 16
    Version 1.02.00
Jason Bonaccorso                                                       7900 084 390



Sign off
Project Proposal and Preliminary Project Plan



Business Area Acceptance



_____________________________                   __________________________
Date: / /                                       Date: / /



_____________________________                   ___________________________
Date: / /                                        Date: / /




**ACCEPTANCE


______________________________


**Manager / Delegated Representative

Date: / /




a65e9453-2a26-4466-97b8-91e5a4511f00.doc
                                Page 16 of 16
Version 1.02.00

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:2/13/2012
language:
pages:16