Paws for Thought Task B Brief
Customising database to meet organisation needs
All tasks need to be documented (screenshots with explanation) as these forms are a foundation for
your assignment 2.
All tasks need to be explained in respect of what you have done, what went well and what could
have been done better, suggesting the alternative solution to a problem and/or any
recommendations.
Task Scenario
‘Paws for Thought’ has partially developed a database that will eventually be merged with the
database you created in Part A.
The original data set showed the dogs attending doggie day car and their carers.
• The organisation wants a user interface for users to be able to add details of new carers.
• All new carers must have an email address in the correct format.
• They also want a user interface to record the daily meal given to the dogs.
• The amount of packs of food given is dependent on the size of the dog:
o S = 2 packs
o M = 3 packs
o L = 4 packs
• The form must calculate the number of packs given and the total cost of the meal.
Forms (1 hour 10 minutes)
Note - the structure of the tables provided should not be changed in any way, e.g. do not
add validation, do not change data types.
You will only be required to use tblCarers, tblMealType, tblMealRecord and tblDogs
(a) Create an efficient interface that will facilitate database input by producing:
(i) an input form to add a new carer.
• The form should be ready for data entry.
• The carer’s first name and surname must be present.
• The carer’s email must in the correct format
• Valid data should be appended to the carers’ table and a save message
should display.
• A suitable error message should appear where invalid data has been used.
(ii) an input form to record a meal.
• The form should not include validation for any fields.
• The form should not include an automated routine to save the data.
• The user should be able to select the dog and the meal type
• These details should then be displayed:
The dog name
The dog size
The meal type
The price of the meal
Customising database to meet organisation needs
All tasks need to be documented (screenshots with explanation) as these forms are a foundation for
your assignment 2.
All tasks need to be explained in respect of what you have done, what went well and what could
have been done better, suggesting the alternative solution to a problem and/or any
recommendations.
Task Scenario
‘Paws for Thought’ has partially developed a database that will eventually be merged with the
database you created in Part A.
The original data set showed the dogs attending doggie day car and their carers.
• The organisation wants a user interface for users to be able to add details of new carers.
• All new carers must have an email address in the correct format.
• They also want a user interface to record the daily meal given to the dogs.
• The amount of packs of food given is dependent on the size of the dog:
o S = 2 packs
o M = 3 packs
o L = 4 packs
• The form must calculate the number of packs given and the total cost of the meal.
Forms (1 hour 10 minutes)
Note - the structure of the tables provided should not be changed in any way, e.g. do not
add validation, do not change data types.
You will only be required to use tblCarers, tblMealType, tblMealRecord and tblDogs
(a) Create an efficient interface that will facilitate database input by producing:
(i) an input form to add a new carer.
• The form should be ready for data entry.
• The carer’s first name and surname must be present.
• The carer’s email must in the correct format
• Valid data should be appended to the carers’ table and a save message
should display.
• A suitable error message should appear where invalid data has been used.
(ii) an input form to record a meal.
• The form should not include validation for any fields.
• The form should not include an automated routine to save the data.
• The user should be able to select the dog and the meal type
• These details should then be displayed:
The dog name
The dog size
The meal type
The price of the meal
