Databases

Question 1

Entities

Answer 1

Things that data has been collected about (top column)

Question 2

Tables

Answer 2

2D representations of data that is stored in rows and columns

Question 3

Forms

Answer 3

What data is submitted to a database in

Question 4

Queries

Answer 4

Request for data from the database, where data is retrieved

Question 5

Reports

Answer 5

Presentations of data from the database

Question 6

Modules

Answer 6

Add additional functionality to a database that aren’t built in

Question 7

Tables, entity relationship

Answer 7

Tables contain the data from the entities. The entities are usually the table columns and the rows contain the data associated with them

Question 8

Data residency

Answer 8

Data is unnecessarily repeated in two or more tables.

Inefficient, should be avoided.

Question 9

Relational database

Answer 9

Tables linked together with each other by key fields

Question 10

Key field

Answer 10

Unique identifier in each table that links that table to at least one other

Question 11

Primary key

Answer 11

in one table is the foreign key in another table