37472350
Description
Flashcards by MacKenzie Burch, updated more than 1 year ago
|
Created by MacKenzie Burch
over 1 year ago
|
|
| Question | Answer |
| attributes | Words that describe each class. Columns within tables. |
| cloud computing | Using redundant servers in multiple locations to host virtual machines. |
| data dictionary | Data fields in each record (i.e. field description, field length, field type, etc.). |
| database | a collection of related data for various uses |
| database administrator | person or people responsible for design, implementation, repair, and security of a database |
| database management system | computer program that creates, modifies, and queries data |
| enterprise system (ES) | commercialized information systems that integrate and automate business processes |
| entity integrity rule | Rule that states Primary Key must have data values. |
| foreign key (FK) | an attribute in one table, a primary key in another table. the link between 2 tables. |
| form | Used in Microsoft Access to enter data and view existing records. |
| hierarchical data model | Data model that uses mainframe data management with tree-like structures representing parent/child relationships. 1:N mapping- one parent, more than one child. |
| macro | Used in Microsoft Access to automate processes. |
| module | Used in Microsoft Access to alter Access's code. |
| network data model | Flexible data model that represents objects and their relationships. M:N mapping- many to many relationships. Creates lattice-like structures. |
| pages | Used in web-based Microsoft Access to allow data to be entered in real time. |
| primary key (PK) | attribute/attributes that identify a specific row in a table. |
| query | Used in Microsoft Access to retrieve and display data. |
| referential integrity rule | Rule that states a Foreign key must be null OR match an already existing data value. |
| relational data model | Data model that stores information in related two-dimensional tables. Advantages of flexibility and scalability, simplicity, and reducing redundancy compared to other data models. |
| report | Used in Microsoft Access to integrate data from one or more queries and tables. |
| Structured Query Language (SQL) | Designed to query data in relational database |
Want to create your own Flashcards for free with GoConqr? Learn more.