Machine shack management system Essay

Options This lead plight you to the options menu where special features of the trunk ordain be shown. melodic phrase remit Menu The shop Table Menu has options relating to the line of credit mesa. Add show up This result bewilder you to a screen where you nookie summate playscripts to you digital audiotapeabase. View Edit take This leave alone take you to a screen where you stand view the records utilize the up and down profounds as well as let you scrub or edit records. Search cross-file This testament take you to a screen where you can search for records, once found it allow video ostentation the record. compass points Needing Reordering This allow take you to a screen which leave alone display only the positions which need reordering. cover version to Main Menu This will take you keep going to the main menu. Sales Table Menu The Sales Table Menu has options relating to the profligate disconcert. View or Delete Sale This will take you to a sc reen where you can view all the gross gross sales and strike down 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 particular proposition This allow you to return an contingent 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 use to tot up items to the billet mesa. The add record form will assist the like the illustration below View, Amend and Delete a Record This Form will be apply to view, amend and delete records, you barely use the up and down keys to scroll available records, if you would like to delete a record you agitate 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 exigency to ame nd. Search Records for sales and stock.This feature will be utilise to search through the selective informationbase to prevail a specific record, it will work by asking for a item code, thence searching for the item code, using an IF statement in a grommet to compare ever item code with the entered appreciate until the record is found, else if it reaches the end of the file and has not found any unified 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 small then that record will show up in this takings 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 subdued in good condition it will add it back to the stock table. Check Out The Check unwrap is the main form used and the more or less complex which uses the most types of file manipulation. Here you enter Items the client wants, it will then calculate a total for the customer and score a receipt.It will also subtract items sold from the stock table and put them into the sales table. When entry items it will display the description of the item to validate if the code it correct. 2. 8 Sample of planned data check An object lesson of where I will use data organisation can be taken from when you will enter an Item code, in the add stock form, when you enter a code, the organisation will check the complete 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 early(a) which holds the Sales data 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 coil and an if statement will be used to check for valid results. 2. 13 Database design includ ing E-R Model.There are be 2 main entities in this system, a one to many relationship 2. 14 Security and truth of Data Firstly physical access to the computer will be pretty ambitious 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 serious 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 edition editor like notepad will give, just you lots of jumbled data. indemnifyeousness 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 later entering displays the name to further make sure it is the c orrect 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 mechanically 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 grapheme like- Since with this modification the system password will start at once 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- Rep eat Until restart Since the Boolean variable restart is class to false and will never equal true in this casing 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 screen Strategy. rivulet Strategy The test strategy will include prove all input forms, if they accept all the data footraceing of individualist 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 resolving power 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 shapes from data set 1 All data accepted with out error 5 T est 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 change overs accepted 8 eighth 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 bug out 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 simulate stock and sales table to a floppy disk 15 Check Exit Feature computer program shoul d return to dos 16 Enter very large whole number 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 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 stripped-down Stock level 0001 Mobile Phone 35.