Output method:
The output is when you run a Query on a PC, its result or output will come onto a report, that is that is the output method.
Process:
When query runs it searches fro a database that is an example of a process.
Verify:
Verification is the process of checking that input data is correct. It is normally carried out by a human who visually compares the data with the source document. To site check, is an example of verification. For example, to check that the fields work.
Validate:
Verification is the process of checking that input data is correct. It is normally carried out by a human who visually compares the data with the source document. Input masks, is an example of validation.
Questionnaire
1. What do you think I could improve in my hand drawn plans?
2. What do you think is good in my hand drawn plans?
3. Do you think my database looks user-friendly, if not why?
4. What do you think of the layout of my hand drawn plans?
5. Is the colour combination used good, is the style of the page good?
6. Overall, what do you think of the hand drawn plans, should I redo do them, or keep it as it is?
7. Out of a rating of 5 being the highest, what do you rate this database?
Test Plan
Testing Table
11. To have a customized When I open up database A switch board did
Switch board customized switch board not open up
should open up
Evaluation of objectives
- Must have more than one table (entity) to create relationships
I kept more than one table, in order to input more data. With more tables, there could be more forms. More different subjects, and so the database can be made. The main reason was so I can create relationships. The reason for the relationships are so I can relate or link the tables with each other. This is very helpful. For example: I can add the field name Customer_ID from the Customer form, and the field name Video_ID from the Video form to the Invoice from. In the end, I managed to achieve the objective.
- Each table has a primary key to uniquely identify each record
Each table has to have a primary key to uniquely identify each record because without it the table would not work, they are also needed for relationships, if you want to create relationships between several tables. At first it did not work but later after many attempts I achieved the objective.
- Each table is linked through primary/foreign keys
All the tables are supposed to be linked through the primary/foreign keys or else they will not work. I did this on the E-R diagram and also did it on the database and I achieved the objective.
- The database will be ‘normalised’ so each table has its ‘appropriate’ data
I normalised the data, for each table. I did 3 normalisations. In the first one, I just kept any field names I thought would be useful in my database. In the second one, I put them in tables and in third normalisation I took out the extra field names that were not relevant. Most of it was good; except one field name was wrong, I edited it and achieved the objective.
- Create Forms to gather data/reduce mistakes
I created forms for the database so I can input data. Then I created them at first they did not work, but later I fixed them and achieved the objective.
- Create Queries to search for data
I created queries for the database so I can search for data and they worked the first time I tried. I achieved the objective.
- Create Reports to show the output from your queries
I created reports to show the output and it can be very helpful to the customer or librarian. At first when I created the reports, they were not same as my hand drawn plans, but then in edited them again and I achieved the objective.
- Make database user friendly so it can be used
I made the database user friendly so it is easy to navigate. And I achieved the objective.
- To show the stock of the videos in the library
I made the field name of stock of videos in the library, at first the field was missing but then I added the field name and achieved the objective.
To show the field name of age group of videos and I achieved the objective.
To have a customized switchboard
At start it did not open up, but then I achieved the objective.
Data Collection
In this project data will be collected in different kinds of forms. The invoice form, the customer form and the video form. The librarian will give the customer the customer form for him or her to fill in. For the invoice form and video form the librarian will be expected to fill in the data for those forms. There will also be reports and queries made for some the data.
Designs Explained
I have kept my forms very user friendly so it easy for the librarian, the assistant and for the customer to use. For the forms I have kept a simple colour combination. In the forms, in the fields the background colour is yellow and the handwriting colour is blue because yellow and blue go well with each other, the colours are also bright and easy to read. For filling in the data, in those blocks the background colour will be red and the handwriting colour will be black because red and black are a good colour combination and will be easy to read. I have kept the handwriting size fairly big so it is easy for the customer and librarian to read or fill in. I have decided to use the font Arial because it is very clear and big. Also for the field names I have decided to keep them bold because they are very important. My reports are also very user friendly and attractive.
User feedback
From the user feedback I have decided to keep my hand drawn plans as my final designs because of the feedback I got. They have said everything in my hand drawn plans is good. They also said it is very user friendly, clear and the colour combination used goes very well together. However, one person said to add buttons and maybe an image. So I decided to add a video cover image and buttons to all my hand drawn plans.
Labelled test output
Evidence of Improvement