Intro 2 Database

1. Compared to a manual database a computerized database is more flexible, compact, and faster.

True

False

2. Lack of planning has caused some programmers to be disappointed with the database they created.

True

False

3. Computerized database is compact; since database records stored in filing cabinets can be stored in just a few floppy diskettes.

True

False

4. It is the stage where we break down some fields to more specific fields so we can store information in the smallest logical parts.

Data definition

Data refinement

Establishing relationships

None of the above

5. This key uniquely identifies each record in a table.

Primary key

Key record

Unique key

Field name

6. It is a type of database where one or more tables are connected to other tables in the database, such as in the library system.

Relational database

List database

Flat-file database

None of the above

7. A column in a table is called a ___________.

Record

Column

Field

Horizontal

8. It refers to a row in a database table.

Record

Column

Vertical

Horizontal

9. It is an association established between common fields (columns) in two tables.

Line

Relationship

Primary key

Records

10. It is a collection of data that is related to a particular subject or purpose.

Database

List

Table

Group

11. A manual database is flexible; that is, it is possible to examine information from number of ways.

True

False

12. This is the stage in database design were one gathers and lists all the necessary fields for the database project.

Data definition

Data refinement

Establishing relationships

None of the above

13. What do you call the database that works with one set of database records at a time, such as the list of products in a Microsoft Excel file?

Relational database

List database

Flat file database

None of the above

14. Data refinement is the stage when we analyze our tables more closely and create a relationship between tables.

True

False

15. It stands for POS in a checkout counter.

Point-of-System

Proof-of-Sales

Point-of-Sales

None of the above

Intro 2 Database

1. Compared to a manual database a computerized database is more flexible, compact, and faster.

2.

What first name or nickname would you like us to use?

2. Lack of planning has caused some programmers to be disappointed with the database they created.

3. Computerized database is compact; since database records stored in filing cabinets can be stored in just a few floppy diskettes.

4. It is the stage where we break down some fields to more specific fields so we can store information in the smallest logical parts.

5. This key uniquely identifies each record in a table.

6. It is a type of database where one or more tables are connected to other tables in the database, such as in the library system.

7. A column in a table is called a ___________.

8. It refers to a row in a database table.

9. It is an association established between common fields (columns) in two tables.

10. It is a collection of data that is related to a particular subject or purpose.

11. A manual database is flexible; that is, it is possible to examine information from number of ways.

12. This is the stage in database design were one gathers and lists all the necessary fields for the database project.

13. What do you call the database that works with one set of database records at a time, such as the list of products in a Microsoft Excel file?

14. Data refinement is the stage when we analyze our tables more closely and create a relationship between tables.

15. It stands for POS in a checkout counter.