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

Database Analysis & Design

Extracts from this document...

Introduction

Assignment 1 Introduction Within this report I will explain the following areas in detail, * Explain the different types of databases - flat file, hierarchical and relational. Compare the advantages and disadvantages of each. * Describe two analysis methodologies and again compare the advantages and disadvantages. This time use examples to illustrate your key points. * Describe the concepts involved in Logical Data Modelling. * Identify and describe potential modelling constraints that could arise from a logical data model using examples. * Finally discuss the benefits of Logical Data Modelling. Databases There are many different types of databases available for use; the three most common ones are, * Flat file database * Relational database * Hierarchical database I will now explain each database listing the advantages and disadvantages of each. Flat File Databases This section will show a description about flat file databases and the advantages and disadvantages Description A Flat File Database is a text file commonly only containing a record for each line in the file. This sort of database would be used for a simple phonebook sort database, showing peoples names with there telephone numbers and possibly addresses. This could also be used to keep track of friends. An example of a flat file database is a personal phonebook storing names and telephone numbers Advantages The advantages of a flat file database are, * It is a very simple database which is easy to use and understand, very little training will be needed to create and use one of these. * Easy to understand. * These are cheap to both create and to run as they are usually just simple text files. * Uses a small number of resources Disadvantages The disadvantages of a flat file database are, * Information is entered manually which may cause more errors in spelling and the way data is entered. * Data duplication, data can be entered more than once and there is no way of checking if the data has been used before ...read more.

Middle

* Review Design Prototype Check the correctness of the designed system. Again testing and reviewing are the main techniques used, since the test records and user's feedbacks are important to generate the user documentation. Within this stage deliverables are given towards the end, these are, a Design Prototype during the phase that end users get to test. At the end of the Design is stage the Tested System is handed over to the next phase. A user document is also a deliverable in this section. Disadvantages The disadvantages within this methodology are, * Difficult for employees to commit time to the process, this means the project may not be completed on schedule. * Consistency problems, this means the system will be unprofessional and not how the user wants it * Sometimes project cannot be split into sections, this means large tasks need to be completed, this is harder. * This methodology is not always reliant on good quality * Stages can often be rushed, this causes errors and poor quality products. SSADM Within this section I will describe what the SSADM methodology is and how it works, state the advantages and disadvantages and then give examples to support my key points. Description Structured Systems Analysis and Design Method (SSADM) is an approach to analysis and design of systems. This uses a Waterfall life cycle, within these information systems designs can be arrived at. 1. Analysis 2. Design 3. Implementation 4. Testing 5. Maintenance http://www.math.bas.bg/~nkirov/2006/NETB151/slides/ch13/images/waterfall.png The diagram above shows the stages involved in the waterfall life cycle. Feasibility A feasibility study is the work and research which is completed at the start of the project, this helps determine and document what will happen within the project and how it will work. Within this section the planning, organising and the management of resources will be analysed to help allow the project goals to be completed effectively and efficiently. ...read more.

Conclusion

Takes longer to plan The logical data model takes longer time to plan than just creating the system with simple planning. The whole model has to be taken in to consideration and each step must be carried out before moving on to the system. Hardware/Software The correct software is needed to create logical data models efficiently, is poor software is used then the end product will not be as good as it should. The final system must be taken into consideration, things such as, is it being created for one computer or a network of computers? The system would have to be more advanced and made available to different software and hardware to cover these different aspects, this then means spending more money and more time. Security The logical data model has different security issues, if someone gathers the details of the system then peoples details can be at risk and this is breaking the data protection act, this can result in the system being shut down. Other details about companies and about how things are created can be found and this will affect the system. Having user names and passwords on all the different files and on different levels, this will reduce the amount of security issues. This means only certain people can access certain information Budget The company must have sufficient budget to have the system created, this can be a time consuming and expensive process, the company must be able to encounter any problems and have spare money to overcome these. Final system If the final system is just completely relied on by the logical data model then the system may not be what is required and what the client wants, other planning needs to take place. ?? ?? ?? ?? National Diploma For IT Practitioners Unit: 11 - Data Analysis and Design Assignment: 1 Candidate Number: Centre Number: 47303 Name: Neil Gibson Page: 1 ...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 Information Systems and Communication 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 Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    At the end of two weeks of work, we had to present the fruits of our labour to an audience including NASA officials and university professors. Part of this presentation involved presenting a slideshow containing information pertaining to our ideas to accompany our speeches.

  2. Marked by a teacher

    Assignment A: Analysis of Transactional Website

    3 star(s)

    also that once you have bought one product the next time you wish to buy something you just enter your password and email address and you're away. Methods used to engage, retain or entice the customer Engaging, retaining and enticing the customer is one of the most important things that

  1. Marked by a teacher

    Ecommerce Case Study

    In order to ship internationally Cuckoo will need to not only wrap their products in suitable packaging in order to preserve the game they may have to be bubble wrapped and in sealed brown paper envelopes in order to keep the contents sealed.

  2. communication and values

    The group interaction: The interaction went well and I was much more comfortable to do group interaction rather than one to one interaction. It was much easier for me and also for my clients to work as a group. The interaction that I carried out was more intellectual but we

  1. IT Systems Analysis and Design: Task 2 - Planning, investigating and interviewing

    Secondly I would hand out Questionnaires to the company staff to see what they would like to see in the new system. Finally I would then carry out an interview with the manager of the library to see what he wants changed in the new system.

  2. Data Processing Task. Mr Peters, the man who runs this particular Samsung store ...

    An advantage of this system is that it requires minimal staff training and it is written to improve the businesses process. However, a major disadvantage on the other hand is that it is extremely costly and time consuming. Database System (Microsoft Access)

  1. ICT revision notes - IT project management

    âHow often are they used? âHow the is the data collected? âWho are the documents sent to? âWhat do they do with them? âSystems analysts' then use formal graphic and tabular methods such as DFDs to represent the current system.

  2. Features of database design

    The database is set in a way where data can be accessed or changed in different ways and not be duplicated. Relationships ? Relationships in a relational database are used to prevent data that is not needed and also prevents you from putting the same data in twice.

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