chapter 1 & 3 key terms 🔌 Flashcards
data representation
the way that binary codes are used to represent different types of data
database
an organised collection of data
field
a single item of data
record
A collection of related fields
table
a table is a set of data organised in rows and columns, with a fixed number og columns and unlimited rows
keyfield
a key field uniquely identifirs each record in the datsbase. it is called a primary key when it’s single and a composite key when multiple fields are combined.
boolean expression
a logical expression that produces a true or false result
boolean operator
in context of searching a database, AND, OR and NOT connrctive words manage the results returned
database query
a code sent to a database to get information from that database
redundant data
duplicated data occurs when information is stored more than once in a data base. this leads to inconsistency.
verification
checking that the data in the database matches the data like it was originally captured
validation
automatic checks done on a database to ensure that the data in the database is sensible, reasonable, complete. And within a set of boundaries.
foreign key
links tables in a relational database by connecting a field in one table to the primary key in another
full form of SQL?
structured query language
Query
A question asked by the user
