Block 2 - Unit 4a

Question 0

The field whose value uniquely identifies each record on a table is known as the———–

Answer 0

Primary key

Question 1

——–the expectations of the user is the first step in database design.

Answer 1

Discussing

Question 2

The most common type of data

Answer 2

Text

Question 3

You can combine and maintain large amounts of data in one ——— database

Answer 3

Access

Question 4

Through ——— a database is scrambled and compacted

Answer 4

Encryption

Question 5

To prevent errors or corruptions you must provide users with ——— which include how to navigate through records and how to add/edit data.

Answer 5

User documentation

Question 6

To make your database easier to use, enter a ——– for each field.

Answer 6

Description

Question 7

Lays the foundation for every database and is limited to a single distinct subject.

Answer 7

Table

Question 8

Apply the ———- data type when no other field can be the primary key

Answer 8

Auto number

Question 9

Creating new fields, changing a data type, or moving the location of the database fall under database ———-

Answer 9

Maintenance

Question 10

A collection of data contained in multiple tables, each similar to each other.

Answer 10

Relationship database

Question 11

A structured collection of data that is stored in a computer system.

Answer 11

Database

Question 12

Databases maintain a great amount of vital information and must be protected from ——– access

Answer 12

Unauthorized

Question 13

A valuable resource to any organization , business or company

Answer 13

Data

Question 14

In a database,a ——— exists between common fields on different tables

Answer 14

Relationship

Question 15

Determining where to store the database is apart of the —————

Answer 15

Physical design

Question 16

Represents exactly one instance of the object or event which the table holds details about.

Answer 16

Record

Question 17

Describes the information contained in the column and should be something that will be easily recognizable.

Answer 17

Field

Question 18

Request ———– from users to ensure the database is and remains effective.

Answer 18

Feedback.

Question 19

A field’s ——– determines the type of information that can be stored in that field.

Answer 19

Datatype

Question 20

Define a relational database.

Answer 20

Collection of data contained in multiple tables, each similar to each other

Question 21

What is the first step in database design.

Answer 21

Discuss the expectations of the user

Question 22

What is done before you identify the types of data to store in your database?

Answer 22

Determine the purpose of the database

Question 23

The ——– describes the info contained in a column and should be something that will be easily recognized

Answer 23

Fields name

Question 24

Typing a ——– for each field helps a user input appropriate data into that field.

Answer 24

Description

Question 25

What is the most common data type

Answer 25

Text

Question 26

How many primary keys can there be on a table

Answer 26

One

Question 27

What is a relationship, in regards to databases

Answer 27

A link between two similar things. Between common fields on multiple tables and ensures data is not accidentally updated on one table but not on the other.

Question 28

During the physical design, you must determine where the database will be ——-

Answer 28

Stored

Question 29

One auto restrict access to a database is to apply a combination of ———-and ———

Answer 29

Encryption and password

Question 30

To prevent data error or corruption within the database you must provide users with ———- ————

Answer 30

User documentation.

Question 31

List two examples of database maintenance.

Answer 31

Create new fields and Change data type from text to number.