Introduction

Definition: A database is a collection of related data stored in separate data structures, usually table structures. Data stored in databases contain a minimal amount of duplication.

Alternative Definition: A database is as store of data organized into related tables.

A database purpose is to store and manage information; and to be easily searchable to produce filtered information on the data by querying the database.

Facilities querying the database are provided by the Database Management System (DBMS).

For example, a school’s database can store all information about the school in different tables – Teacher information in a teacher table , Student information in a student table, subject information in a subject table.

Because the tables are related to each other , we can perform queries on the database to find:

The list of subjects for a particular student,

The number of students assigned to a subject,

The list of student assigned to a teacher,

…..etc.

Required reading

Information technology for CSEC , 3rd Edition, Howard Campbell , pages 222 to 225

Database Introduction Tutorial Video from earlier class (Thurs 7th Jan 2021)

The following content and skills were demonstrated in the class:

Skill/Content	Timestamp	Link
Database Definition	00:30	https://youtu.be/sxzuxKSK_I8?t=49
Purpose Of Databases	02:17	https://youtu.be/sxzuxKSK_I8?t=137
Creating a Database in Access	03:39	https://youtu.be/sxzuxKSK_I8?t=219
Creating and Saving tables	05:25	https://youtu.be/sxzuxKSK_I8?t=325
Table Structure in Design View	07:34	https://youtu.be/sxzuxKSK_I8?t=454
Toggling Design View	08:01	https://youtu.be/sxzuxKSK_I8?t=481
Primary Keys	08:23	https://youtu.be/sxzuxKSK_I8?t=505
Adding Table Fields (Columns)	08:57	https://youtu.be/sxzuxKSK_I8?t=537
Data Types: Date/Time	10:28	https://youtu.be/sxzuxKSK_I8?t=631
Adding and editing Data	11:13	https://youtu.be/sxzuxKSK_I8?t=674
Auto Number Primary Key	14:29	https://youtu.be/sxzuxKSK_I8?t=869
Uniqueness Of Primary Keys	15:15	https://youtu.be/sxzuxKSK_I8?t=915
Creating Subject table	16:14	https://youtu.be/sxzuxKSK_I8?t=974
Manual Primary Key	17:57	https://youtu.be/sxzuxKSK_I8?t=1078
Presence Check of PK	19:27	https://youtu.be/sxzuxKSK_I8?t=1167
PKs cannot be Duplicated	20:30	https://youtu.be/sxzuxKSK_I8?t=1230
Bridge Entities for Relationships and Joins	22:09	https://youtu.be/sxzuxKSK_I8?t=1329
Composite Primary Key	23:07	https://youtu.be/sxzuxKSK_I8?t=1387
Yes/No Boolean datatype	25:41	https://youtu.be/sxzuxKSK_I8?t=1541
Relationship Creation with Lookup Wizard	27:11	https://youtu.be/sxzuxKSK_I8?t=1631
Examining the lookup	33:26	https://youtu.be/sxzuxKSK_I8?t=2006
Creating 2nd Lookup and Relationship	33:41	https://youtu.be/sxzuxKSK_I8?t=2081
Linking Data to create New Information about entities	39:58	https://youtu.be/sxzuxKSK_I8?t=2398
Creating forms automatically from built relationships	42:17	https://youtu.be/sxzuxKSK_I8?t=2537
Conclusion	44:02	https://youtu.be/sxzuxKSK_I8?t=2642

Video

The file produced from the video above and an accompanying tutorial hando and can be found here:

https://drive.google.com/drive/folders/1RYNjWTlLJqayxCZPllZSYhmo1PoXjWrv?usp=drive_link

Updates to this post

Unknown Date: Added Class Video and link to database file

2026-05-10:

• Added Chapters containing Skills in Video and Inserted Table.
• Added section “Updates to this Post”
• Removed Download Button

© 2021  Vedesh Kungebeharry. All rights reserved.