Machine shack management system Essay

Options – This will take you to the options menu where additional features of the system will be shown. Stock Table Menu The Stock Table Menu has options relating to the stock table.   Add Record – This will take you to a screen where you can add records to you database.   View Edit Delete – This will take you to a screen where you can view the records using the up and down keys as well as let you delete or edit records.   Search Record – This will take you to a screen where you can search for records, once found it will display the record. Items Needing Reordering – This will take you to a screen which will display only the items which need reordering.   Back to Main Menu – This will take you back to the main menu. Sales Table Menu The Sales Table Menu has options relating to the stock table.   View or Delete Sale – This will take you to a screen where you can view all the sales and delete sales, using the down key to scroll through records and the ‘d’ key to delete sales.   Search Record – This will take you to a screen where you can search for Sales records, once found it will display the record.   Return Item – This allow you to return an Item which has been sold. Back to Main Menu – This will take you back to the main menu. 2. 7 Data Capture 2. 7. 1 Input Forms and Output Forms Add Record Add record will bring up the form used to add items to the stock table. The add record form will look like the illustration below: View, Amend and Delete a Record This Form will be used to view, amend and delete records, you simply use the up and down keys to scroll available records, if you would like to delete a record you press ‘d’ and it will be deleted or if you would like to amend a record you press the ‘e’ key and it will ask you which part of the record you want to amend. Search Records for sales and stock. This feature will be used to search through the database to find a specific record, it will work by asking for a item code, then searching for the item code, using an IF statement in a loop to compare ever item code with the entered value until the record is found, else if it reaches the end of the file and has not found any matching record it will display a message saying ‘record not found’. View Items which Need reordering Here items will be compared that are available in stock with the minimum stock level, if the values are the same or the value of items available is smaller then that record will show up in this output form. View or Delete Sales Record Here you can view all sales that have taken place using the up and down keys, to delete a sale you simply press the ‘d’ key and that record will be deleted. Return Item from Sales Record Here you scroll down to the sale which you want to take back and it will delete the record and if the item is still in good condition it will add it back to the stock table. Check Out The Check out is the main form used and the most complex which uses the most types of file manipulation. Here you enter Items the customer wants, it will then calculate a total for the customer and print a receipt. It will also subtract items sold from the stock table and put them into the sales table. When entering items it will display the description of the item to validate if the code it correct. 2. 8 Sample of planned data validation An Example of where I will use data validation can be taken from when you will enter an Item Code, in the add stock form, when you enter a code, the system will check the entire stock table to see if that Item Code exist if it does you will be given an error message. 2. 9 Description of record or database structure. The Database structure is mainly two files one which holds the stock details â€Å"Stock. dat† and the other which holds the Sales information â€Å"Sales. dat†, the structure and formats of these files can be found in the â€Å"Definition of data requirements† section. Details can be added to the stock file through the stock options. The Check Out will read items codes display the Name and Price of the items, you enter into it and calculate a total. Then it will subtract the items from the stock table and add them to the sales table. 2. 10 Sample of Planned data entry. An example of data entered into the add stock form. 2. 11 Sample of planned valid output An Example of Data output in the View Edit Delete Stock Form. 2. 12 File Organisation and Processing The file organisation used in the database will be a serial organisations, so when a record is added to a file it will add it to the end of the file. Searches will be preformed using a serial search, basically it will go through each record using a repeat loop and an if statement will be used to check for valid results. 2. 13 Database design including E-R Model. There are be 2 main entities in this system, a one to many relationship 2. 14 Security and Integrity of Data Firstly physical access to the computer will be pretty hard since, the end user will always be at the shop, when it is open, and the shop is locked when it is closed. The data that will be stored in this database is just mainly data about stock and sales so methods like encryption are a little too extreme. The data stored in files can really only be made sense out of if read by the database, opening them up using a text editor like notepad will give, just you lots of jumbled data. Integrity of the data will be mainly maintained by the validation rules present in the database, another way integrity is maintained is most of the complex procedures have been simplified to entering minimal data, for example entering an item into the check out just required the item code, which after entering displays the name to further make sure it is the correct information entered. 2. 15 System Security A number of steps will been taken to ensure that the system is secure and maintains the integrity of data. For security purposes the system will have a password at the start up, this will prevent unauthorised access to the system, the password and system will automatically activate at computer start up, this will be achieved by modifying the computer boot files (autoexec. bat) adding the program path and executable location. In this case like:- Since with this modification the system password will start instantly on the computer booting, It makes it harder for anyone to access the data of the system in other ways, like notepad, edit, etc. Another Security feature will be that the password can only be entered 3 times after which the computer will halt (freeze), and the only way to get back is to restart the computer, which again will take you to the password, the freeze process will be achieved by using a simple endless loop like:- Repeat Until restart; Since the Boolean variable restart is set to false and will never equal true in this case it will just keep looping. Thus making it extremely hard for the computer to be accessed in any way other then through the system, which will require a password. 2. 16 Overall Test Strategy. Test Strategy The test strategy will include:   Test all input forms, if they accept all the data   Testing of individual Menu System Options   Testing of inputting invalid or extreme data   Check backup and restore features   Test security features   Test system by inputting dummy data to simulate real events End-user tests it, to see if it meets his requirements 2. 16. 2 Test Plan Test No. Test Expected Result 1 Test Auto Boot Feature Boots straight into system, with no errors 2 Test Password Only â€Å"hello† accepted 3 Test all menu system options All options lead to the right place 4. Stock Table accepts all data sets from data set 1 All data accepted with out error 5 Test if only unique Item Code can be entered and not one that is already in the database Accepts only unique Item code 6 View Feature tested All entered data is displayed properly 7 3rd data set in stock table will be edited Changes accepted 8 8th data set in stock table will be deleted Record deleted successfully without any other affects. 9 Test Item Re-stock Feature If Items which need restocking appear in the records, these should be records, 5, 8 and 10 9 Test Check Out, Total feature Should give a correct total. Test if items sold in check out appear in sales table Should appear in sales table 11 Delete item from sales table Should delete 12 Test Return feature, if item returns to stock Should return to stock table and be deleted from sales table 13 Test Password Change Feature New Password should be accepted 14 Test Back up feature if database backs up to floppy disk Should copy stock and sales table to a floppy disk 15 Check Exit Feature Program should return to dos 16 Enter very large integer into an integer field Program may crash 17 Entering character into a integer field Program may crash. Entering more then 20 characters in the Item Name Field Since the variable for this is string[20] program may crash 2. 16. 3 Test Data Being used Test data set 1: Stock Table Item Code Item Description Price Amount in Stock Minimum Stock level 0001 Mobile Phone 35.