Saturday, April 6, 2019

Construction of a Membership Table Essay Example for Free

Construction of a Membership Table EssayThe flow rate musical arrangement that working class use is a manual system and it has proved inefficient, and very easy to lose. Therefore, I offer a computerised database system. computer software V Programming SolutionFor ease, and speed of use, I propose to use the megabucks option. I choose this because the options for everything the database needs are already at that place, and rather than waste time trying to stimulate a sort to make these options in my own programming solution, I forget save more time and effort using the package MS ACCESS 97. Also, my programming skills are next to nothing.The PackageAdvantages* Easier to learn as very little programming is involved* The tools for creating the user interface are already available, built into the program which makes construction of the database far quicker.Disadvantages* Depending on the package, this option could be far more grueling, due to problems such as a lack of f lexibility, lack of options etc.The self-programmed solutionAdvantages* Program impart be specific all options stand be created so that it get out do on the nose what it needs to do.Disadvantages* entrust take longer to program* I cant programData RequirementsThe data I will require falls into two different categories member and supplier. The data required will vary depending on which category it falls into.MemberSupplierName of member(e.g. Joe Bloggs)Date of members alliance in formatting ofDD/MM/YY (e.g. 24/07/84)Date of adaptation of membership in format of DD/MM/YY (e.g. 12/06/01)Members dear addressMembers telephone dependName of supplier(e.g. Flip)Name of product sold(e.g. Tom centime New Wave)Type of product sold(e.g. Deck)Price of product(e.g. 50)The members data will be dispassionate by entering all the information from a membership form. The data will not be entered into the database until all the fields on the form are complete. An example of the membership f orm will be shown later in this section.The suppliers data will necessitate to be entered from the current lists. It will be difficult to enter this data if the current list has been lost. The current procedure if this happens is to re-make a list of suppliers names from their current stock, and re-make the complete list by contacting the respective suppliers. By going through the stock, most of the data of the items supplied will be found. However, in some cases, contact will be necessary.Validation of Data MembersThe data entered whitethorn be abuse when being entered. Verification and sensibleation will help to get round this problem. Project operates a system in their skateparks, where anyone under 17 MUST wear a helmet for protection. This is down to insurance policy reasons. Helmets, however, are not the most fashionable piece of clothing you could ever wear, and many members try to engender a way out of getting out of wearing them. Therefore, careful attention essentia l(prenominal) be paid when taking down members details to make received that the data is check into against any valid form of identificationI.D. number This is automatically created by the database as a key field. This has a remissness value of 000, but will increase in value for each new member.Name This can be checked against any forms of identification, e.g. bus passes, library cards, national insurance cards (if applicable)Date of birth There is an obvious mistake if someone kick downs a birth date making them out to be 102. However, minor mistakes, such as a year or two out, can be checked against the DOBs on bus passes, national insurance cards etc. The format will also suffer to be correct, as it is being entered in the format DD/MM/YY. The date field will be set to take only when the U.K. format, which is the same as supra, whereas the American format is MM/DD/YY.Date of registration the staff will fill this in as the data is entered. The same validation checks as abov e will be entered.Members full address The staff can check this in the same way as the name, age etc. They should ask for any forms of identification which contain all this information.Members telephone number Validation for this will be rather difficult, as there are very few, if any, forms of identification that give out a telephone number for legal reasons. Therefore, the number should be phoned as soon as possible to verify that the phone number is correct.SuppliersSuppliers are not going to give out insincere information to a company/shop, not if they want to stay in business. This means that Project will not have to worry about finding out if information is true, but making sure it is entered correctly.I.D. number This is entered in the same way as the i.d. field for the members database.Name of supplier As mentioned above, the only problem is making sure that this goes in properly e.g. Shorttys instead of Shortys.Address of supplier This is an absolute must to be entered cor rectly. Whereas in the name, if a mistake was made, it would still be easy to tell what the name was. However, in the address, a mistake in the number or street could go unnoticed, therefore delivering orders, mail etc to the wrong address.Phone number of supplier This, again, must be entered correctly for the reasons listed above. Project could find themselves desperately soon of stock if they could not contact the suppliers to place orders.Name of product supplied Not only does Project have a large list of suppliers, each supplier also has a list of products supplied to Project. This means that there is a lot of data to do with stock needing to be entered correctly. Again, the only way to do this is visually making sure there is no mistake when entering in the data.Item number every product has a different item number. This insures the uniqueness of each product, so that the stock system knows exactly what product is sold.Type of product Project doesnt just sell skateboards. The y sell shoes, clothes, accessories, hardware, safety gear and more. sooner than have to check in the storeroom what a product is, the database can simply tell them. This must have the type entered correctly. The only chance of a typo occurring in this is if I make a mistake during the implementation. The data in this field is selected from a drop-down list.Price of product If the price is wrong, customers will be over/under charged. This will not be good for Project. If they undercharge, they lose money. If they overcharge, they lose customers. Therefore it is greatly important that the price is entered correctly.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.