Digital Signatures

March 26, 2019 antony 0

Digital signatures are very much like handwritten signatures, they are proof of authenticity. Digital signatures are one of the three data protection methods of authentication. […]

Centralised vs Distributed Databases

March 22, 2019 antony 0

Relational Database Management Systems (RDBMS) support centralised and distributed databases. A centralised database system is in one location (head office, data centre) and accessed from […]

More SQL

March 29, 2018 antony 0

Calculated field Calculated fields are attributes which have some calculation performed on them.  At the simplest it could be SELECT productPrice * 0.2 It should […]

Data warehouse

March 28, 2018 antony 0

Data warehouse A large store of data gathered from a wide range of sources, both old and new, within a company (and sometimes externally) and […]

Data validation

June 11, 2017 antony 0

Data validation is important in various areas of computer science – database data entry, data warehousing, program input, networking.  Any time data is communicated it […]

Encryption

March 27, 2017 antony 0

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 […]

Database visual interface

March 23, 2017 antony 0

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 […]

Data Integrity (database)

March 27, 2016 antony 0

Data integrity is about ensuring all data is consistent and accurate throughout a database. Referential integrity ensures all foreign keys have a primary key in another […]