Press "Enter" to skip to content

Design a computer system for a video hire shop Essay

I have realized that keeping client records on paper can be frustrating and none practical or easy to use. The purpose of this project is to produce a database for a company or an organization; I’ve chosen Vinnie’s videos.

My personal database will include customer data to make corporation and consumer relations simpler; the new program will be more sensible. An electronic database will make existence easier mainly because it will be superior to a card filling system and will conserve time and money. A computer system is greater than the old greeting card filing means for many reasons.

Example, searches can be executed instantly instead of many manual records being waded through, customer info for a 100 people may be copied very quickly to a normal letter. Vinny will be able to maintain customer information lists, detailing contact information, numbers on the clients videos, email lists of regular jobs that need to be performed i. e. check that has videos out; in order that updates can be delivered using mail merge. This will help Vinny carry on to info and on top of consumer relations and business. A search function pertaining to my database will make it simple to get letters detailing special offers which are customer specific to be sent out easily.

After considering the positives and negatives of the two systems I use decided that it can be definitely more practical to use a computer system over a card stuffing system. Pros and cons of current system: Vinny currently includes a very ancient filling system, It has a great deal weaknesses. It requires a long time to look for records, as they are stored in a filling cabinet. When editing and enhancing a record you must remove the entire card and rewrite that, it is time eating to add fresh records. To re-sort the records could take a very long time as it would obviously need to be done personally.

To search for information is also frustrating, especially if you are searching for a number of buyers with comparable records for a few purpose. Nevertheless the database is definitely comprehensive and does contain all the records necessary. What I have to do is design and makes a brand new database with the information through the old a single transferred into it. There are also many programs which i could consider using, they may be Microsoft word, Microsoft excel or Ms access.

Let me need to make use of a database creation package like MS Access, Fox Expert, DBASE 2 or 4 or Borland Database Manager to create my personal database desks, queries, varieties, reports and macros quickly and also system them with the Visual Standard programming screenplay to make my database in a professional working program. Based on the user requirements MS Gain access to is the best a single also because it is mostly familiar to people. I will need a phrase processing package deal like MS Word, Notepad, WordPad and Word Perfect.

MS Word is the best someone to use as you can use expression art and insert pictures or print screens in the document and in addition is mostly employed by people. Components needed: We would like a computer which could run Microsoft company Access and Microsoft Word just in case I must use the mail merge. For this I will use a QWERTY keyboard for the manual input of data as well as the commands intended for the computer.

Let me need a mouse or trackball to design the database varieties, to get around the GUI of the OPERATING-SYSTEM and to push copy and paste info. I will have to use a 31/2 inch floppy disk and drive or possibly a CDRW disk and travel in order to save my own database and to make backups of my database. I will only use a CDRW if the database exceeds 1 . 38-1. forty-four MB.

CDRW’s can hold coming from 500-700 MB of information. Let me need a inkjet printer to print out the design of my personal database of for expression documentation of the database. The machine should have in least 300 MHZ hard drive speed, and 5 GB memory, it will have in least a 128 MB RAM.

Problem1: a system supervision to put the videos in order Form of outcome: a repository Information to be output: video title, online video director, primary actor, yr released, duration and genre, how many copies are available and how most are on loan. Data necessary to produce the output: video name, video director, main acting professional, year unveiled, length and genre, which is provided by Vinny. Desired final results and performance conditions: It has to be fixed so you can view a certain sort of genre or perhaps year. Testing: To see if all the correct data are in the right question. Problem two: needs a program to store every one of the members’ brands and details Form of end result: a repository Information to get output: name, address, consumer number, mobile phone.

Data needed to produce the output: name, treat, user quantity, telephone. This is provided by Vinny. Desired effects and performance requirements: member’s particulars available and so we can speak to them if perhaps needed.

Screening: not needed Problem 3: I actually don’t include a system to determine who has what video inspected and who may have videos which have been over credited. Form of result: database Details to be result: name, customer number, video rented, day taken out, date due back again Data necessary to produce the output: name, user number, online video rented, particular date taken out, date due again. This will be provided by Vinny, anyone that rental prices a new video will be created the databases.

Desired final results and performance conditions: a list to see which usually videos are recorded loan. When ever somebody rental prices a video out all I would like to have to do is usually click on the film name and type their particular name in. The leasing time allowance will be 3 days and automatically joined Testing: find out if the people with taken a out have a book because of on the databases Analysis of Strategies for Back-up and Security. The system will be backed up about CD-RW’s daily and on hard disk drives and a server. The database will have an protected modification password and it will become write-protected so that it cannot be removed.

If a staff member needs to access the data source to modify it, then a personnel password is necessary. It will not open until the password is correct Info Flow Mistake Checking To ensure the information is correct the staff will send the people an invoice with their particulars they have put and fastened is another form to complete the correct info and then collect it and update the repository. For the videos employees will do daily checks on the database to determine any unknown looking data in the repository and will modify this info by receiving the video and re-entering the video data once again.

Or the personnel will do two copies details identical to each other because the info will be put twice and if they are certainly not identical then one or the various other or both are changed together with the correct data. Skills The consumer is a qualified pc customer and will not want any sort of training, he would enjoy it to be user-friendly though, and so if any new staff join, it will be easier to pick up.