A Short Introduction to Databases
By Viji Kumar
()
About this ebook
Related to A Short Introduction to Databases
Related ebooks
Introduction to Algorithms & Data Structures 2: A solid foundation for the real world of machine learning and data analytics Rating: 0 out of 5 stars0 ratingsLinux - a Secure Personal Computer for Beginners Rating: 0 out of 5 stars0 ratingsSql : The Ultimate Beginner to Advanced Guide To Master SQL Quickly with Step-by-Step Practical Examples Rating: 0 out of 5 stars0 ratingsBeginning Software Engineering Rating: 5 out of 5 stars5/5Excel 2016 All-in-One For Dummies Rating: 3 out of 5 stars3/5Introduction to Programming Languages Rating: 4 out of 5 stars4/5Excel Functions and Formula Combinations Rating: 0 out of 5 stars0 ratingsHTML, XHTML & CSS QuickSteps Rating: 0 out of 5 stars0 ratingsWeb Coding & Development All-in-One For Dummies Rating: 1 out of 5 stars1/5Getting Started with Bootstrap 3.2 Rating: 0 out of 5 stars0 ratingsComputer Programming JavaScript, Python, HTML, SQL, CSS Rating: 0 out of 5 stars0 ratingsFundamentals of Programming: Using Python Rating: 5 out of 5 stars5/5JavaScript Programming: 3 In 1 Security Design, Expressions And Web Development Rating: 0 out of 5 stars0 ratingsDeveloping Software Installers Rating: 0 out of 5 stars0 ratingsPYTHON DATA ANALYTICS: Mastering Python for Effective Data Analysis and Visualization (2024 Beginner Guide) Rating: 0 out of 5 stars0 ratingsComputer Programming Languages for Beginners Rating: 0 out of 5 stars0 ratingsComputer Engineering A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratingsIntroduction to Computer Science Unlocking the World of Technology Rating: 0 out of 5 stars0 ratingsC++ Networking 101 Rating: 0 out of 5 stars0 ratingsClient Side Web Development For Beginners (HTML/CSS/JS) Rating: 4 out of 5 stars4/5Excel Data Filters Rating: 5 out of 5 stars5/5HTML For Novices By Novices Rating: 0 out of 5 stars0 ratingsTeach Yourself VISUALLY Web Design Rating: 4 out of 5 stars4/5Python For Beginners: The Comprehensive Guide To Learning, Understanding, And Mastering Python Programming Rating: 0 out of 5 stars0 ratingsIBM Lotus Notes 8.5 User Guide Rating: 0 out of 5 stars0 ratingsHow to Learn PHP, MySQL and Javascript Quickly!: For Dummies Rating: 5 out of 5 stars5/5Oracle : Data Manipulation, Knowledge Discovery & Reporting Using Ms Access Rating: 0 out of 5 stars0 ratingsASP.NET Application Development Fundamentals Rating: 0 out of 5 stars0 ratings
Computers For You
Everybody Lies: Big Data, New Data, and What the Internet Can Tell Us About Who We Really Are Rating: 4 out of 5 stars4/5The Innovators: How a Group of Hackers, Geniuses, and Geeks Created the Digital Revolution Rating: 4 out of 5 stars4/5The Invisible Rainbow: A History of Electricity and Life Rating: 5 out of 5 stars5/5101 Awesome Builds: Minecraft® Secrets from the World's Greatest Crafters Rating: 4 out of 5 stars4/5Deep Search: How to Explore the Internet More Effectively Rating: 5 out of 5 stars5/5Elon Musk Rating: 4 out of 5 stars4/5Slenderman: Online Obsession, Mental Illness, and the Violent Crime of Two Midwestern Girls Rating: 4 out of 5 stars4/5CompTIA IT Fundamentals (ITF+) Study Guide: Exam FC0-U61 Rating: 0 out of 5 stars0 ratingsStandard Deviations: Flawed Assumptions, Tortured Data, and Other Ways to Lie with Statistics Rating: 4 out of 5 stars4/5Alan Turing: The Enigma: The Book That Inspired the Film The Imitation Game - Updated Edition Rating: 4 out of 5 stars4/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Uncanny Valley: A Memoir Rating: 4 out of 5 stars4/5The Professional Voiceover Handbook: Voiceover training, #1 Rating: 5 out of 5 stars5/5The Hacker Crackdown: Law and Disorder on the Electronic Frontier Rating: 4 out of 5 stars4/5CompTIA Security+ Get Certified Get Ahead: SY0-701 Study Guide Rating: 5 out of 5 stars5/5The ChatGPT Millionaire Handbook: Make Money Online With the Power of AI Technology Rating: 4 out of 5 stars4/5Procreate for Beginners: Introduction to Procreate for Drawing and Illustrating on the iPad Rating: 0 out of 5 stars0 ratingsCreating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Mastering ChatGPT: 21 Prompts Templates for Effortless Writing Rating: 5 out of 5 stars5/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5Master Builder Roblox: The Essential Guide Rating: 4 out of 5 stars4/5Pro Tools All-in-One For Dummies Rating: 5 out of 5 stars5/5
Reviews for A Short Introduction to Databases
0 ratings0 reviews
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