Slides badge

What are databases?

Learning Intentions

  • Define the term database

  • Describe a database using the terms File, Record and Field

  • Discuss the advantages of electronic databases over manual systems

Success Criteria

  • I can explain the term database
  • I can identify a file, record and/or field in a database
  • I can discuss the advantages of electronic databases

Information systems

  • Information systems (IS) are formal, sociotechnical, organisational systems designed to collect, process, store, and distribute information.

  • Data are individual units of information.

What is a database?

  • A structured collection of similar information which can be searched and sorted. A database is an organised collection of data, generally stored and accessed electronically from a computer system.

  • For example, an address book you may have is a type of database. It contains:
    1. Names
    2. Telephone numbers
    3. Addresses

Data storage. Computerised or Traditional Paper?

  • Computerised data has many benefits:
    1. Requires less storage space
    2. Easy to backup
    3. Easy to edit
    4. Can be searched very efficiently
    5. Can be sorted very efficiently
    6. Easy to perform calculations on it

Examples of databases

  • Databases are everywhere, but some big examples include:

Potential careers?

  • There are many different areas of database engineering that offer many jobs.

Discussion

  • How could databases be used in these places?
    1. Schools
    2. Banks
    3. Police Stations
    4. Shops

File, record and field

  • A file is a collection of structured data on a particular topic. A file is made up of 1 or more records.

  • A record is a collection of structured data on a particular person or object. A record is made up of 1 or more fields. A "record" is the technical name for a database table row and contains the actual data in a table. Each record in a table contains the same fields but (usually) has different data in those fields.

  • A field is an area of a record that contains an individual piece of data. A “field” is the technical name for a database table column and is used to denote a specific type of data. The “Sex” field (column) contains text data denoting customer gender: Each field on a table holds only one type of data (for example, text data describing gender)

File, record and field

  • A field is a single piece of information;

  • A record is one complete set of fields;

  • A file is a collection of records.

  • For example, a telephone book is basically the file. It contains a list of records, each of which consists of three fields: name, address, and telephone number.

Field data types

  • When you create a database, one of the first things you have to do is choose ‘types’ for the Fields.

  • There are several types to choose from:

    • Numeric

    • Text

    • Boolean

    • Date/Time

    • Currency

    • Calculated

    • Hyperlink

Organising Data

  • Your first step in organising data is to identify the individual fields

  • The specific value, or content, of a field, is called the field value

  • Next, you group related fields together into tables

Launching the Access App

  • Microsoft Access is typically launched by clicking the Microsoft Access item on the Windows Start menu, to open the “Start” screen.

  • Here you see a range of ready-made templates and a list of recently-opened Access files that you can click to reopen:

  • Click on the Blank database template icon to begin creating a brand-new Access database.

  • You can edit the dialog Box (Default name, Default location) to provide your preferred name and location on your computer.

Launching the Access App

  • Datasheet View is the default data entry view for Microsoft Access 2016. Using the Datasheet View to build and manage your tables couldn’t be simpler:

  1. Click the Create tab on the Ribbon
  2. Click the Table Icon located in the “Tables” group

Working in datasheet view

  1. Press the Save Icon on the Quick Access Toolbar.
  2. Enter the name of your new Table into the “Save As” dialog
  3. Click the OK button to create a Table

Before you can save a table it must first contain at least one field.

Working in datasheet view

  • Microsoft Access automatically creates a field called “ID”, which can be renamed or deleted to suit your requirements and provides a “Click to Add” heading that is prompting you to add fields.

Working in datasheet view

  • You can add fields in the table view:
    1. Click the Click to Add field heading
    2. Select a data type for that field from the drop-down list that appears. For example, choose the Number data type.
    3. Type a field heading title to replace the default heading

Working in datasheet view

Create New Database called My classmates

Create a new table in Datasheet View called Classmates

Insert the following fields into the table

  1. ID data type Number
  2. First Name data type Short Text
  3. Last Name data type Short Text
  4. Age data type Number
  5. Hobbies data type Short Text
  6. Favourite food data type Short Text

Add a field or two of your choice.

Enter the data and save your database.

Task

You've created a database that contains the names of several pupils in the class and you've added at least 3 fields.

rEVIEWING YOUR WORK

You've created a database that contains the names of several pupils in the class and have added all 6 listed fields

You've created a database that contains the names of several pupils in the class and have all 6 listed fields and several more fields you have added yourself

Top Trumps

  • Top Trumps can be seen to be similar to a database.
  • Each card is a record.

Top Trumps

  • Top Trumps can be seen to be similar to a database.
  • Each card is a record.

Fields

One single record

  • Looking at one card, you can see several fields on it.

How many fields are there?

Play a game of Top Trumps with the people next to you.

Task

Create your own 'Top Trumps' database. You may choose any topic to base this on, but you must have attributes. For example:

 

You could choose Marvel characters such as Otto Octavius and compare them on attributes like intelligence, their danger levels.

 

Each record must have at least 6 different fields. Be creative.

Task

Presentation Overview
Close
JB
What are databases?
© 2020 - 2024 J Balfour
13:56 | 24-02-2024
Join Live Session
Start Remote
Save Progress
Slideshow Outline
Presenter Mode
Widget Screen
Canvas Controls
Dark Mode
Bold Text
Random Selector
Timer
Volume Meter
Binary Converter
Python Editor
Show Knox 90
Provide Feedback
Help
!
Keywords
    Random selector
    Sections
      Binary conversion
      Denary to binary conversion
      Binary to denary conversion
      Feedback 👍
      Accessibility

      Apply a filter:

      ×
      All slideshow files