Encryption
Transferring data over networks is inherently insecure. The traffic passes through multiple routers and if any of those routers are compromised by a hacker or […]
Month: March 2017
Data Dictionary
A data dictionary is a CASE tool, along with an ERD, used to help plan a database. It is also part of the system documentation […]
Database visual interface
Relational databases can look very confusing with the many tables, records, and fields. Databases are used to hold large amounts of data. This means navigating […]
Privacy (Australian Privacy Act 1988)
There are legal requirements for large companies and companies who hold sensitive information (medical businesses, gyms, market research, schools, etc) about the public to protect that […]
Normalisation (Database)
Data normalisation organises data in a database (across multiple tables/entities/relations) to ensure there is no data redundancy and to avoid anomalies (insert, deletion, update). There […]