Last notes

Question 1

—– means that every foreign key in a secondary table matches a primary key that is in the par- ent table

Answer 1

Referential integrity

Question 2

——- means that every attribute
(column) value is consistent with the attribute data type.

Answer 2

Semantic integrity

Question 3

—— means that every tuple has a unique pri- mary key that is not null.

Answer 3

Entity integrity

Question 4

—— seeks to make the data in a database table logically con- cise, organized, and consistent. It removes redundant data and improves data- base integrity and availability.

Answer 4

Database normalization

Question 5

Which type of database language is used to create, modify, and/or delete tables?

Answer 5

Data Definition Language (DDL)

Question 6

Which vulnerability allows a third party to redirect static content within the security context of a trusted site?

Answer 6

Cross-Site Request Forgery (CSRF)

Note: Remember the word ‘redirect’

Question 7

The goal of ——– is to develop a methodical framework for creating quality soft- ware that allows measurable and repeatable results:

Answer 7

Capability Maturity Model (CMM)