Accounting Information Systems 4th Edition - Chapter 6 - Key Terms - Relational Databases and Enterprise Systems

Descripción

Accounting Information Systems 4th Edition - Chap. 6 - Key Terms - Relational Databases and Enterprise Systems
Susan Esch
Fichas por Susan Esch, actualizado hace 3 meses
Susan Esch
Creado por Susan Esch hace 3 meses
3
0

Resumen del Recurso

Pregunta Respuesta
attributes Data elements that describe instances in a class, very much like fields in a database table; characteristics, properties, or adjectives that describe each class.
cloud computing Using redundant servers in multiple locations to host virtual machines.
data dictionary Describes the data fields in each database record such as field description, field length, and field type (e.g., alphanumeric, numeric).
database A shared collection of logically related data for various uses.
database administrator The person responsible for the design, implementation, repair, and security of a firm’s database.
database management system (DBMS) A computer program that creates, modifies, and queries the database. Specifically, the DBMS is designed to manage a database’s storage and retrieval of information.
enterprise system (ES) A centralized database that collects data from throughout the firm. Commercialized information system that integrates and automates business processes across a firm’s value chain located within and across organizations.
entity integrity rule The primary key of a table must have data values (cannot be null).
foreign key (FK) Attribute that allows database tables to be linked together; foreign keys are the primary keys of other tables placed in the current table to support the link between the two tables.
form Forms are utilized by users to enter data into tables and view existing records.
hierarchical data model Organizes data into a tree-like structure that allows repeating information using defined parent/child relationships.
network data model A flexible model representing objects and their relationships; allows each record to have multiple parent and child records or M:N mapping, also known as many-to-many relationships.
primary key (PK) An attribute or a combination of attributes that uniquely identifies an instance of a class in a data model or a specific row in a table.
query Query in Access is a tool used to retrieve and display data derived from records stored within the database.
referential integrity rule The data value for a foreign key must either be null or match one of the data values that already exist in the corresponding table.
relational data model Stores information in the form of related two-dimensional tables.
report Reports in Access are used to integrate data from one or more queries and tables to provide useful information to decision makers.
Structured Query Language (SQL) A computer language designed to retrieve data from a relational database.
Mostrar resumen completo Ocultar resumen completo

Similar

CPA Exam Topics and breakdown
joemontin
CPA Exam Flashcards
joemontin
CPA Exam Sample Questions Pt. 1
nedtuohy
Accounting Definitions
Tess Morris
Accounting I - Objective 2 Keller
Kathleen Keller
Exam Bank 2
Valek
Specific Order Costing
Natalie Gray
COSTING SYSTMES
Francia o
Glossary of Accounting Terms
racheloucks
Unit 4 The Accounting Cycle
a.j.hemphill
Chapter One: Introduction to Accounting
charlotte.power9