Animal Lane Cattery Information Technology System Essay

The wight Lane Cattery, a privately owned small business, postulate an economical, update equal to(p), expandable, intimately accessible randomness constitution to track and document knobs deprivations for boarding/grooming services. The objective is to design and develop a system that fulfils the needs of the Cattery. An effective electronic filing system pull up stakes eliminate addled paperwork, minimize errors, and provide a method for quality customer service. I leave al unrivaled be designing and making the system that we choose for the Cattery.As the Cattery has expanded its boarding and grooming services to accommodate a f atomic number 18 of 15 contrives in separate pens, an increase in customer complaints cast been received concerning the Catterys inaccurate and time-consuming tracking of particular proposition client cultivation.This inefficiency means that clients consent to give an update of their felines in wreakation to the Catterys supply and has res ulted in service errors. At the moment, they part a flatbed database, which only allows you to work with genius table open at any time. The Cattery has considered using a pen and paper system, writing things come turn out of the closet manually and storing information on paper, bargonly a more efficient system would be a comparative database. Their ideal system is a relational database, and this go forth allow them to wipe out macros, historys, queries, and searches based on the information needed. This, t here(predicate)fore, is the system that I will be developing for the Catterys usage.ObjectivesThe user needs to be able to- aspect the information-search for specific information-print out receipts for clientsAlternatives in that respect are many relational database packages I could deem chosen to work with, but I buzz off decided to use the database package Microsoft Access because I set about great respect for bank note Gates and also, Microsoft Access is an older program, therefore any bugs in the system will hopefully have been fixed and the package amend.I could have apply Microsoft Works, but there cannot be any more than one table open at a time, and it is necessary that I have multiple tables.UsersThe users of this database will be the Catterys staff- full and part-time employees prudent for the care and grooming of the cats. The Office Staff will be able to view and edit the data, whereas the Grooming Staff will only view the information they need.ANALYSISThe software I decided to use here is Microsoft Access to create and view the database. The hardware needed is a keyboard to visualize data, a mouse, a printer to print out the receipts, and the computer monitor. exclusively data will be output using the printer.I will need to ensure that there is enough memory for a relational database to function. This should not be a problem, as Microsoft Access (which I have chosen to use) does not require that much memory space, and there w ill be plenty of space available on their office computer, which, early(a) than the necessary software components, will be used solely for the database used for the storing of data and the running of the Cattery.Backup copies of data will be stored on tape. The tape needs to be clearly labeled and stored in a water-tight case inside a fire-proof storage box away from the sign source of data, in case of fire or flood that may damage the computer that contains the authentic data. Using floppy disks as a form of backup was considered, but the database is relatively large and updated on a daily basis, so the floppy disks will not have a capacity large enough to adequately store the data.Data appealingnessThe data will be collected from the clients using a form that they will fill in giving the information needed by the Cattery.The fields required will be on the data grip form given to clients. These will be in the form of questions, such(prenominal) as the ones below-What is the c ats name and owners cope with information?-What is the cats vets contact number (in case of emergency)?-What is the cats meal schedule?-What are the boarding drop-off and pick-up dates?-What are the cats grooming requirements?There will doubtless be other questions that the staff will need to know the answers to.To update the data, I will need to remove true clients information and replace it with new data when the first cats are collected. The printed data will be the reports when a search is started, and a second report to give as a receipt to customers when they collect their pet.DESIGN twain tables will be developed owner information and services. The link in the midst of the two tables is the owner code. Each owner has only one address, but multiple cats may reside at the same address. Each cat has personal service needs even if it shares the same owner as another. The client names and cat names will not be used as key fields because there might be multiple clients with the same names or cat names. Office staff at the Cattery may view and modify the data in both(prenominal) tables, and the grooming staff may view data.Following are the hand-drawn designs of the database. start-off are the initial rough designs to show the basic layout of the database. I will then give a data capture form (next page) to one of the users (an office staff person) asking what things they think could be done let on and how the design of the database could be improved to make using it easier. The users comments will then be taken into handbill when making the lowest designs of the database, detailed so that anybody could create the same database that I will be making for the Cattery.Final Users Comments(after having reviewed the initial designs)How effective do you think the designs will be?What do you think could be improved, from what you have seen of the initial designs?What is lacking from the database (if anything)?Other commentsIMPLEMENTATIONOn the following pages are the print screens of the way the Catterys database was created (tables, forms, queries, reports, macro code etc).EVALUATIONThe original objectives outlined in my Identification stage were met. The Cattery now has a effectual and fast system to find and store their clients information, to view and search for specific information, and to print out things like receipts for clients.After having reviewed the owners comments and compared to the things I have changed, I feel I have improved the database enough for him to be comfortable with using it. I took in to account the things he mentioned about needing designs for reports and queries, and lessening vagueness of some designs.I feel I have achieved my objective in making the Cattery an effective, easy system to bring all their information.