Chapter 5 Flashcards
a structured collection of data stored for use by one or more applications.
Database
a suite of programs for constructing and maintaining the database and for offering ad hoc query facilities to multiple users and applications
database management system (DBMS)
provides a uniform interface to the database for users and applications
query language
What is the basic building block of a relational database
table of data
In relational database parlance the basic building block is
relation
rows are referred to as
tuples
columns are referred to as
attributes
is defined to be a portion of a row used to uniquely identify a row in a table
primary key
to create a relationship between two tables, the attributes that define the primary key in one table must appear as attributes in another table, where they are referred to as
foreign keys
a ___ is a virtual table. a ____ is the result of a query that returns selected rows and columns from one or more tables.
view
the process of performing authorized queries and deducing unauthorized information from legitimate responses received.
inference
the information transfer path by which unauthorized data is obtained if referred to as ____
inference channel
Statistics are derived from a database by means of a _____
characteristic formula
where a user may infer confidential information about individual entities represented in the SDB
Compromise
Protection of an SDB. ____ rejects a query that can lead to a compromise. The answers provided are accurate
query restriction