Notebook Task 1
Topic : Databases
Your school library is going digital! The librarian wants to organize all the
information about the books, students, and borrow records using a database.
She has created the following tables. Copy these two tables into your notebook.
2
Write the answers to the following questions in your computing
notebook.
1. What is a database, and how is it useful for organizing information in
the school library?
2. In the Books table, identify:
a. Any two field names.
b. Any one record.
c. The primary key.
3. The librarian notices that some cells in the table are empty. In a
database, these empty cells are referred to as _____________________.
[Primary Key, Data Type,Null Value]
4. Which data type would be most appropriate for the following fields:
a. YearPublished: ____________
b. Email: ____________
c. BookID: ____________
d. Grade: ____________
5. Why do you think the BookID and StudentID fields were chosen as
primary keys?
6. If you were asked to design a Borrowing table to track which student
borrowed which book and when.
a. What fields would you include?
b. List at least 4 fields and mention what their data types would
be.
c. From the fields you have selected, suggest one that can be
used as a primary key.
7. What problems might occur in the library database if we do not use
primary keys in any table?
3
Notebook Task 2
Refer to the given data types.
You have been hired by a travel agency to help them organize information
about various holiday destinations for their website. Your task is to design
a table named HolidayDestinations with appropriate fields and data types.
Make sure your table:
a. Contains at least one field for each of the data types
mentioned above.
b. Has a primary key to uniquely identify each destination.
Draw the table shown below in your notebook and complete your task.
Field Name Data Type Is Primary key? (Y/N)
In your notebook, draw a table named HolidayDestination that includes all the
fields you have selected, along with 3 to 5 relevant data entries.
