ACCT 3220 Chapter 6 SmartBook

What is a data dictionary? A data dictionary is the design, implementation, repair, and security of a firm's database. A data dictionary describes the data fields in a database such as field type and field length.

A data dictionary describes the data fields in a database such as field type and field length. -- It describes the data fields in each database record such as field description, field length, field type (e.g., alphanumeric, numeric).

Explain what the multiplicity zero mean in the following relationship. Sales (0..*) ----- (1..1) Salesperson A salesperson may never sell any goods because most of them are students and work part-time. A salesperson should not be involved in In a sales transaction. A new salesperson whose information has been entered into the Salesperson table before performing any sales transaction.

A new salesperson whose information has been entered into the Salesperson table before performing any sales transaction.

Which of the following is a good example of a primary key for the Cash Receipt table?

Cash receipt number

Select a possible attribute for a class called CUSTOMER. Invoice number Product unit price Customer Address Sales dollar amount

Customer Address

Which of the following statements correctly describes the basic requirements of tables in a database? Each attribute in a table must have a unique name and the values of a specific attribute must be of the same type. The data value for a foreign key in a table cannot be null. Each column of a row may contain multiple data values. For example, a sales order may include different types of inventory. For data entry, we do not have to have a data value entered in the primary key field

Each attribute in a table must have a unique name and the values of a specific attribute must be of the same type.

True or false: A primary key is a unique identifier of tables.

False - A primary key is a unique identifier of records.

True or false: The entity integrity rule requires using foreign keys to link tables.

False -- The entity integrity rule requires that the primary key of a table must have data values.

True or false: In today's business world, we use the network data model only in designing databases.

False -- There are multiple types of data models used in business.

What is an enterprise system? It is also known as ERP. It is an integrated information system to be used across different functional areas of an organization. It often uses a database in establishing the system. It is rarely used by the accounting/finance department.

It is also known as ERP. It is an integrated information system to be used across different functional areas of an organization. It often uses a database in establishing the system.

All types of challenges emerge both from a technical and organizational perspective when implementing an enterprise system. Which of the following are examples of the challenges? It is not easy to get employees adequate training. It is too costly to implement an enterprise system. The system does not provide enough functions to be used in one department.

It is not easy to get employees adequate training. It is too costly to implement an enterprise system.

Choose the best answer to explain a hierarchical data model. It is most commonly used to manage many-to-many relationships so it is the best model to represent the structure of today's network. It organizes data into a tree-like structure that allows repeating information using defined parent/child relationships. It stores data in the form of two-by-two tables.

It organizes data into a tree-like structure that allows repeating information using defined parent/child relationships.

What is SQL?

Structured Query Language

What are the disadvantages of using cloud computing? The company that provides service in the cloud may not be reliable. Companies must ensure that sensitive data stored in the cloud are secure. The Internet connection may not be always available. Cloud computing is too slow to host an enterprise system.

The company that provides service in the cloud may not be reliable. Companies must ensure that sensitive data stored in the cloud are secure. The Internet connection may not be always available.

When using SQL, ____ should immediately follow the SELECT statement.

attribute names

A ______ _______ describes the data fields in each database record such as field description, field length, and field type (e.g., alphanumeric, numeric).

data dictionary

When designing a table using Microsoft Access, we use validation rules to provide input control such as requiring a field being numerical with a fixed length. We also enter information called validation text to tell the user what went wrong when entering data. All these features can be found in ___ properties.

field

Tables are linked by the use of _____ keys, forming an interconnected network of records that taken together are the relational database.

foreign

Tables are linked by the use of ______ keys, forming an interconnected network of records that taken together are the relational database.

foreign

Hierarchical data models organize data into a tree-like structure and are widely used in ____ database management systems

mainframe

A ____ data model is a flexible model representing objects and their relationships and allows M:N mapping.

network

The structure of a ____ data model connecting records in a database looks like a mesh.

network

When designing a table using Microsoft Access, we must choose the Required field as "Yes" and the Indexed field as "Yes (No Duplicates)" in the field properties box for the _____ key.

primary

When users want to find answers to questions in a Microsoft Access database such as the balance of accounts receivable, which function do they use?

query

All of the following are types of data models used in databases today: data model flexibility model relational model network model hierarchical model

relational model network model hierarchical model

Among the different types of data models, _____ data models are the dominant one in use today, because they offer advantages over other data models, including: flexibility and scalability, simplicity, and reduced information ____

relational, redundancy

ERP means enterprise _____ planning.

resource

In an REA data model, R means ___ , E means ____ , and A means ____

resources, events, and agents

List agents who are often involved in sales transactions: ___ and ___

salesperson and customer

What is the main function of "Tables" in Microsoft Access?

store data

A database is used to maintain information about ____

types of objects -- A database is used to maintain information about types of objects, events, people and places.