Flashcards
Chapter 4 Key Terms
Flashcards do conjunto (21)
- 1AttributesData elements that describe instances in a class, much like fields in a database table: properties, characteristics, or adjectives. These describe the classes.
- 2Cloud ComputingUsing redundant servers from multiple locations to host virtual machines.
- 3Data DictionaryDescriptions of the data fields in each database record like field description, field length, field type, etc. (Including alphanumeric and numeric and more).
- 4DatabaseA shared collection of logically related data for various uses.
- 5Database AdministratorThe individual responsible for the implementation, design, security, and repair of a firm's database.
- 6Database Management System (DBMS)A computer program which creates, modifies, and queries a database. It is designed to manage a database's storage and retrieval of information.
- 7Enterprise System (ES)A centralized database which collects data from the whole firm. A commercialized information system which integrates and automates business processes across a firm's value chain located within and across organizations.
- 8Entity Integrity RuleThe primary key of the table must have data values. (It cannot be null).
- 9Foreign Key (FK)An attribute that allows database tables to be linked together. They are the primary keys of other tables placed in the current table to support the like between the two tables.
- 10FormUtilized by users to enter data into tables and view existing records.
- 11Hierarchlcal Data ModelOrganizes date into a tree-like structure that allows repeating information using defined parent/child relationships.
- 12MacroDefined 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 into Access.
- 14Network Data ModuleA flexible model representing objects and their relationships. It allows each record to have multiple parent/child records or M:N mapping. (Known as many-to-many relationships).
- 15PagesAllow data to be entered into the database in real-time from outside of the database system.
- 16Primary Key (PK)An attribute or a combination that uniquely identifies an instance of a class in a data model or a specific row in a table.
- 17QueryAn Access 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.
- 20ReportUsed in Access to integrate data from one or more queries and tables to provide useful information to decision makers.
- 21Structured Query Language (SQL)Computer language designed to retrieve data from a relational database.
Informações
- Descrição
- Flashcards reviewing each of the key terms from Chapter 4 of BUS 342 at Peru State College.
- Criado por
- Tayler Shellhase
- Visualizações
- 23
- Tags
- Avaliação