Everand Logo

Welcome to Everand!

  • Discover millions of ebooks, audiobooks, and so much more with a free trial

    Only €10,99/month after trial. Cancel anytime.

    A Short Introduction to Databases
    A Short Introduction to Databases
    A Short Introduction to Databases
    Ebook80 pages25 minutes

    A Short Introduction to Databases

    By Viji Kumar

    ()

    Read preview

    About this ebook

    The aim of this book is to explain how discrete items of information (data) e.g. names of individuals or organisations can be linked to other items of information e.g. addresses, dates of birth or amounts invoiced. How that linked information can be used to drive other processes or produce reports is illustrated here by creating and populating a database reporting football (soccer) leagues, a world-wide phenomenon and I hope, explicable to most adults (young and old). Here the word database will refer to any collection of linked data in any structured format e.g. in rows and columns. The data required to populate a database, its form, will depend on its function e.g. the types of reports that the users of the database have specified. The purposes for which data are collected are myriad and it is prudent to bear in mind that there almost certainly will be data protection legislation to regulate the management and use of some types of data.
    LanguageEnglish
    PublisherLulu.com
    Release dateJul 27, 2019
    ISBN9780244505370
    A Short Introduction to Databases

    Related to A Short Introduction to Databases

    Related ebooks

    Computers For You

    View More
    View More

    Related podcast episodes

    Related categories

    Reviews for A Short Introduction to Databases

    0 ratings

    0 ratings0 reviews

    What did you think?

    Tap to rate

    Review must be at least 10 words

      Book preview

      A Short Introduction to Databases - Viji Kumar

      2020

      Book 1 – Modelling Data

      Chapter 1 – Explanatory Framework

      The aim of this book is to explain how discrete items of information (data) e.g. names of individuals or organisations can be linked to other items of information e.g. addresses, dates of birth, or amounts invoiced. How that linked information can be used to drive other processes or produce reports is illustrated here by creating and populating a database of football (soccer) league results, a world-wide phenomenon and I hope, explicable to most adults (young and old). Here the word database will refer to any collection of linked data in any structured format e.g. in rows and columns. The structure of a database, its form, will depend on its function e.g. the types of reports that the users of the database have specified. The purposes for which data are collected are myriad and it is prudent to bear in mind that there almost certainly will be data protection legislation to regulate the management and use of some types of data.

      To report on football games, you compare the number of goals scored by each team and deduce the result. In this model the two participating teams are labelled team one and team two. The starting point is the cataloguing of the different types of entities required to model the progress of a league season. This model only uses the following types of entities; competitions, league seasons, teams, venues, league games and league goals but it is an extensible model. It is also necessary to allow for the possibility that these teams may be relegated or promoted and that they may also play in other types of competitions e.g. knock-out tournaments. The entity types additionally required to extend the model would then include qualification criteria, group games, knock-out games, group goals and penalty shoot-out goals inter alia. These additional entity types indicate that there will need to be variants of some types of entities e.g. the different types of qualification paths, games, and goals. Carolus (Father of Taxonomy) Linnaeus’ words below are a useful exhortation in this context, if a trifle overwrought.

      The first step in wisdom is to know the things themselves; this notion consists in having a true idea of the objects; objects are distinguished and known by classifying them methodically and giving them appropriate names. Therefore, classification and name-giving will be the foundation of our science.

      Systema Naturae (1735), trans. M. S. J. Engel-Ledeboer and H. Engel (1964)

      The initial analysis should produce data models and/or schemas, also known in the demotic as the

      Enjoying the preview?
      Page 1 of 1