39796115
Description
Flashcards by Richard Kramer, updated 3 months ago
|
Created by Richard Kramer
3 months ago
|
|
| Question | Answer |
| Attributes | Data elements that describe instances in a 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, etc |
| Database | A shared collection of logically related data for various uses |
| Database administrator | Person responsible for the design, implementation, repair, and security of a firm's database |
| Database management system (DBMS) | Computer program that creates, modifies, and queries the database. Designed to manage the storage and retrieval of information |
| Enterprise system (ES) | Centralized database that collects data from throughout the firm. They integrate and automate business processes across a firm's value chain within and across organizations |
| Entity integrity rule | Primary key of a table must have data values (cannot be null) |
| Foreign key (FK) | Attribute that allows database tables to be linked together; they are primary keys of other tables placed in the current table to support the link between the two tables |
| Form | Utilized by users 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 |
| Network data model | Flexible model representing objects and their relationships; allows each record to have multiple parent/child records, many-to-many (M:N) |
| Primary key (PK) | Attribute or combo of attributes that uniquely identifies an instance of a class in a data model or a specific row in a table |
| Query | In Access, A 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 | In Access, used to integrate data from one or more queries and tables to provide useful information to decision makers |
| Structured Query Language (SQL) | A computer language designed to retrieve data from relational databases |
| Table | Stores data |
| Class (entity) | Person, place, thing, transaction, or event |
| R,E,A | Resources, Events, Agents |
| CRUD | Create, Read, Update, Delete |
| ERP | Enterprise resource planning |
| Field properties | Validation rules and text for an attribute in table design |
Want to create your own Flashcards for free with GoConqr? Learn more.