Introduction to Databases - SS1 Digital Technologies

TOPIC: Database Management System (DBMS)

CLASS: SS 1

Introduction to Databases & DBMS

Data Architecture, Storage Hierarchies, Data Types, and MS Access Fundamentals

1. Fundamental Definitions

1. Database: A structured, highly organized depository of related data records stored electronically inside a computer framework. It allows users to quickly search, filter, and extract specific information blocks out of thousands of entries.

2. Database Management System (DBMS): A system software package that serves as the administrative interface between the physical database storage layers and the end-user. It provides formal tools to create, extract, modify, optimize, and lock data records securely.

Key Distinction for Exams: A Database is the passive storage container holding the files. The DBMS is the active software software application suite used to interact with, secure, and operate on those files.

2. Real-World Examples of DBMS Packages

• Microsoft Access: A desktop-centric relational system included in the MS Office suite. It provides a visual graphical interface, making it the ideal learning environment for school practicals.
• MySQL / PostgreSQL: Highly powerful, open-source server engines that run major database operations behind modern corporate websites.
• Oracle Database / MS SQL Server: High-tier, massive commercial database ecosystems engineered to handle millions of secure transactions for banks and airlines.

3. The Structural Data Hierarchy

To operate a database, students must understand how small digital elements build up systematically into a complex repository:

Hierarchy Unit	Structural Definition	Practical Analogy (School Context)
1. Character / Bit	The single smallest text string block or numerical value element.	The single alphabet letter "K" or numeric digit "4".
2. Field (Column)	A distinct attribute column inside a data grid framework. It stores one specific type of feature info.	Student_ID, Surname, Class_Section, or Term_Fees.
3. Record (Row)	A single horizontal row containing a combination of fields describing one complete entity.	A row matching one student completely: (SS1/021, Okafor, Chidi, SS1A, Paid).
4. Table (File)	The core block made up of systematically intersecting fields (columns) and records (rows).	The master data table layout sheet named SS1_Students_Master_Table.
5. Database	The overall master file containing all related data grids, index files, and management objects together.	The single file package named Federal_College_Enugu_2026_Database.accdb.

4. Understanding Field Data Types (MS Access Focus)

Unlike a standard word processing file where you can type anything anywhere, every column (field) in a database table must be assigned an explicit Data Type. This forces the system to reject invalid entries.

• Short Text: Stores text strings, names, and numbers that don't need math calculations (e.g., telephone strings or addresses). Holds up to 255 characters.
• Number: Specifically reserved for raw numeric numbers meant for calculation rules (e.g., Exam_Score, Age).
• Date/Time: Restricts entries to formal calendar configurations (e.g., Date_of_Birth, Admission_Date).
• Currency: Automatically appends monetary formatting symbols (e.g., Naira symbol ₦, Dollars $) and prevents fractional rounding mistakes.
• AutoNumber: A unique counter sequence handled completely by the software. It increases by 1 automatically for every new row added, ensuring no two records share an identical identifier.
• Yes/No: A binary logical selection column (Boolean value) representing strictly two states (e.g., Fees_Paid, Is_Present).

5. Key Systems: The Primary Key Rule

A Primary Key is a field chosen by the database creator to uniquely identify every individual record line saved inside a table grid.

The Two Fundamental Rules of Primary Keys:

1. It must contain totally unique values—no two records inside that table can ever match.
2. It can never be left empty or blank (Null value rule).

Examples: Bank Verification Numbers (BVN), National Identity Numbers (NIN), or School Admission Codes. Fields like First Name or Age cannot be primary keys because many people can share the same name or age.

6. Basic Operational Workflow: Creating a Table in MS Access

To build a physical table during practical tests, students must use the following standard workflow steps:

1. Launch Microsoft Access and select Blank Desktop Database. Name the database file and click Create.
2. Navigate to the top ribbon menu, click the View button dropdown, and switch from Datasheet View to Design View. Name your table.
3. In Design View, type your field identifiers under the Field Name column, and match them to their correct functional parameters under the Data Type column.
4. Right-click your unique field (like StudentID) and select Primary Key. A small key symbol will appear next to it.
5. Click the View button again to switch back to Datasheet View. Save changes, and begin entering your data rows cleanly into the open grid layout.

7. Systematic Advantages over Paper Filing Layouts

1. Instantaneous Search Speeds: Zero manual sorting through cabinets; information surfaces in seconds via targeted queries.
2. Physical Space Optimization: Massive storage systems fit inside a tiny solid-state drive instead of consuming space across administrative offices.
3. Data Integrity enforcement: The computer systematically blocks entry syntax errors before they contaminate records.
4. Centralized Security Control: User verification permissions block unverified teachers or students from modifying confidential school finance records.

6. Video Tutorial: Creating Your First Table in MS Access

Watch this step-by-step practical video to see exactly how to open Microsoft Access, switch to Design View, define your field data types, set the Primary Key, and enter records cleanly.

Comprehensive Practice Quiz

1. Which specific data type should be applied to a column tracking a student's "Date of Birth" to prevent users from accidentally typing plain text characters?

A) Short Text B) AutoNumber C) Date/Time

2. What field configuration change happens immediately when you toggle a field to act as a Primary Key in Microsoft Access?

A) It converts all letters inside the text string to uppercase variables. B) A small key icon appears beside the field, and the system blocks duplicate or empty inputs. C) The software shifts the entire column layout into an Excel spreadsheet format.

3. In the formal data storage architecture hierarchy, what element is created when you combine multiple related attributes (fields) together horizontally?

A) A Bit Character B) A Database Record (Row) C) An independent Database File