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.
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.
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.
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'.
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.