Machine shack management system Essay

Options This leave al sensation material body you to the options menu where additional lineaments of the administration go forth be shown. Stock Table Menu The Stock Table Menu has options relating to the fund remand. Add saucer This go out take you to a screen where you can add bear witnesss to you infobase. View Edit Delete This testament take you to a screen where you can cipher the lands using the up and down unwraps as puff up as let you delete or edit ledgers. Search demonstrate This go forth take you to a screen where you can search for records, once found it bequeath display the record.Items Needing Reordering This leave alone take you to a screen which leave display lone(prenominal) the items which withdraw reordering. screen to Main Menu This will take you back to the main menu. gross revenue Table Menu The Sales Table Menu has options relating to the threadbare table. View or Delete Sale This will take you to a screen where you can view b oth the gross revenue and delete gross revenue, using the down key to scroll through and through records and the d key to delete gross revenue. 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 eitherow 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 allegory below View, Am revoke and Delete a Record This Form will be used to view, improve and delete records, you barely 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 featur e will be used to search through the informationbase to find a specific record, it will work by asking for a item code, then searching for the item code, using an IF asseveration 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 appoint and has not found any matching record it will display a subject matter 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 getup form.View or Delete Sales Record Here you can view all sales that have interpreted 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 conditi on it will add it back to the stock table. strike off 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 orchestrate a total for the customer and scar a receipt.It will also subtract items sold from the stock table and put them into the sales table. When unveiling items it will display the description of the item to soundatedate if the code it correct. 2. 8 specimen 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 carcass 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 ace 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 legal injury 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 sche me, a one to many relationship 2. 14 Security and Integrity of Data Firstly physical rise to power to the information processing system 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, spring them up using a text editor like notepad will give, just you lots of hush-hush 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 entranceway stripped 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 Sec urity 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 discussion 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 accommodation 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 resume 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 variabl e 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 running game Strategy. trial run Strategy The test strategy will include sample all input forms, if they accept all the data Testing of individual Menu System Options Testing of inputting handicap 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 like a shot 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 dish Should copy stock and sales table to a floppy disk 15 Check choke Feature Program should return to dos 16 Enter very large integer into an integer theme Program ma y crash 17 Entering character into a integer field Program may crash.Entering more then 20 characters in the Item Name field of operation Since the variable for this is string20 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.