Flashcards
Bus 342 Chapter 6 Key Terms
Flashcards do conjunto (24)
- 1AttributesData elements that describe instances in a class
- 2Cloud computingUsing redundant servers in multiple locations to host virtual machines
- 3Data dictionaryDescribes the data fields in each database record such as field description, field length, etc
- 4DatabaseA shared collection of logically related data for various uses
- 5Database administratorPerson responsible for the design, implementation, repair, and security of a firm's database
- 6Database management system (DBMS)Computer program that creates, modifies, and queries the database. Designed to manage the storage and retrieval of information
- 7Enterprise 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
- 8Entity integrity rulePrimary key of a table must have data values (cannot be null)
- 9Foreign 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
- 10FormUtilized by users to enter data into tables and view existing records
- 11Hierarchical data modelOrganizes data into a tree-like structure that allows repeating information using defined parent/child relationships
- 12Network data modelFlexible model representing objects and their relationships; allows each record to have multiple parent/child records, many-to-many (M:N)
- 13Primary 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
- 14QueryIn Access, A tool used to retrieve and display data derived from records stored within the database
- 15Referential 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
- 16Relational data modelStores information in the form of related two-dimensional tables
- 17ReportIn Access, used to integrate data from one or more queries and tables to provide useful information to decision makers
- 18Structured Query Language (SQL)A computer language designed to retrieve data from relational databases
- 19TableStores data
- 20Class (entity)Person, place, thing, transaction, or event
- 21R,E,AResources, Events, Agents
- 22CRUDCreate, Read, Update, Delete
- 23ERPEnterprise resource planning
- 24Field propertiesValidation rules and text for an attribute in table design
Informações
- Descrição
- Key Terms for Chapter 6 in Accounting Information Systems 4th edition
- Criado por
- Richard Kramer
- Visualizações
- 52
- Tags
- Avaliação