Creating Tables
Learn about data types, primary key, and table creation in relational database.
Relational database
When a table is organized in a manner where each row can be distinctly identified, and every cell in the table contains a single, indivisible value, the table is termed a relation. A collection of such tables forms a relational database.
Data types
Each column in a table is associated with a specific data type, which defines the kind of data that can be stored in that column. It helps the database system understand how to store, retrieve, and manipulate the data. Here’s a brief overview of some common data types:
INTEGER
orINT
: TheINT
data type is employed to represent whole numbers without decimal points. For example, ...
Create a free account to access the full course.
By signing up, you agree to Educative's Terms of Service and Privacy Policy