|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
Accessing the data of a business
Description of problem
The aim for this coursework is to design a new system for an estate agent called Follys agents. ... Currently the company is using a filing cabinet to keep the current data, this takes up a lot of space and it is hard for the workers to access or amend the information. ...
· Low risk of data being erased as it can be stored on various backups.
· Not a lot of energy is needed to get data, this saves time and is efficient.
· Data can easily be presented in tables, graphs etc. ...
· If the computer crashes or there is a power cut, access to data in the computer is lost. ... The company is losing a lot of business because it takes a long time to find the right properties for the buyers, the company also needs to employ many extra staff because excessive manual work is required.
Analysis
This is my interview with the owner of Follys agents
How long have you had your own business for?
Along with my brothers I have been running this business for 18 years now.
What does your business involve? ...
The data will need to be stored in an organised way - using tables to present the data in a clear way i. ...
The data should be put under suitable field names such as: -
ID number- this gives each customer an ID, which when searching for a certain customer, the owner can just search for his ID number and the customers details will appear on the screen. ... Must have a range to help avoid data entry errors. ...
The system must allow the data to be organised into certain orders- e. ...
The system must be able to save the data- there will be a lot of data stored on the system and so it will need to be stored efficiently. ... The information has to be accurate because the data has to be passed on correctly to any inquiring customers. ... for name, the default will usually be set to 50, but if we reduce it to 20 or 30 then the system will perform faster, noticeably if the database contains vast amounts of data. ... Data will be inserted onto the system and I will see if there are any mistakes or errors made, if there are then I will try and improve the system. ... After this has been done the data can be printed. ... With this flowchart it will be easy for the user to search, edit, add/delete any data from the system. ... The information in a spreadsheet can also be able to show a graph or a chart, which will show the progress of a company or any other data. ...
Database - This is a collection of data organised for storage in a computer memory and designed for easy access by authorised users. The data may be in the form of text, numbers, or encoded graphics. ... Relational Databases in computer science are types of databases or database management systems that store information in tables-rows and columns of data-and conducts searches by using data in specified columns of one table to find additional data in another table. ... In conducting searches, a relational database matches information from a field in one table with information in a corresponding field of another table to produce a third table that combines requested data from both tables.
In my research I discovered that using a database was the ideal application for my system because it enables me to store data easily, to create forms and records, its more efficient, cost effective, saves space and is time effective. It also has the ability to keep my system well organised in tables and under suitable field names, queries can be run to search for data that satisfies certain criteria that are set by the user. Other applications are not suitable for my system because they are not suitable to sort out data and run queries like the database does. Although some spreadsheets and word processors have the ability to sort out data in alphabetical order, ascending or descending order with bullet points and with numbers these are not sufficient for my system. ...
Package
A software package is needed where all the data can be inserted. ... The response to the change of any data was immediate, the time it took to save the data is only two seconds and the time it took for the printer (a HP 690c) to respond was only two seconds. ... For the computer to save data on a floppy disk it took five seconds. ...
Data Collection
The company I am designing a system for would like to have a form, which is easy to use and contains all the information needed and also sends the information directly to the main database where it can be clearly viewed. ... This method is use for
The above screen shot shows the form that I have designed for the company to use, the form is simple and easy to use and is ideal for use by the business
Data Capture and Input
Barcode- a series of vertical lines with a unique identification code, laser scanners read the bar codes and the information is transmitted to a computer for processing. ... This isnt suitable for my system because my data is in small quantities and doesnt need a barcode system. ...
Key to Disk - This is typing the data onto the computer using a keyboard, although this isnt expensive and is easy to use, it does take quite a lot of time and errors are often caused by this method.
Approximate Word count = 4643
Approximate Pages = 18.6
(250 words per page double spaced)
|
|
|
|
|
|