Block 2 - Unit 4a Flashcards Preview

Knowledge Operation Management (AF) > Block 2 - Unit 4a > Flashcards

Flashcards in Block 2 - Unit 4a Deck (32):
0

--------the expectations of the user is the first step in database design.

Discussing

1

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

Primary key

2

The most common type of data

Text

3

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

Access

4

Through --------- a database is scrambled and compacted

Encryption

5

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

User documentation

6

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

Description

7

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

Table

8

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

Auto number

9

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

Maintenance

10

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

Relationship database

11

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

Database

12

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

Unauthorized

13

A valuable resource to any organization , business or company

Data

14

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

Relationship

15

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

Physical design

16

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

Record

17

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

Field

18

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

Feedback.

19

A field's -------- determines the type of information that can be stored in that field.

Datatype

20

Define a relational database.

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

21

What is the first step in database design.

Discuss the expectations of the user

22

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

Determine the purpose of the database

23

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

Fields name

24

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

Description

25

What is the most common data type

Text

26

How many primary keys can there be on a table

One

27

What is a relationship, in regards to databases

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.

28

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

Stored

29

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

Encryption and password

30

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

User documentation.

31

List two examples of database maintenance.

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