An Example of a Database
In this lesson we will take a look at a simple university database.
We'll cover the following...
Before we move onto the example, we must identify the need to store data in tabular form.
One of the main reasons to store data regarding a specific object in a table is ease of understanding. So, instead of keeping relevant information regarding an object (like a student) in separate files, tables allow us to keep the important data regarding that object (like student ID, name, address, age, etc.) in one place.
A table is a collection of related data held in a table format within a database. It consists of columns and rows.
| Column_1 | Column_2 | Column_3 |
|---|---|---|
| Data_Item1 | Data_Item2 | Data_Item3 |
| Data_Item4 | Data_Item5 | Data_Item6 |
| … | … | … |
Each row in a relational database ...