• 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
  19. 19

Database Analysis & Design

Extracts from this document...


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.


* 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.


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)

    30th September Analyse Current User Activities/Data 2nd September Analyse Problems with Current System 6th September Identify End-User Requirements 8th September Identify System Requirements 12th October Cerate Performance Criteria 17th October Consult with User 18th October Investigation Techniques In order to gain a clear and comprehensive understanding of the way in

  2. Marked by a teacher

    Assignment A: Analysis of Transactional Website

    3 star(s)

    The offers also entice customers because they want to come back to the website to see more good offers or bargains. * The navigation of the overall website is a good its is clear and easy see sales that stand out, the use of a larger font makes parts of the webpage stand out and grab the users attention.

  1. Threats to Data

    It filters out any traffic which it doesn't like. Generally it will allow access from sources it knows but if it doesn't recognise a source, like a hacker, it will ask whether to want to block it or not. This will apply to traffic going out of your system as well so it provides some protection against spy ware.

  2. ict as level coursework

    C2 is where that information will go on the spreadsheet in this case it is where red ring is on the spreadsheet. This user form is extremely important as customer details will be entered on it. This is a better method than the paper based system as there is much

  1. Free essay

    The following report will outline how a business communicates effectively and efficiently within their ...

    communication that aids the memory by recording events or observations on a topic, such as may be used in a business office. Memos are used in a wide range of businesses such as Tesco and Argos.A day order is any order that is not a good till cancelled order.

  2. Free essay

    ICT organisation project

    Statistics are included about the teenage pregnancy rates in the Borough along with campaign information to reduce these rates. A bulleted list of local initiatives to help young people is used. A separate text box to the main body of text titled "Advice is available" describes the Wigan Teenage Pregnancy Partnership, which contains website addresses regarding sexual health.

  1. Organisational Structure

    A flat structure could be a sole trader but also an independent operating area. E.g. A classroom. Strengths of a Flat structure The person at the top of the structure is in total control. That person will know about things happening in the business right away.

  2. System Analysis and Design Assignment

    Do the staff have the skills to do it? Do we have the right hardware? Economially Feasible: Can it be afforded? Legally Feasible: - What laws apply to what we want to do? Operationally Feasible: Will it be compatible with our other systems?

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