We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Choice Of Software Essay Sample

essay
  • Pages: 5
  • Word count: 1,350
  • Rewriting Possibility: 99% (excellent)
  • Category: software

Get Full Essay

Get access to this section to get all help you need with your essay and educational issues.

Get Access

Introduction of TOPIC

I have decided to construct the system on Microsoft Access. The software allows easy use and enables data and information to be presented in a clear straight forward way. This is due to a number of features contained within Access. By utilising some of these features, I will be able to construct a system, which is easy to understand as well as being user friendly. Access will allow me to construct tables by which data and information is recorded through the use of forms. This will allow the user to record data with the greatest of ease. There are a number of other key features, which will be used to construct the appointment system. These are as follows;

* Macros: These will allow me to automatically execute an operation at the click of a button.

* Queries: These provide an easy way of asking questions of the database and getting it to produce useful and relevant information to those questions.

* Reports: This is a way of presenting data on the screen or in print format, for example generating a report on the progress of a job.

* Protection: This feature will enable me to protect the system from unauthorised access to data and information stored on the system.

* Data validation: This will help the user to enter the correct information at certain locations.

* Formatting: This will allow the data and information stored in the database to be presented clearly and easily by the user.

* Calculations: This will allow the system to automatically do any calculations, making it easy for the user to use the system.

Therefore by using Microsoft Access software it will enable me to meet all the requirements of the new system, that is, it will allow me to overcome some of the key problems of the old system.

System overview

When the system is opened, the main switchboard will automatically execute. This will give the give the user a number of options, for example adding a new customer. All the user has to do is to select an option and using the mouse click on the assigned button. At all times there is an exit button, along with a number of other options. If the user wishes to return to the main switchboard all they need to is to click the exit button. Depending on where the user wants to go, all they need to do is to select one of the options (see flow chart of the new system).

Input data

The input data is the data that is entering the system (see data flow diagram of new system). This will consists of the foll

owing; * Clients details: Personal information about the client,

Sorry, but full essay samples are available only for registered users

Choose a Membership Plan
this includes name, address, telephone number…

* Any basic enquires into making an appointment.

* Appointment details: This is information about the appointment, for example the type of service the client wants. This also includes time of the appointment.

Processing of the input data

The customer’s details are stored for future reference. This is in case a client needs to be contacted in an emergency or if their job takes longer than usual. The initial enquiry is used to identify whether the garage carries out that service, as the garage does not offer ever service known. Once a client selects a service, that the garage offers, then certain details will be required. For example the time of the appointment. This is important as a client maybe busy on a day when a slot is available by the garage.

Output data

The output data is the data that is retrieved after the processing. The output data is as follows:

* An appointment for the client.

* The day and time of the appointment for the client. This can be printed out on request.

* The clients details stored on the database for the garages reference.

Normalisation of data

Un-normalised form (0NF)

CLIENT (ClientID, Title, Surname, Forename, Address1, Address2, Adress3, Address4, Telephonenumber)

Repeating data

(Jobnumber, servicetype, MechanicID, Title, Surnamne, Forename, Address1, Address2, Address3, Address4, Homenumber, Mobilenumber, appointmentdate, starttime, finishingtime, cost)

First Normal Form (1NF)

CLIENT (ClientID, Title, Surname, Forename, Address1, Address2, Adress3, Address4, Telephonenumber)

APPOINTMENT (Jobnumber, servicetype, MechanicID, Title, Surnamne, Forename, Address1, Address2, Address3, Address4, Homenumber, Mobilenumber, appointmentdate, starttime, finishingtime, cost)

Second Normal Form (2NF)

CLIENT (ClientID, Title, Surname, Forename, Address1, Address2, Adress3, Address4, Telephonenumber)

MECHANIC (MechanicID, Title, Surnamne, Forename, Address1, Address2, Address3, Address4, Homenumber, Mobilenumber)

APPOINTMENT (Jobnumber, servicetype, MechanicID, ClientID, appointmentdate, starttime, finishingtime, cost)

Third Normal Form (3NF)

CLIENT (ClientID, Title, Surname, Forename, Address1, Address2, Adress3, Address4, Telephonenumber)

MECHANIC (MechanicID, Title, Surnamne, Forename, Address1, Address2, Address3, Address4, Homenumber, Mobilenumber)

SERVICE (servicetype, cost)

APPOINTMENT (Jobnumber, servicetype, MechanicID, ClientID, appointmentdate, starttime, finishingtime, cost)

Security

The appointment system will be protected via the protection feature of Access. There is a password option, which will not be activated once the system is completely constructed. This due to the problem that the password could be forgotten, if it is not written down. However, should the user wish to activate the password, they can do so by going to the Tools at the top of the screen. The user then selects security and clicks on the set database password to activate the password. This will be explained further in the user manual.

Test strategy

The systems test strategy will consist of the following:

* Functional testing: This ensures that the systems macros and all other command buttons are tested under various consequences.

* User testing: This allows the user to experiment with the system to identify any problems which they may encounter and/or if the meets there requirements.

* Data testing: This consists of inputting fictional data into the system to identify any errors that may arise. This also includes checking that all formulas that are used are operating correctly.

* Finally running through the system continuously to identify any anomalies, which need to be corrected.

Data entry and validation

The set settings within the system won’t need to be reset or altered by the user. The system will be set up so that as soon as it is installed they can open it and use it straight away. The user really won’t need to alter any of the set settings within the system unless they wish to change small minor details, such as colour schemes.

A good part of the system will be data validated. This will help the user when they use the system, as well as making it easy to operate at the same time. Most of the data validation will take place in the forms. For example, fields where text has to be entered will be validated to prevent any numbers being entered.

We can write a custom essay on

Choice Of Software Essay Sample ...
According to Your Specific Requirements.

Order an essay

You May Also Find These Documents Helpful

A various lifecycle models

1.1 SDLC diagram SDLC, Software Development Life Cycle is a methodology utilized by programming industry to setup, make and test high bore software's. The SDLC intends to make an awesome programming that meets or outperforms customer wants, accomplishes satisfaction inside conditions and cost checks. • ISO/IEC 12207 is a global standard for programming life-cycle forms. It expects to be the standard that characterizes every one of the assignments required for creating and looking after programming. • The programming advancement life cycle (SDLC) is a structure characterizing assignments performed at each progression in the product improvement process. • It is additionally called as Software improvement process. • SDLC is the acronym of Software Development Life Cycle. The frameworks advancement life cycle (SDLC), moreover insinuated as the application improvement life-cycle, is a term utilized as a part of frameworks building, data frameworks and programming designing to depict a procedure for arranging, making,...

Computer Software and information System

To know about the connection of these topics it is must to know about the link between these phrases as well as the basic concept of these two. Firstly, to know what is computer software and wireless Information systems and then secondly to discuss about their affects upon each other. Computer software is basically some programs or events that are written just to achieve certain functions by the software engineers. Events are the set of steps that is written and combined to make a program. Now there arises a question that what is a program then the answer of this question is that: Programs are basically a set of rules and instructions on the basis of which a computer act to achieve certain functions. To perform specific set of actions on computers intelligently or normally is the basic need to write a program. Wireless Information systems are basically the systems...

Computer Software and information System

Computer software is no longer a major barrier to wide use of wireless information systems Introduction To know about the connection of these topics it is must to know about the link between these phrases as well as the basic concept of these two. Firstly, to know what is computer software and wireless Information systems and then secondly to discuss about their affects upon each other. Computer software is basically some programs or events that are written just to achieve certain functions by the software engineers. Events are the set of steps that is written and combined to make a program. Now there arises a question that what is a program then the answer of this question is that: Programs are basically a set of rules and instructions on the basis of which a computer act to achieve certain functions. To perform specific set of actions on computers intelligently or...

Popular Essays

logo

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?