Evaluation of a Computerised System Essay Sample

essay
  • Pages: 5
  • Word count: 1,266
  • Rewriting Possibility: 99% (excellent)
  • Category: computer

Get Full Essay

Get access to this section to get all help you need with your essay and educational issues.

Try it free!

Meeting the requirements specification

In the evaluation of this project, the first things that must be considered are the first objectives that were set for the system to meet. This is the requirements specification. I will break down each objective listed in the requirements specification and discuss whether the objectives have been met.

* To complete the new system by the deadline agreed

This requirement was met. The date that was arranged was the 21st March 2008 and the date that was used on the calendar of dates was also this date.

* The database will need to be able to store enough records

The hardware that was acquired for the new system to be stored on in the end was a 120 GB hard disk, and then was well enough to store the whole database of records on.

* The system will need to alert the user when stock is low or has run out

The query ‘Out of stock’ along with its report counterpart is enough of an alert to let the user know that staff has run out. However, there is no way of checking when stock is low, and the ideal alert for items that have gone out of stock would be automatic rather than the user having to run the report or query.

* Data must be backed up to minimise loss of data and to reduce the amount of work if data does get lost

A sufficient back-up plan has been constructed which included at least two ways of backing up records at regular intervals.

* To find information about an item quickly

The ‘Find product’ query is a good way of finding information about an item quickly. It allows the user to search for an item using its name or in a separate query a product ID can be used. Alternatively, items can be browsed through using the Products form.

* Generate a unique ID for each customer entered into the database

A unique ID for each customer that is entered into the database is generated.

* Generate a record for customer details entered into the database

The Customers form is used to enter customer details into the database, and its ‘Add new record’ button is a way of generating a new record for the data that has been input.

* Produce an error if the customer already exists in the database

This objective has not been met directly, however there are measures that can be taken to see if

a customer already exists in the database. An error is not produced automatically, but a query has been created to check the database for the customer.

Show the new customer table when a new customer has been added

When a new customer is added the new customer table is not shown, however this is not necessary as the user isn’t able to view the tables, but the data is immediately accessible by the user via the Customers form.

* Show the new customer table when a customer has been deleted

The same applies for deleting a customer as applies to adding a new customer. The data is not shown as a table but is immediately accessible via the Customers form.

* Generate a unique ID for each product added into the database

A unique ID for each product that is entered into the database is automatically generated.

* Generate a record for product details entered into the database

When details of an item are entered into a Products form and the ‘Add new record’ button is clicked, then a new record is generated for that data that has been input.

* Show the new product table when a product has been added

The same applies to this as applies to customers.

* Show the new product table when a product has been deleted

The same applies as above.

* Generate a unique ID for each staff member added to the database

A unique ID is generated for each staff member that is entered into the database is automatically generated.

* Generate a record for each staff member added into the database

When the details of a new member of staff are entered into a Staff form and the ‘Add new record’ button is clicked, then a new record is generated for that data that has been input.

* Show the new staff table when a new staff member is added into the database

The same applies to this as applies to customers.

* Show the new staff table when a staff member is deleted from the database

The same applies as above.

* Generate a unique ID for each sale that takes place

A unique ID is generated for each sale that takes place is automatically generated.

* Generate a record for each sale that takes place

When the details of a sale are entered into the Sales form and the ‘Add new record’ button is clicked, then a new record is generated for that data that has been input.

* Show the new sales table when a sale has been added into the database

The same applies to this as applies to customers.

* Update the stock levels for the item purchased after a sale

The same applies as above.

* Produce an error message if the customer doesn’t exist

When a sale is conducted, if a customer ID doesn’t exist in the Customers table but is entered into the Sales table then an error message is produced.

* Produce an error message if the item isn’t in stock

An error message is not directly produced if an item is in stock, but when a staff member uses a query to locate an item to reduce the stock by 1, they should notice that the stock level for that item is already 0.

* Correctly archive data from the sales table

Data can be archived from the sales table using two queries that have been created: an append query and a delete query. Data older than 28 days in the Sales table is appended to the Archived Sales table using the first query, then data older than 28 days in the Sales table is deleted using the second.

Sorry, but A and B essays are only available for premium users

Choose a Membership Plan

We can write a custom essay on

Evaluation of a Computerised System Essay Sample ...

According to Your Specific Requirements.

Order an essay

logo

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?