A table is:
The name comes from the counting table (abacus) that was found in the medieval counting houses.
In the data model, tables may have different purpose such as:
You can list the tables of your database via the information schema.
Example with
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
SELECT name FROM sqlite_master WHERE type='table';
You can create tables via for database:
Example:
CREATE TABLE Employees (
EmployeeID INT,
FirstName VARCHAR(50),
LastName VARCHAR(50),
Department VARCHAR(50),
HireDate DATE
);
You insert data into database table:
The cardinality of a table is the size of a table, the name comes from the set theory.
Even if it's possible to get all data in one table that has the same grain (unique key), you may split the columns that are not functionally related into 2 different tables
Why?
Why not?
A table is a stream of: