37495101
Description
Flashcards by JACKSON BOEVE, updated more than 1 year ago
|
|
Created by JACKSON BOEVE
about 2 years ago
|
|
| Question | Answer |
| Attributes | Data elements that describe class instances, like fields in a database table, characteristics, properties, or adjectives, define 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, field type (e.g., alphanumeric, numeric), etc. |
| Database | A shared collection of logically related data for various uses. |
| Database Administrator | The person responsible for designing, implementing, repairing, and securing 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. A commercialized information system that integrates and automates business processes across a firm's value chain 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 inked together; foreign keys are the primary keys of other tables placed in the current table to support the link between the two tables. |
| Form | Users utilize forms 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. |
| Macro | Access users define macros to automate processes such as opening a specific form. |
| Module | Some Microsoft applications come with built-in modules that will be automatically added to Access. |
| 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. |
| Pages | Access pages allow data to be entered into the database from outside the system in real-time. |
| Primary 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. |
| Query | Query in Access is a tool to retrieve and display data 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 already in the corresponding table. |
| Relational Data Model | Stores information in the form of related two-dimensional tables. |
| Report | Report in Access integrates data from one or more queries and tables to provide helpful information to decision-makers. |
| Structured Query Language (SQL) | A computer language designed to retrieve data from a relational database. |
Want to create your own Flashcards for free with GoConqr? Learn more.