Chapter 4: Relational Databases and Enterprise Systems

studied byStudied by 0 people
0.0(0)
Get a hint
Hint

attributes

1 / 19

encourage image

There's no tags or description

Looks like no one added any tags here yet for you.

20 Terms

1

attributes

Data elements that describe instances in a class, very much like fields in a database table; characteristics, properties, or adjectives that describe each class.

New cards
2

cloud computing

Using redundant servers in multiple locations to host virtual machines.

New cards
3

data dictionary

Describes the data fields in each database record such as field description, field length, field type (e.g., alphanumeric, numeric), etc.

New cards
4

database

A shared collection of logically related data for various uses.

New cards
5

database administrator

The person responsible for the design, implementation, repair, and security of a firm’s database.

New cards
6

database management system (DBMS)

A computer program that creates, modifies, and queries the database. Specifically, the DBMS is designed to manage a database’s storage and retrieval of information.

New cards
7

enterprise system (ES)

A centralized database that collects data from throughout the firm. Commercialized information system that integrates and automates business processes across a firm’s value chain located within and across organizations.

New cards
8

entity integrity rule

The primary key of a table must have data values (cannot be null).

New cards
9

foreign key (FK)

Attribute that allows database tables to be linked together; foreign keys are the primary keys of other tables placed in the current table to support the link between the two tables.

New cards
10

form

Forms are utilized by users to enter data into tables and view existing records

New cards
11

hierarchical data model

Organizes data into a tree-like structure that allows repeating information using defined parent/child relationships.

New cards
12

macro

Macros are defined by Access users to automate processes such as opening a specific form.

New cards
13

module

Some Microsoft applications come with modules built in that will be automatically added onto Access.

New cards
14

pages

Access pages allow data to be entered into the database in real time from outside of the database system.

New cards
15

primary key (PK)

An attribute or a combination of attributes that uniquely identifies an instance of a class in a data model or a specific row in a table.

New cards
16

query

Query in Access is a tool used to retrieve and display data derived from records stored within the database.

New cards
17

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.

New cards
18

relational data model

Stores information in the form of related two-dimensional tables.

New cards
19

report

are used to integrate data from one or more queries and tables to provide useful information to decision makers.

New cards
20

Structured Query Language (SQL)

A computer language designed to retrieve data from a relational database.

New cards

Explore top notes

note Note
studied byStudied by 7 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 13 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 6 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 5 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 134 people
Updated ... ago
5.0 Stars(2)
note Note
studied byStudied by 5 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 13 people
Updated ... ago
5.0 Stars(2)
note Note
studied byStudied by 21 people
Updated ... ago
5.0 Stars(1)

Explore top flashcards

flashcards Flashcard38 terms
studied byStudied by 24 people
Updated ... ago
5.0 Stars(4)
flashcards Flashcard20 terms
studied byStudied by 1 person
Updated ... ago
5.0 Stars(1)
flashcards Flashcard97 terms
studied byStudied by 11 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard23 terms
studied byStudied by 14 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard132 terms
studied byStudied by 1 person
Updated ... ago
5.0 Stars(3)
flashcards Flashcard21 terms
studied byStudied by 14 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard42 terms
studied byStudied by 2 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard24 terms
studied byStudied by 820 people
Updated ... ago
4.5 Stars(18)