Create a story with the following vocal words
Around 200 words will be good enough, the vocabs do not have to be in order
- A database is a piece of software that organizes, stores and retrieves information.
- A relational database is a particular variety of database that works by connecting tables to each other. It is the most popular form of database and the type we will discuss most in this class.
- Databases model your information by implementing the idea of types, attributes, and value patterns.
- Databases store information in a highly organized way, sort of like a file cabinet.
- Databases allow you to query information by asking questions about what information you have.
- Databases let you retrieve information so that your results can be displayed and worked with.
- A table in database terminology basically corresponds to a type.
- A column in database terminology basically corresponds to an attribute.
- A data type in database terminology basically corresponds to a value pattern.
- A database schema shows all the tables, columns and relationships in a database.
- Databases add values to a column or rows to a table to store information.
- Databases delete values from a column or rows from a table to remove information previously stored.
- Another term for a database row is a “record.”
- We already talked about querying and retrieving information, but how do those processes actually happen? To understand database querying, it’s helpful to know the basics of structured querying language, or SQL.
- The SQL word SELECT lets you state which columns you want to retrieve.
- The SQL word FROM lets you state which tables you want to retrieve columns from.
- The SQL word WHERE lets you state which rows you want to retrieve.
- A template is a “blank” page into which values from a database (or other source of info) are “pasted” in.