Design a computer system for a video hire shop Essay

I bem purpose noticed that keeping customer records on paper send packing be age consuming and neither practical or easy to office. The aim of this project is to score a infobase for a comp either or an organization I pick by chosen Vinnies ikons. My database forget include customer instruction to pay organization and customer relations simpler the recent dodging ordain be more practical. An electronic database dep guile suck life easier as it impart be superior to a scorecard change establishment and volition carry out time and money. A computer brass is better than the old card register method for galore(postnominal) a(prenominal) reasons.Example, searches endure be carried out instantly rather than many manual records being waded through, customer info for a hundred people passel be copied almost instantly to a standard letter. Vinny get out be subject to keep customer information lists, dilate contact information, stats on the customers idiot boxs, lists of regular jobs that guide to be performed i. e. check who has paintings out in order that notices can be move using mail merge. This pull up stakes attention Vinny keep up to data and on top of customer relations and business.A search function for my database ordain make it simple for letters detailing exceptional offers which be customer specific to be sent out easily. After considering the pros and cons of the deuce systems I lead decided that it is by every last(predicate) odds more practical to custom a computer system everywhere a card filling system. Strengths and Weaknesses of current system Vinny currently has a very patriarchal filling system, It has a lot weaknesses. It takes a long time to find records, as they are stored in a filling cabinet.When editing a record you essential remove the entire card and edict it, it is time consuming to add new records. To re-sort the records would take a very long time as it would obviously confound to b e done manu all toldy. To search for information is also time consuming, especially if you are looking for a mo of customers with correspondent records for some purpose. However the database is comprehensive and does hold in all the records adopted. What I deprivation to do is design and makes a new database with all the information from the old one transferred into it.thither are also a number of courses that I could consider using, they are Microsoft word, Microsoft pass or Microsoft feeler. I willing get hold of to put on a database creation piece of ground like MS recover, Fox Pro, DBASE II or IV or Borland Database explorer to create my database tables, queries, forms, reports and macros easily and also program them with the Visual Basic programming rule book to make my database into a professional racetrack program. According to the substance ab exploiter requirements MS Access is the best one also because it is loosely familiar to people.I will submit a wor d processing parcel like MS Word, Notepad, WordPad and Word Perfect. MS Word is the best one to use because you can use word art and insert pictures or cross screens into the archive and also is mostly used by people. Hardware ask I need a computer that can unknot 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 input of data and the commands for the computer. I will need a mouse or trackball to design the database forms, to sail the GUI of the OS and to move repeat and paste data.I will need to use a 31/2 inch floppy disk and force or a CDRW disk and tease in order to save my database and to make patronizeups of my database. I will only use a CDRW if the database exceeds 1. 38-1. 44 MB. CDRWs can hold from 500-700 MB of information. I will need a printer to print out the design of my database of for word support of the database. The system should have at least(prenominal) 300 MHZ hard sa fari speed, and 5 GB memory, it should have at least a 128 MB RAM. Problem1 a system management to put the goggle boxs in order Form of widening a databaseInformation to be outfit tv set title, video director, main actor, year released, duration and genre, how many copies are operational and how many are on loan. Data needed to produce the output video title, video director, main actor, year released, length and genre, which will be provided by Vinny. Desired outcomes and carrying into action criteria It has to be sorted so you can know a certain case of genre or year. exam To see if all the recompense records are in the right query. Problem 2 ask a system to store all the members abduces 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 carrying into action criteria members details available so we c an contact them if needed. Testing not needed Problem 3 I dont have a system to see who has what video checked out and who has videos that are over callable. Form of output database Information to be output name, user number, video rented, determine 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 death penalty criteria a list to see which videos are on loan. When somebody rents a video out all I involve to have to do is click on the film name and type their name in. The rental time allowance 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 day-to-day and on hard disk drives and a server. The database will have an encrypted modi fication password and it will be write-protected so it cannot be deleted. If a lag member needs to access the database to modify it, whence a staff password is needed. It will not apply until the password is temper Information ply Error Checking To ensure that the information is correct the staff will send the members an chronicle with their details they have inputted and attached is some early(a) form to fill in the correct information and then collect it and modify the database.For the videos the staff will do daily checks on the database to see any mix up looking information in the database and will edit this info by acquiring the video and re-entering the video data again. Or the staff will do deuce copies of information identical to each other because the information will be inputted in two ways 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 tra ining, he would like it to be user friendly though, so if any new staff join, it will be easy to pick up.