Flashcard Set Preview
| Side A | Side B | ||
| 1 |
spreadsheet
|
not
as interactive, single themed if the list is simple
|
|
| 2 |
database
|
self
describing collection of integrated records (contains metadata- data that describes data), Self
describing-...
|
|
| 3 |
primary key
|
unique
identifier, every table has a key
|
|
| 4 |
foreign key
|
same
name of primary key in another table
|
|
| 5 |
entity
|
what
you keep track of; singular not plural
|
|
| 6 |
attribute
|
describes
the entity; characteristics of entity
|
|
| 7 |
field
|
columns
in the table
|
|
| 8 |
record
|
rows
in the table
|
|
| 9 |
table
|
group
of similar rows and records, every table has a key
|
|
| 10 |
DBMS
|
software/program, tracks problems and manages solutions, processes database into tables and...
|
|
| 11 |
SQL
|
structured query language, an international standard for processing data, Add data...
|
|
| 12 |
data application
|
collection
of forms to update, add, insert, delete data
|
|
| 13 |
permission
|
allows
for special access
|
|
| 14 |
limit
|
create
a ceiling/floor that established a max/min
|
|
| 15 |
event programming
|
clicking
mouse or pressing enter key
|
|
| 16 |
locking
|
-
avoids multiuser processing; two people cannot work on the database at same
time
|
|
| 17 |
personal DBMS
|
run
application programs using cache memory (meet needs directly, business
oriented/specific),...
|
|
| 18 |
enterprise DBMS
|
application
systems store separately, open 24/7
|
|
| 19 |
component object model
|
does
one thing, easy to organize, less chance of making mistakes
|
|
| 20 |
key
|
every
table has a key, column or group of columns that identifies a unique row
|
|
| 21 |
data structure
|
structure
for data to create efficiency, particular way of organizing data
|
|
| 22 |
database administrator
|
never a user; important for them not to have an investment interest in avoid bias; responsible...
|
|
| 23 |
steering committee
|
de development
and maintenance, dynamic and always changing, represents all users, validate...
|
|
| 24 |
disaster recovery
|
how
long it takes to recover and get up and running again
|
|
| 25 |
data model
|
logical
representation of what the data will look like, accurately reflects the
business
|
|
| 26 |
E-R Data Model
|
developers
describe the content of the model/databases, describe the entities and the
relationship...
|
|
| 27 |
UML
|
unified model language, pictorial
relationship of what the database will look like
|
|
| 28 |
Logic
|
same
ticket cannot be sold to more than one person at the same time
|
|
| 29 |
1:N
|
one
department can have many advisors
|
|
| 30 |
M:N
|
-
many advisors can have many students
|
|
| 31 |
Max Cardinality
|
max
# of entities that can be involved in relationship
|
|
| 32 |
Min Cardinality
|
min
# of entities involved in relationship
|
|
| 33 |
Data Design
|
process
of converting data into tables, attributes describe the entity, foreign key has same...
|
|
| 34 |
Data constraint
|
ensure
accuracy and consistency with the data
|
|
| 35 |
normalization
|
process
of converting two poorly constructed (malformed) tables into well structured tables,
get...
|
|
| 36 |
data integrity problem
|
duplicate
data
|
No comments yet! Be the first to add a comment below!
Please login to post comments.
After login, we will forward you back to this flashcard.