Practical Database Management SS1 Digital Technologies Lesson Note

Subject: Digital Technologies 

Class: SS1

Starting Your First Database

Before you even touch the computer, you have to decide what your database is for. Let’s say we want to create a School Library Database.

Step 1: Creating the Table

The table is the foundation. When you open your DBMS (like Access), you start by defining your Fields (columns) and their Data Types.

What are Data Types? You have to tell the computer what kind of information will go into each box so it doesn’t get confused:

• Text: For names or titles.
• Number: For quantities or ages.
• Date/Time: For birth dates or book return dates.
• AutoNumber: This is great for a Primary Key (it gives every new person a number automatically: 1, 2, 3…).

Entering Data (Records)

Once your “skeleton” (the table structure) is ready, it’s time to add the “flesh” (the data).

Manual Entry vs. Forms

You can type directly into the table, but that’s a bit boring. Most professionals use a Form.

What is a Form? A Form is a window that shows one record at a time. It’s like a digital “Fill-in-the-Blanks” sheet.

• It is easier on the eyes.
• It helps prevent mistakes (like accidentally deleting someone else’s row).
• You can add “Buttons” to save or go to the next person.

Asking Questions (Queries)

Now for the magic part! Imagine you have 5,000 books in your library database. A teacher walks in and asks: “Which Science books are currently borrowed by SS1 students?”

You don’t look through every row. You run a Query.

Definition: A Query is a specific question you ask the database.

How to build a Query:

1. Select the Table: Tell the computer where to look.
2. Select the Fields: Choose what you want to see (e.g., Book Title and Student Name).
3. Set the Criteria: This is the “Filter.” You might type =”Science” in the Subject column.

The database will instantly hide everything else and only show you the Science books.

Generating Reports

A table or a query looks okay on a screen, but if you want to print it out for a meeting or give it to your Principal, it needs to look professional. This is where we use a Report.

Definition: A Report is the final, polished version of your data, formatted and ready for printing.

What makes a Report special?

• Headers and Footers: You can add the school logo and the date.
• Calculations: You can add a “Grand Total” at the bottom (e.g., “Total Books Borrowed this Week: 45”).
• Grouping: You can group students by their house (e.g., all “Red House” students listed together).

Putting it All Together (The Workflow)

To manage a database practically, you follow this simple 4-step circle:

1. Create: Set up your tables and fields.
2. Input: Use Forms to add your records.
3. Process: Use Queries to find specific information.
4. Output: Create a Report to show your results to others.

Practical Tips for the Lab:

• Save Often: Databases save data differently than Word docs, but it’s still good practice to click “Save” after designing a table.
• Check Your Spelling: If you search for “Biology” in a query but you spelled it “Bilogy” in the table, the query will find nothing!
• Keep it Simple: Don’t create 10 fields if you only need 5.

Class Practical Exercise

1. Open Access/LibreOffice Base: Create a table called “My_Friends.”
2. Define Fields: Add FriendID (AutoNumber), FirstName (Text), and PhoneNumber (Number).
3. Input: Use a Form to add 5 of your classmates.
4. Query: Create a query to find only friends whose names start with the letter “A”.
5. Report: Generate a simple report showing their names and numbers.