design finals 1 Keyterms Flashcards
(40 cards)
data representation
The way that binary codes are used to represent different types of data
Encryption
A way to convert normal text to a secret code
Descryption
The process of converting encrypted data back to plain text
Original text
A source code/plain text
Cypher text
A text or code that is convertrd to a secret language that is difficult to understand without a key
Substitution cypher
Replaces the original text with another alphabet/number and generates a cypher text
Transpose
when we mix up and change the letters of the original text to create a cypher text
Modulo 2
A 5 bit binary code
ASCII
American standard code for information interchange
EBCDIC
extended binary coded decimal interchange code. Extended ASCII
Unicode
Universal code, it is enough to translate the whole world
Pig pen
Encryption that is done using symbols
Database
An organised collection of data
Field
A single item of data
Record
A collection of related fields
Table
A set of data organised in rows and columns
Keyfield
Uniquely identifies each record in a database
Boolean expression
A logical expression that produces a true or false statement
Boolean operator
AND, OR, and NOT
Database query
a code sent to a database to get information from the database
Redundant data
Duplicated data occurs when information is stored more than once in a database, which leads to inconsistency
Verification
Checking that the data in a database matches the data like it was originally captured
validation
automatic checks done on database to ensure that the database’s information is sensible
Foreign key
a foreign key links tables in a relational database by connecting a field in one table to the primary key in another