38532411
Description
Flashcards by Tayler Shellhase, updated more than 1 year ago
|
Created by Tayler Shellhase
over 1 year ago
|
|
| Question | Answer |
| Attributes | Data elements that describe instances in a class, much like fields in a database table: properties, characteristics, or adjectives. These describe the classes. |
| Cloud Computing | Using redundant servers from multiple locations to host virtual machines. |
| Data Dictionary | Descriptions of the data fields in each database record like field description, field length, field type, etc. (Including alphanumeric and numeric and more). |
| Database | A shared collection of logically related data for various uses. |
| Database Administrator | The individual responsible for the implementation, design, security, and repair of a firm's database. |
| Database 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. |
| Enterprise 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. |
| Entity Integrity Rule | The primary key of the table must have data values. (It cannot be null). |
| Foreign 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. |
| Form | Utilized by users to enter data into tables and view existing records. |
| Hierarchlcal Data Model | Organizes date into a tree-like structure that allows repeating information using defined parent/child relationships. |
| Macro | Defined by Access users to automate processes such as opening a specific form. |
| Module | Some Microsoft applications come with modules built in that will be automatically added into Access. |
| Network Data Module | A 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). |
| Pages | Allow data to be entered into the database in real-time from outside of the database system. |
| Primary 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. |
| Query | An Access 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 | Used in Access to integrate data from one or more queries and tables to provide useful information to decision makers. |
| Structured Query Language (SQL) | Computer language designed to retrieve data from a relational database. |
Want to create your own Flashcards for free with GoConqr? Learn more.