Flashcards
Chapter 4 Key Terms
Flashcards do conjunto (21)
- 1AttributesData elements that describe class instances, like fields in a database table, characteristics, properties, or adjectives, define 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 designing, implementing, repairing, and securing 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. A commercialized information system that integrates and automates business processes across a firm's value chain 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 inked together; foreign keys are the primary keys of other tables placed in the current table to support the link between the two tables.
- 10FormUsers utilize forms 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.
- 12MacroAccess users define macros to automate processes such as opening a specific form.
- 13ModuleSome Microsoft applications come with built-in modules that will be automatically added to 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 from outside the system in real-time.
- 16Primary Key (PK)An attribute or a combination of features uniquely identifies an instance of a class in a data model or a specific row in a table.
- 17QueryQuery in Access is a tool to retrieve and display data 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 already in the corresponding table.
- 19Relational Data ModelStores information in the form of related two-dimensional tables.
- 20ReportReport in Access integrates data from one or more queries and tables to provide helpful information to decision-makers.
- 21Structured Query Language (SQL)A computer language designed to retrieve data from a relational database.
Informações
- Descrição
- Chap 4 Vocab-Relational Databases and Enterprise Systems
- Criado por
- JACKSON BOEVE
- Visualizações
- 43
- Tags
- Avaliação