Chapter 5 Flashcards
Database
a structured collection of data stored for use by one or more applications.
Database management system
a suite of programs for constructing and maintain the database
query language
provides a uniform interface to the database for users and applications.
How many primary keys and how many foreign keys may a table have in a relational database?
One primary key per tuple, but there can be multiple foreign keys.
What are the disadvantages to database encryption
Key management and inflexibility.
List and briefly define three cloud service models
Software as a service: Provides service to customers in the form of software.
Platform as a service: Provides service to customers in the form of a platform on which the customer’s applications can run.
Infrastructure as a service: Provides the customer access to the underlying cloud infrastructure.
relation
a flat table
Tuples
Rows
Attributes
columns
Primary key
portion of a row used to uniquely identify a row in a table
foreign key
a primary key in one table that appears as attributes in another table
view
a virtual table
Three attack types
inband, inferential and out of band.
cloud computing
a model for enabling ubiquitous, convenient, on-deman network access to a shared pool of resources.
essential characteristics of cloud computing
Broad network access Rapid elasticity measured service on-demand self-service resource pooling