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

System Specification Essay Sample

essay
  • Pages: 6
  • Word count: 1,496
  • Rewriting Possibility: 99% (excellent)
  • Category: system

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

This shows my final system and what I would like it to be able to do.

The system will be successful if –

– The interviews and research took place and were successful enough to uncover all the problems about the current system

– The data collected can be analysed in detail so the current system can be completely studied

– The system has some validation as the data is entered to help the new user understand it, and where they might have gone wrong – this limits the number of mistakes that can be made e.g. a multiple membership number would not be allowed by the system

– The data structure has been carefully designed to accommodate all the data needed in the database e.g. if a field needed to be a ‘text’ field, with words no longer than ’10’ letters long, the system will only allow text up to 10letters long – this will limit the amount of space the data can take up

– The system can sort and search data easily so a particular customer or cd can be found quickly and easily – the staff can find a customer in the database if they have forgotten their membership number

– The system can ‘link’ the data so that the staff can find out easily what customers have bought what cds

– The system has a mail merge feature so that letters can be written containing data selected from the system e.g. the staff can write a letter about a particular type of music, the staff can find in the database the customers that are interested in that type of music and then they can mail merge the data about them into the letter i.e. name and address, so that the letter can be sent to them

– All tables have key fields so that each record is unique and therefore easy to find, and cannot be duplicated

– The databases have been created to store the information about customers, cds and orders efficiently

– The way the data is entered should be consistent across all the tables i.e. the same font, colour etc.

– Queries can be made to find the data that is needed for the mail merge, e.g. the queries are used to find out what members are interested in punk music and ska-punk music and their names, addresses, titles etc. and the letter can be sent to them telling them about the latest cds on offer for that type of music.

I would like my system to be able to have information on how to use it that is understandable and easy to access – this is so people who have never used the system before know how to use it by reading the informat

ion, or by using the system itself. I would like my system to be

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

Choose a Membership Plan

– User friendly

– Easy to use

– Presented effectively – a good understandable layout

– Easy to understand – instructions that can be understood by first-time users

Member’s Table

For the membership table I want –

– To create a table in a database to store all the member’s information. It needs to contain these fields – Title Email Address

Name Cardholder Initials

Surname Card Number

Address Card Type

City Expiry Date

County Music Preference One

Post Code Music Preference Two

Telephone Number

All these fields essential because the information is needed to tell the company about the individual customer e.g. name, address etc. It will also be able to let the customer buy cds from the company, and it will also tell the company what types of music the customer is interested in.

– To have all the number fields i.e. post code, telephone number, credit card number, credit card expiry date; to be entered using an input mask.

– To have the fields title, credit card type, music preference one and two; to have a look-up wizard – this will save time in typing and there will be no mistakes in spelling.

– All other fields will be text fields with different field lengths (field lengths are in place in order to save space and so that a name, or address can be no longer that the set number) –

o Name – 20

o Surname – 20

o Address – 40

o City – 20

o County – 20

o Email Address – 30

o Card Holder Initials – 5

– To be able to query the data so that the company can find a particular customer, and to speed up the process of ordering.

– To have the membership number as a primary key, therefore this field will have no duplicate and will be unique. This will be the first field on the table and it will be sorted by membership number. I am going to use an auto number feature in this field so there is a logical order to the records as they are entered.

Cds Table

For the cd table I want –

– To create a table in a database to store all the information about the cds. It needs to contain these fields – Product ID

Category

Cd Title

CD Band Name

No in Stock

Price for CD

All these fields essential because the information is needed to tell the company about the individual cd e.g. band name, title etc.

– I am going to have all the number fields i.e. no in stock, product ID and price for cd, on an input mask. The product ID field will be on auto number so that no mistakes are made when entering a new cd and to make sure that there are no duplicates of product ID.

– To have the field category have a look-up wizard – this will save time in typing and there will be no mistakes in spelling.

– All other fields will be text fields with different field lengths (field lengths are in place in order to save space and so that a title, or name can be no longer that the set number) –

o Cd Title – 25

o Cd Band Name – 30

– To be able to query the data so that the company can find a particular cd, and to speed up the process of ordering.

Orders Table

For the orders table I want –

– To create a table in a database to store all the information about what customer has orders what cds. It needs to contain these fields – Product ID

Membership Number

Quantity

Order Date

– All these fields essential because the information is needed to tell the company about what cds a particular has ordered.

– To have all the fields i.e. product ID, membership number, quantity and order date; to be entered using an input mask.

– To be able to query the data so that the company can find a particular cd, and to speed up the process of ordering.

We can write a custom essay on

System Specification Essay Sample ...
According to Your Specific Requirements.

Order an essay

You May Also Find These Documents Helpful

Totalitarianismand political regime

Is it rational to use totalitarianism as a political regime of the state? This essay is devoted to the essence of totalitarian regime. I will try to find main features, which are necessary to build this system in the state. Moreover, I will try to find out whether the countries, where totalitarian regime has ever existed, are viable. First of all, it is important to give a definition to the term «political regime». Many scholars, for example, P. Schmitter and G. O’Donnell, H. Laswell and G. Golosov, dedicated their works to this issue. But I consider that the definition of Jean-Louis Quermonne, French political scientist, is the most precise of all. In his opinion, political regime is «all the ideological, institutional and sociological elements that contribute to shaping the government of a given country for a specific period». I chose it, because his definition is the most common in European political science....

McDonald's business operation system

In this essay, I will be discussing the importance of Data, information, and Knowledge within an organization and I will also define each one of the components thoroughly. Data, Information, and Knowledge. To begin with, there are many authors with different definitions of data, information, and knowledge. Ralph M. Stair and George W. Reynolds (2012, p.5-6.) Defines data as facts and figures that have not been modified and processed by an organization, an example of data in a business industry would be employee's personal details such as phone numbers, date of birth, name, and address. Further, data needs to be relevant, accurate and useful to an organization because not all data is reliable and useful. Therefore, it must be processed and put into more convenient form for the users. This is known as the transformation of data into information. Ralph M. Stair and George W. Reynolds (2012) illustrates that information is data...

Functionalism working system

As Britain industrialised from the late 1800s forward the prototype of family changed. In pre-industrial times they were called extended families, normally being three generations living under the same roof, they needed to have large families to be able to work large amounts of land. Therefore, when industrialisation began, and everybody needed to move to the cities, extended families were no longer needed, but mobile families instead, one´s that could follow work opportunities wherever presented. The mechanical solidarity within the extended family social structure transformed into an organic organism. The reduction of members to a father, mother, and children fitted society’s needs and was the origin of the nuclear family in a capitalist society. In 1949 George Murdock, an American anthropologist and sociologist, defined four functions a nuclear family performs, stable satisfaction of sex drive, meaning parents would have a monogamous relationship which prevented conflicts in society. Reproduction of the...

Popular Essays

logo

Emma Taylor

online

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