PetZone Adoption Services Pet Adoption Admin

Pet Code

Pet Type

Pet Name

Age

Description

Location Pet Adoption Admin

Pet Code

Pet Type

Pet Name

Age

Description

Location

PetZone is a renowned and popular pet store in South Africa. They mostly act as a retailer for

various pet products and accessories. As part of a new initiative, PetZone has decided to off

pet adoption services. Pet owners who are no longer able to look after their animals can come

and put the pet up for adoption. Prospective pet owners can then search the database for a pet

they would like to adopt. PetZone has made provisions for the following types of pet $($they do

not take in any pet outside this list$)$:

o Dog

o Cat

o Fish

o Bird

o Reptile

o Rabbit

o Hamster

o Guinea Pig

o Ferret

You have been contracted to create a desktop GUI system, comprised of two programs for

the admin users and customers respectively $($both programs interact with the same database$)$

that can enable the pet adoption initiative.

Source: $($Kishinkwa$,2024)$

$4.$ Section A

$4\mathrm{.}2.$ Question $1$

Question $150$ Marks

Create the admin application that PetZone employees can use to manage

the pets in their adoption database.

The application should include the following:

$1.$ Database:

SQLite database with a Pets table $($attributes: pet ID$,$ pet Code, pet Type,

pet Name, pet Age, pet Description, pet Location$)$ and an Adoptions table

$($attributes: adoption number, pet ID$,$ pet Code, pet Type, pet Name, pet

Age, pet Description, pet Location$)$

$2.$ A method to add a new pet to the database.

$3.$ A method to update pet information.

$4.$ A method to delete a pet.

$5.$ Graphical User Interface to interact with the program.

Note: You must use exception handling to ensure that all database

operations are successfully done.Pet Adoption Admin

Pet Code

Pet Type

Pet Name

Age

Description

Location