ICT - Changing the System of a Video Library Essay Example for Free

ICT Changing the System of a Video Library Essay Distinguish area The present framework is a manually written and hand took care of by Mr Roberts. It is a paper database where all subtleties of the individuals, exchange and return subtleties are put away. Mr Roberts as of now works all the framework without anyone else and he does this to track all the appointments out of the recordings, he does this by pen. He finds the page in the book dispensed to the part, composes when the individual needs to bring it back in, takes the installment at that point gives the video to the part. At the point when another part joins Mr Roberts brings all the subtleties down in his book, at that point gives the new part a part number. Mr Roberts needs to check each night for past due recordings. At the point when an individuals page is full, at that point Mr Roberts needs to get another page, this fair adds to the ever-developing document of Mr Roberts. There are loads of issues with the framework, it is moderate, it would wear out with over use, he can't adapt to the developing number of clients, He needs to check each night to see which recordings are past due and hand type each letter and send them off that night. This would be progressively troublesome when bunches of individuals join. Another issue is that the recordings all must be numbered and when a video is taken out a card is placed in the first case giving the video number and bring go back. The new framework would need to show all the subtleties of the individuals on one screen and show when last rental and return was. It ought to have the option to show every single past due video on one screen. It ought to be extremely quick and accelerate all parts of the shop. On the off chance that the database is quicker and simpler to oversee, at that point the quantity of individuals will increment and in this way so will the benefit. Jonny Sharpe Potential arrangements Mr Roberts could tackle every one of his issues by utilizing a file organizer. This would take care of every one of his issues with data taking care of. The upsides of this would be that a file organizer is simpler to adapt than a documenting book, the weaknesses are that it is as yet dependent on paper and they could without much of a stretch be harmed or lost. Another issue is that it is still tedious and would not be any quicker, in the event that anything more slow than previously. Another approach to adapt to this issue is putting all the documents onto a PC. The PC would store all the data without any problem. The upsides of this are it would altogether improve the speed and simplicity of running the video shop. The inconveniences are that it might cost a great deal of cash and all staff may not be prepared in how to utilize a PC A PC program could be writ yet mastery would be required for this and this skill I don't have. The following best option is that you could utilize a previously existing project, for example, Microsoft Access. The data would be put away on numerous spread sheets, the data would comprise of the considerable number of individuals subtleties and the video subtleties also. These future great since they can deal with bunches of duplications and can look through data Imprint encourage Framework Choice Microsoft office xp proficient release. Pcworld: à ¯Ã¢ ¿Ã¢ ½519 Inc tank Any PC could be picked as long as it has Microsoft get to and a printer for printing reports. Programming Justification Legitimize decision of programming: Word: The program needs to deal with numbers however word is truly adept at composing letters. Exceed expectations: This program would be alright for the video shop yet there would need to be 1 sheet for the recordings and 1 sheet for the individuals subtleties. This program would not have the option to type letters up and print the letters off. Access: This program is incredible, this is on the grounds that you can blend the video subtleties and the individuals subtleties together to give records of advances. This program can likewise deliver reports in letter structure and print them off. Information required 1. This database is for the recordings, it should show the number code, name. 2. Individuals subtleties ought to be appeared on this page, name, address, enrollment number, phone number, current video leased and the date it is expected back. Configuration segment This shows I have made two tables to store data, one for the individuals subtleties and one for the video subtleties. I have entered 50 recordings and 5o individuals into the tables. I have planned the framework to alarm me when there are past due recordings and to have the option to book out recordings and book in recordings effortlessly. I connected the two together by making a connection between the enrollment number and the video number as demonstrated as follows. These next pictures are of my inquiries. They are update questions which update booking in and booking out of recordings. They are connected between the two tables and show the recordings booked out and the participation number of the individual alongside certain subtleties. This is my structure plan. The structure is for a part to fill in to naturally add his subtleties to the individuals table. This is my report. This is essentially to advise individuals that they are in control of a past due video and they have to bring it back. Individuals have their own enrollment no and every video has its own video number. Thusly individuals and recordings dont get stirred up. This is an application structure for the video shop, individuals are approached to round out fundamental subtleties. Investigation 1) What do I need from my database. I need it to store data about my individuals, including their name, address, phone number, participation number, date of birth. Additionally in every part record will be put away the video they have leased (its code, not its title to speed things up) and furthermore the date it is expected back. Clients can just lease one video for each day and it must be restored the following day. I likewise need the database to store data about the recordings, including its code, title, value, authentication and class, eg awfulness, activity, parody and so on. I need a framework that will let me book recordings in and out rapidly, just by entering the individuals number and the video code. I likewise need a framework to check which recordings havent been returned and make a letter that could be conveyed in the event that it hasnt been returned following multi week. Once in a while people overlook they have it so this ought to be a well mannered update. In the event that they havent returned it following 2 days, at that point I generally telephone them, so I would require it to create a rundown of names and phone numbers. I will respond to different inquiries sometime in the not too distant future as there are clients in the shop. Respects. Mr Roberts 2) To gather information from new individuals I have a structure that they round out. They compose on it their name, address, tel. number, and date of birth. I compose their new participation number on it. 3) Each part has a participation number. It is a four-digit number, beginning at 1000. 4) I dont use Mastercard subtleties as there is an excessive amount of security required. 5) For new individuals I need two types of recognizable proof, one with their name and address, for example a bank proclamation or gas bill for instance and one with their photograph on, for example theirs drivers permit or visa. 6) I havent got a secret key framework. In the event that you figure I ought to have one told me how you figure it would function. The issue is that clients would need to disclose to me their secret key and different clients could catch it so it wouldnt be that protected. Assessment I think the last item fulfills the guidelines set by Mr. Roberts. The main missteps I have made is that I have given the model individuals, participation numbers beginning at 200 and they are just 3 digit. The last item can do everything indicated in the plan necessities made by Mr. Roberts. The assessments of the clients would be on the survey I made. The main enhancements that could be made to my database is that I could perhaps create a programmed report showing all the data of the part on a report whos video is late, rather than simply having a fundamental layout.