Please enable JavaScript.
Coggle requires JavaScript to display documents.
Databases - Coggle Diagram
Databases
SQL
-
-
-
Can create, read, update and delete records/tables from databases (CRUD)
-
Keys
-
Primary
Each record must have one field that is unique to uniquely identify it even if other records have all the same attributes
-
-
ACID
-
-
-
Durability
Changes must be preserved, even in the event of failure
-
-
Types of database
Flat file
-
Advantages
-
-
-
-
-
Everyday things like business contacts, customer lists and so on can be stored and used
Disadvantages
-
-
Inherently inefficient - each record has to have the same fields, whether they are used or not
Harder to change data format (e.g. adding a dash in the middle of telephone numbers across tens of thousands of records)
-
-
Relational
-
-
Advantages
-
-
-
-
-
Cater for future requirements - it is simple to add records that are not yet needed but may be needed in the future
-