Making information useful
If the details of the album are divided up into categories, the records in the database can be sort and re-organised according to the category (also called a field). An example of a category is genre. If the records can be organised by genre. This might be useful if someone want to see the blues music in the database.
Airtable database application
Go to this link https://en.wikipedia.org/wiki/Airtable and find out about the Airtable database. In Airtable a ‘base’ means database, Airtable is an online database and its basic features can be used for free.
Go to https://airtable.com/
Use your AC Google login to join Airtable for free.
These categories can be different types of information such as text, attachment, checkbox, select, date and time, phone number, email, URL, number, currency, percent, autonumber or formulas.
Let’s say I had this data to put into a database:
Record Number: 1
Album name: Masterpieces
Musician: Bob Dylan
Special info: 3 CD set of greatest hits
Release date: March 12, 1978
(This would be one record of a database)
Go to https://guide.airtable.com/columns-and-fields/ . Read about the field types.
What field types would each of the fields most likely to have?
What is the Record Number field for?