Database design Prep

Página 1

https://www.lucidchart.com/pages/database-diagram/database-design

CHAR - a specific length of text

VARCHAR - text of variable lengths

TEXT - large amounts of text

INT - positive or negative whole number

FLOAT, DOUBLE - can also store floating point numbers

BLOB - binary dat

Página 2

Database Normalisation

1NF

The first normal form (abbreviated as 1NF) specifies that each cell in the table can have only one value, never a list of values,