Please enable JavaScript.
Coggle requires JavaScript to display documents.
RDBMS, T-SQL
3 part language, DBS Types, DBS Admin, Normalisation -…
RDBMS
-
Schema Bucket
STRUCTURE: table, rows & columns
-
DEFINE data - type, size & property
-
-
-
-
-
DBS Types
RELATIONAL DB
-
-
:check:data integrity - constraints - keys, data types
-
-
-
-
-
-
DBS Admin
-
CRUD
(Create, Read, Update, Delete) Functions
management system, matrix/constraints (data integrity - locks)
-
stores, retrieve & process data - backup & recover
-
Normalisation
1NF. remove group repeats, no duplicate information
2NF. breakdown, logical grouping into themed, single topic tables, that are related.
3NF. eliminate non-key dependent data, create a junction or relation table
Clean dataset - remove all duplicates
Logical Grouping - organise data into relating tables.
Eliminate non-related data. Single topic tables.
Enforce standards - referential integrity of data.
Protect & Secure data. concurrent user access with permissions