Karteikarten
BUS 342 Chapter 4 Key Terms Flashcards
Karten in diesem Stapel (21)
- 1attributesData elements that describe instances in a class, very much like fields in a database table; characteristics, properties, or adjectives that describe each class.
- 2cloud computingUsing redundant servers in multiple locations to host virtual machines.
- 3data dictionaryDescribes the data fields in each database record such as field description, field length, field type (e.g., alphanumeric, numeric), etc.
- 4databaseA shared collection of logically related data for various uses.
- 5database administratorThe person responsible for the design, implementation, repair, and security of a firm’s database.
- 6database 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.
- 7enterprise 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.
- 8entity integrity ruleThe primary key of a table must have data values (cannot be null).
- 9foreign 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.
- 10formForms are utilized by users to enter data into tables and view existing records.
- 11hierarchical data modelOrganizes data into a tree-like structure that allows repeating information using defined parent/child relationships.
- 12macroMacros are defined by Access users to automate processes such as opening a specific form.
- 13moduleSome Microsoft applications come with modules built in that will be automatically added onto Access.
- 14network data modelA 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.
- 15pagesAccess pages allow data to be entered into the database in real time from outside of the database system.
- 16primary 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.
- 17queryQuery in Access is a tool used to retrieve and display data derived from records stored within the database.
- 18referential integrity ruleThe data value for a foreign key must either be null or match one of the data values that already exist in the corresponding table.
- 19relational data modelStores information in the form of related two-dimensional tables.
- 20reportReports in Access are used to integrate data from one or more queries and tables to provide useful information to decision makers.
- 21Structured Query Language (SQL)A computer language designed to retrieve data from a relational database.
Informationen
- Beschreibung
- Key terms flashcards for Chapter 4 of Accounting Information Systems
- Erstellt von
- Nick Ramlall
- Aufrufe
- 76
- Tags
- Bewertung