sql Flashcards
1
Q
what is a relational database
A
a database that organizes information into one or more tables
2
Q
what is a table
A
a collection of data organized into rows and columns. Tables are sometimes referred to as relations.
3
Q
what is a column
A
a set of data values of a particular type.
4
Q
data types
A
INTEGER, a positive or negative whole number
TEXT, a text string
DATE, the date formatted as YYYY-MM-DD
REAL, a decimal value
