Erstellt von Richard Kramer
vor 4 Monate
|
||
Frage | Antworten |
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 |
Möchten Sie mit GoConqr kostenlos Ihre eigenen Karteikarten erstellen? Mehr erfahren.