Database Project – Evaluation
When the database loads up, a password is requested. When the password is entered, the menu screen automatically comes up. The menu screen is simple and there are 3 obvious options to choose from. These are the ‘Purchases File’, ‘Customers File’ and ‘Phones File’. They are near of the bottom of the menu screen. To go to the file, the button should be clicked on, as this navigates the screen to the chosen file.
On the second user requirement, it states that the database should make the Customer’s names to sort. I did not understand this and so I went back to the User. I told him my problem and he carefully explained to me that it should be possible for him to find a customer and the customer’s details. So I designed the ‘Find’ navigation button. When the User wants to look for a customer – for whatever the reason – instead of searching for the customer by clicking on the ‘Forward Record’ button until he finds it, he should just click on the ‘Find’ navigation button and type in any detail of the customer, i.e. the Surname, Customer ID and even the E-mail address. Then he should click on the ‘Find’ navigation button and the customers details should come up.
Instead of a search engine, I decided that a ‘Find’ navigation button would be more easy and simple to do and would have the same effect as a search engine. So in the Phones file, when you enter in a phone’s detail and press the ‘Find’ navigation button, the phone’s information should come up.
In the Phone’s file, a customer is able to view phones and deals as it has a lot of information about phones and deals. Therefore, if a customer goes on it and finds a phone or a deal they like, they could buy it.
I created the Purchases file as the User wanted the customer to be able to view their details about themselves and their product. When the Purchases file is clicked on, the person will be able to look at their details about themselves and their product. However, I went to the extent of doing it so that any person could look at their details and other as well. I did this without the User telling me to and after when I told him about this, he asked, “Why?” and I replied, “So that if a person is struggling to choose a phone or a deal, then they could look at other peoples choices and that could help them. They would also see which one is also the most favourite by looking at the customer’s choices.
I could not put the database onto the Internet as I didn’t have the skills to do so. However, the User told me not to worry about this as he knew a friend who did know how to do it.