Please enable JavaScript.
Coggle requires JavaScript to display documents.
Revision (Databases (Data Types (when a database is created, each field is…
Revision
Databases
-
field= part of a record that stores a single data item, represented by a column
-
-
-
-
-
-
Relationships
-
-
defined as one to one, one to many, or many to many
Data Types
when a database is created, each field is allocated a data type. different types of data are used for different fields e.g text or numeric. the data type defines the type of data associated with each field
-
-
-
-
-
-
-
spreadsheets
-
-
-
Cells can store data such as text, number, date, formula.
They can be formatted as: general, number, currency, date, time, percentage, etc...
You can format a cell such as changing the shade, font, etc...
-
-
charts
-
-
-
presentation of charts can be enhanced by adding chart titles, legends and colour
-
-
-
v look ups
function that uses the value in a selected cell to 'lookup' a match in a column of a lookup table (vertical lookup) it then returns a value from a specific column from the same row
conditional formatting
allows a specific format like cell shading to be applied to a cell or a group of cells if a specific condition is met