MIS-ch6

1)Which of the following is an example of a pre-digital database?

• A library's card-catalog

• A cash register receipt

• A doctor's office invoice

• An SQL database

• A list of sales totals on a spreadsheet

What is the first step you should take in managing data for a firm?

• Cleanse the data before importing it to any database.

• Audit your data quality.

• Identify the data needed to run the business

• Normalize the data before importing to a database

• Remove redundancy.

Which of the following best illustrates the relationship between entities and attributes?

• The entity PRODUCT with the attribute PURCHASE

• The entity CUSTOMER with the attribute ADDRESS

• The entity PRODUCT with the attribute CUSTOMER

• The entity ADDRESS with the attribute CUSTOMER

• The entity CUSTOMER with the attribute PRODUCT

Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables?

• Two-tiered DBMS

• Pre-digital DBMS

• Relational DBMS

• Open source DBMS

• Hierarchical DBMS

What are the relationships that the relational database is named for?

• Relationships between entities

• Relationships between fields and records

• Relationships between rows and columns

• Relationships between databases

) A characteristic or quality describing an entity is called a(n):

• field

• tuple

• attribute

• table

The most basic business database is comprised of:

• three tables: for suppliers, parts, and sales

• four tables: for customers, suppliers, parts, and sales.

• four tables: for customers, suppliers, sales, and employees

• five tables: for customers, employees, suppliers, parts, and sales.

In a table for customers, the information about a single customer would reside in a single:

• row

• column

• entity

• field

In a relational database, a record is also called a(n):

• tuple

• field

• entity

• table

A field identified in a table as holding the unique identifier of the table's records is called the:

• primary field.

• identifying field

• primary key.

• foreign key.