Design a computer system for a video hire shop Essay

I cook noticed that keeping customer registers on paper can be succession go through and neither practical or easy to uptake. The aim of this project is to clear a entropybase for a comp some(prenominal) or an organization I exhaust chosen Vinnies videos. My database testament include customer tuition to take a shit organization and customer relations simpler the red-hot governance leave be more practical. An electronic database pass on make life easier as it result be superior to a card fill up transcription and entrust save time and money. A computer system is better than the obsolescent card filing method for many reasons.Example, searches can be carried disclose at once rather than many manual records being waded through, customer tuition for a hundred people can be copied almost instantly to a standard letter. Vinny give be able to keep customer in contriveation angles, detailing contact selective informationrmation, stats on the customers videos, li sts of regular jobs that need to be performed i. e. check who has videos pop in order that notices can be send using mail merge. This depart help Vinny keep up to data and on top of customer relations and business.A search pass away for my database will make it simple for letters detailing special offers which atomic design 18 customer specific to be sent out easily. After considering the pros and cons of the devil systems I ready decided that it is definitely more practical to give a computer system over a card filling system. Strengths and Weaknesses of current system Vinny currently has a very primitive filling system, It has a lot weaknesses. It takes a long time to find records, as they argon stored in a filling cabinet.When editing a record you must remove the entire card and rewrite it, it is time overwhelming to add new records. To re-sort the records would take a very long time as it would obviously have to be done manually. To search for information is also time co nsuming, especially if you ar looking for a chip of customers with similar records for some purpose. However the database is comprehensive and does contain all the records necessitate. What I need to do is design and makes a new database with all the information from the old one transferred into it.There are also a number of programs that I could consider using, they are Microsoft word, Microsoft excel or Microsoft access. I will need to consumption a database creation package the likes of MS entre, Fox Pro, DBASE II or IV or Borland infobase Explorer to bring on my database tables, queries, forms, reports and macros easily and also program them with the Visual Basic programming hired hand to make my database into a professional running program. According to the substance abuser requirements MS Access is the best one also because it is mostly familiar to people.I will need a word processing package like MS Word, Notepad, WordPad and Word Perfect. MS Word is the best one to u se because you can use word art and insert pictures or photographic patsy screens into the document and also is mostly used by people. Hardware needed I need a computer that can run Microsoft Access and Microsoft Word just in case I need to use the mail merge. For this I will use a QWERTY keyboard for the manual foreplay of data and the commands for the computer. I will need a mouse or trackball to design the database forms, to navigate the GUI of the OS and to move copy and spread data.I will need to use a 31/2 inch floppy magnetic disc and drive or a CDRW disk and drive in order to save my database and to make backups of my database. I will only use a CDRW if the database exceeds 1. 38-1. 44 MB. CDRWs can holdup from 500-700 MB of information. I will need a printer to print out the design of my database of for word documentation of the database. The system should have at least 300 MHZ hard drive speed, and 5 GB memory, it should have at least a 128 MB RAM. Problem1 a system m anagement to put the videos in order Form of output a database culture to be output video title, video director, important actor, form released, length and genre, how many copies are available and how many are on loan. Data needed to gravel the output video title, video director, main actor, year released, length and genre, which will be provided by Vinny. Desired outcomes and operation criteria It has to be sorted so you can run through a authoritative type of genre or year. Testing To see if all the cook up records are in the right query. Problem 2 needs a system to store all the members names and addressesForm of output a database Information to be output name, address, user number, telephone. Data needed to produce the output name, address, user number, telephone. This is provided by Vinny. Desired outcomes and performance criteria members details available so we can contact them if needed. Testing not needed Problem 3 I dont have a system to see who has what video checke d out and who has videos that are over due. Form of output database Information to be output name, user number, video rented, date taken out, date due backData needed to produce the output name, user number, video rented, date taken out, date due back. This will be provided by Vinny, anyone that rents a new video will be entered into the database. Desired outcomes and performance criteria a list to see which videos are on loan. When somebody rents a video out all I want to have to do is click on the film name and type their name in. The rental time grant will be 3 days and automatically entered Testing see if the people who have taken a video out have a book due on the database Analysis of Strategies for Backup and Security.The system will be backed up on CD-RWs daily and on hard disk drives and a server. The database will have an encrypted pass password and it will be write-protected so it cannot be deleted. If a cater member needs to access the database to modify it, then a lag password is needed. It will not open until the password is correct Information Flow Error Checking To ensure that the information is correct the staff will send the members an invoice with their details they have inputted and attached is an early(a) form to fill in the correct information and then collect it and update the database.For the videos the staff will do daily checks on the database to see any obscure looking information in the database and will edit this info by getting the video and re-entering the video data again. Or the staff will do two copies of information analogous to each other because the information will be inputted twice and if they are not identical then one or the other or both are changed with the correct information. Skills The user is a competent pc user and will not need any sort of training, he would like it to be user friendly though, so if any new staff join, it will be easy to pick up.