• 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)

    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)

    from your card issuer asking you for your personal SecureCode, just like the bank does at the ATM. This shows that they have tried to build a secure but easy to use, navigational website, that contains many levels of security.

  1. Marked by a teacher

    Ecommerce Case Study

    store in a number of ways such as the advertising and marketing. In order to advertise and market a store can cost thousands and for a small store such as cuckoo games this is completely unachievable, however advertising for ecommerce is relatively low cost and effective with the use of social media and search engine traffic.

  2. From the e-commerce strategy you gave me earlier I understand that by having a ...

    (EM2) Are there any advantages and/or drawbacks to the solutions you have offered? General Advantages/Drawbacks The drawbacks are you have to pay for Firewalls and anti-malware, pay for the training involved and courses, pay for someone to write up the Code of Conduct and employ a Data Controller or

  1. Health Book

    Solicitation of Personal Information Generally When personal information is solicited, the collector shall ensure that it is relevant to the purpose of collection, up to date and complete, and that the collection is not unduly intrusive 4.

  2. Free essay

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

    This gives the trader control over the price at which the trade is executed limit order is used when a company wants to control the price of their product for example online clothing companies used limited order to put a fixed price on their products.

  1. Feasibility Report

    This will give them a more efficient, effective way of placing their order. From the website they will allow be able read background information on the Perfect Pie Company, view menus with prices, location of the nearest Perfect Pie Branch and even careers within the Perfect Pie Company.

  2. Features of database design

    Relationships work by matching data in columns that normally have the same name in multiple tables. For example a database that is used to keep information about books, there may be a table called Titles that has the information about each book such as the title, publisher and when the

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