Define the term database
Describe a database using the terms File, Record and Field
Discuss the advantages of electronic databases over manual systems
Information systems (IS) are formal, sociotechnical, organisational systems designed to collect, process, store, and distribute information.
Data are individual units of information.
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.
Databases are everywhere, but some big examples include:
There are many different areas of database engineering that offer many jobs.
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)
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.
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:
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
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.
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:
Before you can save a table it must first contain at least one field.
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.
Create New Database called My classmates
Create a new table in Datasheet View called Classmates
Insert the following fields into the table
Add a field or two of your choice.
Enter the data and save your database.
You've created a database that contains the names of several pupils in the class and you've added at least 3 fields.
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
One single record
Play a game of Top Trumps with the people next to you.
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.
The following are key shortcuts for using BalfSlideView and reveal.js.
|→, PAGE DOWN, SPACE
|←, PAGE UP
|SHIFT + →
|SHIFT + ←
|Widget Board/White Screen
|Toggle Notes Canvas
|Clears Whiteboard/Notes Canvas
|Show Presenter Mode
|SHIFT + D
|Toggle Dark Mode
|Goes to the Home Slide
|META + P
|Show Print options window
In order to use the 'Start Remote' feature, you'll need to download JB Slide Controls from the Apple App Store. Once you have this you'll be able to control the slides using the app from you Apple Watch.
BalfSlideView and jamiebalfour.scot are copyright © Jamie B Balfour 2017 - 2023, 2010 - 2023. Content is copyright © Jamie B Balfour