• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18

Systems Analysis

Extracts from this document...


Systems Analysis Systems analysis can be defined as a disciplined process, which begins with the establishment of user requirements for a given application and concludes with the implementation of fully operational system The main stages of systems analysis are often referred to as the system life cycle. The following sections give a brief overview of their functions within the systems analysis process. Feasibility study The aim of this stage is to establish whether or not a proposal for the computerisation of a particular application is worthwhile or feasible. In simple terms, the feasibility study has to answer questions such as: > "Will computerisation achieve the users' objectives?"; > "What type of system will be most suitable?"; > "Will it be financially worthwhile?" System investigation and design Assuming that the feasibility study produces a recommendation to proceed with computerisation of an application, then before any system specification is produced, an analysis has to be made of the processes and procedures involved in the application under consideration. For example, an analysis of Sales Order Processing should identify how orders are received, the order forms used and the procedures necessary to fulfil orders. Analysis is not simply the recording of an application as it currently operates through a variety of information gathering methods such as interviewing and observation, the requirements of a new system should be identified. Although the needs of the organisation are of obvious importance, employees are more likely to be concerned with matters of job satisfaction and working conditions. Successful implementation of a computerised system requires a great deal of work, involvement and willingness to co-operate by everyone concerned. If staff feel that their views have been considered such co-operation is more likely. Although users' views are Important an outside observer can often identify problems with current practice which have never been questioned. A systems analyst from outside the firm needs therefore, to possess qualities of tact and diplomacy if his or her views are to be considered. ...read more.


successful, partly because users can provide valuable insights into the practical aspects of system operation and partly because they will feel less motivated if they have had little or no influence on the final design. A formal organisation chart can be used to gain an overall picture of staff relationships and responsibilities but it should be borne in mind that designated and actual job responsibilities can differ radically. For example, it may turn out that a junior sales clerk is carrying out the checking of orders, which should be the responsibility of the sales supervisor. Thus, it may be necessary for the analyst to draw an alternative informal organisation chart to show the actual working relationships of staff. An example is given Apart from identifying working relationships between staff, it is useful to draw up brief job descriptions so that consultation on individual system procedures can take place with the appropriate staff. For example, a job description for a sales clerk may include the following activities: completion of standard order forms; checking stock availability; notification of orders to accounts. Therefore, although the sales departmental manager may have knowledge of such procedures, the sales clerk will have practical experience of their operation and should be consulted. System inputs A number of details concerning the data inputs to a system need to be established: * source. It may, for example, originate from a customer, a supplier, or another department in the business; * form. The data may arrive, for example, by telephone, letter, or a standard form such as an order form or supplier's invoice; * volume and frequency. For example, the number of orders received daily or weekly; * contents. For example. the individual items of data which appear on a supplier's invoice. Such information will allow the analyst to make recommendations on the most appropriate methods of computer input. The design of appropriate input methods also has to take account of several tasks involved with the collection and entry of data to a system: * recording. ...read more.


( 2NF applies to entities with composite keys, that is a primary key composed of two or more attibutes. An entity which is already in 1NF, with a single attribute primary key is automatically in at least 2NF) The STUDENT entity has a single attribute primary key and is therefore already in 2NF. The LOAN_BOOK entity has a composite primary key so we need to examine all the non-key attributes to ensure they are fully functionally dependent on the whole of the primary key. Non-key attribute Dependent on:- Title Book# ISBN Book# ReturnDate Book#, Stud# Therefore Title and ISBN need to be removed to form a new entity BOOK. Book# is included to provide a link. The tables in 2NF are now:- STUDENT(Stud#, Name, Address, TG, Tutor,) LOAN_BOOK(Book#,Stud#, ReturnDate) BOOK(Book#, Title, ISBN) 4. Third Normal Form - 3NF Rule - To be in 3NF an entity must be in 2 NF (and therefore in 1NF) and contain no non-key dependencies. Fields which are not part of the primary key must always depend on the primary key and not on anything else, such as another non key field. Consider the entity STUDENT, Name & Address depend on the primary key but Tutor depends on the Tutor Group code TG and not on Stud#. They should therefore be removed to form a new entity, TUTOR. A copy of the code TG is left in the student table to form a link. STUDENT(Stud#, Name, Address, TG) TUTOR(TG, Tutor) Consider the entity LOAN_BOOK, return date is dependent on the primary key and therefore already in 3NF. Consider the entity BOOK, title is dependent on the ISBN and not on the Book#, this should be removed to create a new entity ISBN. A copy of ISBN is left in the BOOK entity to provide a link. BOOK(Book#, ISBN) ISBN(ISBN, Title) The final tables are:- STUDENT(Stud#, Name, Address, TG) TUTOR(TG, Tutor) LOAN_BOOK(Book#,Stud#, ReturnDate) BOOK(Book#, ISBN) ISBN(ISBN, Title) H. T. Harvey 6-Feb-03 1 of 18 Chapter 18 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Peer reviewed

    information systems assignment 2

    4 star(s)

    sure it is kept secure * do not show information to other people * do not allow access by others the information can be hacked online on the computers meaning other people will gain the customer information, this is not complying with the Data Protection Act meaning they are in

  2. Computer systems assignment 1

    Before taking the computer system apart I put on an anti-static wristband and put the whole computer on the anti-static mat which will prevent any flow of electricity that could damage the system and bring health issues. I make sure that the computer is not plugged in to the electricity.

  1. System Analysis The aim of the Jewellery store system is to make the work ...

    This phase also sets the project bounds, which define what part of the system can be changed by the project and what parts are to remain the same. The resources to be made available to the system are also specified in this phase.

  2. Control Unit, Memory Unit, and Arithmetic Logic Unit. The CPU or Central Processing ...

    i) Microphones. Used to input sound to a computer system. 4. Output Devices a) Visual Display Units. VDUs are categorised according to the obvious colour/monochrome, also according to the number of pixels that there are on the screen.

  1. The impact of the availability of electric information on individuals and society

    Also e-books because of its cheapness and convenience are becoming more and more popular. According to Telegraph this year Amazon even sold more e-books than paper books on Christmas Day. Therefore libraries and book stores are becoming redundant, which means that paper-based sources of information are no longer necessary and

  2. Computing Project

    Loans Overdue Form - I will test whether the button for retrieving the list of all the overdue loans works and whether this can be printed. Testing Form Description of test Test Data Used Expected outcome Actual Outcome Page of Report 1 Username and Password Form Setting up a username

  1. Primary or Secondary Storage.

    CYLINDERS A cylinder is a set of matched tracks. On a double-sided floppy, a track from the top surface and the same # track from the bottom surface of the disk make up a cylinder. The concept is not particularly useful for floppies.

  2. What is transaction processing?

    a specified time making us late for payment or even in some cases without money. Therefore these is a lot to weigh up in regards to the advantages and disadvantages of our lives moving more to automated transactional processes, the main disadvantage being security and the major advantage is convenience.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work