Beginner
60 mins
Teacher/Student led
+125 XP
What you need:
Chromebook/Laptop/PC

Designing a Database

In this lesson, we will learn how to design a simple database by creating a table to store information about our favorite books!

Teacher Class Feed

Load previous activity

    1 - Plan the Database

    Before we start designing our database, let's think about what information we want to store about our favorite books. Write down at least 5 pieces of information you think are important to store about each book.

    2 - Create Columns

    Now that we have a list of information we want to store, let's create columns for each piece of information. For example, if we want to store the book's title, author, and publication date, we would create 3 columns: 'Title', 'Author', and 'Publication Date'.

    Write down the names of the columns you want to create for your database table.

    3 - Choose Data Types

    For each column, we need to choose a data type that best represents the information we want to store. Some common data types are: 'Text', 'Number', 'Date', and 'Boolean'.

    Write down the data type for each column you created in the previous step.

    4 - Create the Table

    Now that we have our columns and data types, let's create the table for our database. We will use a simple spreadsheet program (like Google Sheets or Microsoft Excel) to create our table.

    Open your preferred spreadsheet program and create a new file. Name the file 'Favorite Books Database'.

    123learn · Online learning platform

    Unlock the full learning experience

    You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.

    Hundreds of curriculum-aligned lessons
    Interactive activities in every lesson
    Printable resources & progress tracking
    Copyright Notice
    This lesson is copyright of Coding Ireland 2017 - 2026. Unauthorised use, copying or distribution is not allowed.
    🍪 Our website uses cookies to make your browsing experience better. By using our website you agree to our use of cookies. Learn more