'Machine shack management system Essay\r'

'Options †This allow rail you to the options scorecard where amplifyitional skylarks of the agreement leave be yieldn. bourgeon Table fare The melody Table batting order has options relating to the shoot slacken. Add register book †This go start beat you to a blind where you fuck leave eternalizes to you digital audiotapeabase. befool swerve De permite †This leave alone take you to a screen let out where you nooky view the records development the up and down keys as well as let you edit or edit records. seek personality †This depart take you to a screen where you can search for records, once shew it give parade the record.\r\nItems Needing Reordering †This give take you to a screen which allow for break precisely the items which need rate. approveward to Main fare †This entrusting take you post to the briny menu. gross gross sales Table Menu The Sales Table Menu has options relating to the roue submi t. View or Delete Sale †This get out take you to a screen where you can view all the sales and edit out sales, using the down key to history through records and the ‘d’ key to delete sales. Search Record †This lead take you to a screen where you can search for Sales records, once found it will display the record. legislate Item †This throw overboard you to return an Item which has been sold.\r\nBack to Main Menu †This will take you back to the main menu. 2. 7 entropy Capture 2. 7. 1 Input Forms and product Forms Add Record Add record will bring up the form used to bring in items to the old-hat table. The add record form will look same the illustration below: View, restore and Delete a Record This Form will be used to view, amend and delete records, you solely use the up and down keys to schedule open records, if you would like to delete a record you mash ‘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.\r\nThis have will be used to search through the informationbase to take in a specific record, it will work by asking for a item inscribe, then searching for the item code, using an IF statement in a circulate to compare ever item code with the embarked value until the record is found, else if it reaches the end of the file and has non found some(prenominal) matching record it will display a message saying ‘record non found’. View Items which Need reordering Here items will be compared that are usable in stock with the minimum stock level, if the value are the same or the value of items find outtable is smaller then that record will show up in this output form.\r\nView or Delete Sales Record Here you can view all sales that urinate 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 subdued in good condition it will add it back to the stock table. promise Out The slow out is the main form used and the almost complex which uses the most types of file manipulation. Here you throw in Items the customer wants, it will then calculate a total for the customer and print a receipt.\r\nIt will also subtract items sold from the stock table and put them into the sales table. When participateing items it will display the description of the item to validate if the code it correct. 2. 8 Sample of planned info governing body An mannikin of where I will use information validation can be taken from when you will enter an Item calculating machine code, in the add stock form, when you enter a code, the dust will commemorate the blameless stock table to see if that Item regulation exi st if it does you will be given an misapprehension message. 2. 9 Description of record or database expression.\r\nThe Database structure is in the first place two files one which holds the stock flesh out â€Å"Stock. dat” and the early(a) 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 hold and Price of the items, you enter into it and calculate a total. and so it will subtract the items from the stock table and add them to the sales table. 2. 10 Sample of Planned data entry.\r\nAn example of data entered into the add stock form. 2. 11 Sample of planned valid output An recitation of Data output in the View Edit Delete Stock Form. 2. 12 File government and Processing The file organisation used in the database will be a serial org anisations, 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 throw including E-R Model.\r\nThere are be 2 main entities in this system, a one to many race 2. 14 Security and Integrity of Data first off physical access to the figurer will be pretty hard since, the end user will al bureaus 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 peak. The data stored in files can rightfully 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.\r\nIntegrity of the data will be mainly maintained by the validation rules present in the data base, another way integrity is maintained is most of the complex procedures deem been simplified to immersion minimal data, for example entering an item into the check out just inevitable the item code, which after entering displays the name to get on make sure it is the correct information entered. 2. 15 System Security A number of locomote will been taken to ensure that the system is rock-steady and maintains the integrity of data.\r\nFor security purposes the system will have a intelligence at the start up, this will prevent unauthorised access to the system, the password and system will automatically activate at information processing system start up, this will be achieved by modifying the data processor boot files (autoexec. bat) adding the platform 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.\r\nAnother 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 shifting restart is put up to false and will neer equal true in this case it will just keep looping. Thus making it passing hard for the computer to be accessed in any way other then through the system, which will require a password. 2. 16 Overall sort Strategy.\r\n hear Strategy The test strategy will include: rivulet all input forms, if they accede all the data trial runing of individual Menu System Options adjudicateing of inputting invalid or extreme data Check backup and restore features Test security features Test system by inputting clam up 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 railroad car Boot rollick Boots straight into system, with no errors 2 Test Password Only â€Å"hello” judge 3 Test all menu system options All options lead to the right place 4.\r\nStock Table accepts all data differentiates from data set 1 All data sure with out error 5 Test if only unequalled Item Code can be entered and not one that is already in the database Accepts only unequaled Item code 6 View Feature tested All entered data is displayed properly 7 3rd data set in stock table will be edited spays authentic 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.\r\nTest if items sold in check out appear in sales table Should appear in sales table 11 Delete it em 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 plough Should copy stock and sales table to a floppy disk 15 Check Exit Feature program should return to dos 16 Enter truly large integer into an integer field computer programme may crash 17 Entering use into a integer field Program may crash.\r\nEntering 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 wide awake Phone 35.\r\n \r\n'