Database design Prep

Srihari Kalwala English 2 pages

Content of the notes (2)

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

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,

Description: Note on Database design Prep, created by Srihari Kalwala on 24/06/2019.
Created by: Srihari Kalwala
Views: 25
Tags: db database design
Rating