P3 - Create and populate a database


P4 - create features in data entry forms to ensure validity and integrity of data

P5 - perform queries using multiple tables and multiple criteria

P6 - include an advanced feature in a database design

P7 - test a relational database.

M4 - implement an automated function.

D1 - discuss how potential errors in the design and construction of a database can be avoided

D2 - evaluate a database against the specified user need.

------------------------

Use of design when creating a database

Errors can be made in the database when proper design tools aren't used, using the tools makes sure nothing is missed and that the database will be fully functional. Some of the tools I have used were ‘Entity Relationship and Data Flow Diagrams. These were used to plan the entities that would be included in the diagram, primary & foreign keys and the the flow of data between tables.

The correct data types were selected when building the database and validations were put on the fields, this is so that Post Codes were entered in the correct format and weren't too long.

-----------------------

It is now the expected date for the completion of the new system for your sandwich shop, this is reviewing the work that has been done and assessing whether it is fit for work in your sandwich shop or what changes need to be and how long wit will be before it is fit for purpose.

The first requirement for the system was for it to have data input functionality. This requirement has been partially met, this is because there is one problem with inputting more than one sandwich type to an order, this could be fixed with just 1 weeks extension, I have been working hard on the solution to the problem and almost have it. All other inputs work as expected.

The second requirement of storage has certainly been met, the program is linked with an access database which all the data is stored to. Menu Items, customer details and Order details can all be entered in the program and will be stored in an access database.

Backups will be set up when the system is implemented into your shop, the backup can be set-up as a scheduled task in windows and it will back up the access database and/or the program, alternatively you could setup automatic cloud backups with access so even if your PC breaks the database will still be available and easily recoverable online.

The Reports on the system are still fairly basic, an order can be printed off and the functionality could be transferred to any other of the forms, a unique form could be added for a delivery note rather than using the information on the order form (company name, date, items and cost). The current report includes the company name which could be put into a sat-nav and easily linked to the address in the customer table if you could grant an extension of 1 week.

The order total report/query has been partially made but the code has been commented out as it wasn't fully functioning as I was having trouble converting the currency string to a decimal however this too is very close to completion and could be done within a week.

At the moment the new system is not fit for implementation as there are a few critical components that are close to completion but not quite there, therefore I think it would be best to continue using the paper system for another week so final issues with the program can be resolved.

--------------------

Test Description

Expected Outcome

/ x

Error Description

1

Try and enter characters in Order ID. (invalid)

Not Accepted

1

2

Test company dropdown (correct data showing and accepting) (normal)

Accepted

1

3

Test Date Picker Future : 13/06/15 (normal)

Accepted

1

4

Date Picker Past : 11/06/15 (boundary)

Error message

1

Date cannot be in the Past error provider.

5

Type in total cost textbox: 2.34 (normal)

Accepted

0

Total cost gets set back to the Item Code when Saved.

6

Type foreign characters in total cost textbox: #%D#24 (invalid)

Not Accepted

1

Total cost gets set back to the Item Code when Saved (trying to calculate total).

7

Try entering wrong date format (extreme)

Accepted

0

Date time picker can only be in correct format.

8

Try changing order ID in datagridview (invalid)

Not Accepted

1

9

Save button: Press button with normal data entered (normal)

Data saved to the database

1

10

Try typing in Item Code Datagrid view (invalid)

Not Accepted

1

11

Number in quantity: 1 (normal)

Accepted

1

12

Number in quantity: 0 (boundary)

Error Message

1

Cannot be less than 1 (error provide)

13

Number in quantity: 6824 (extreme)

Error Message

Cannot be greater than 32 (error provider)

14

Words in quanity: ten (Invalid)

Not Accepted

1

(System.FormatExeption) Input string was not in correct format.

15

Adding multiple items to an order (normal)

Accepted

0

Unhandled exception. (it could create duplicate values in the index, primary key or relationship.

16

Using the arrow buttons to move between orders. (normal)

Accepted

1

17

Adding a new Order. (normal)

Accepted

0

The order ID needs to be saved in the order before the orderitem table. The order must be done in 2 halves / saves.

18

Deleting an order. (normal)

Accepted

1

19

Clicking Print button and checking for print dialogue. (normal)

Accepted

1