Shorties Flashcards

1
Q

Database environment

A

hardware - single device,multi-processor

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

ansi/sparc

A

adjusting schemas - give data independence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

DBMS

A

dbms - define create maintain
dictionary - contains metadata
ddl - allow spec
dml - provide enquiry

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

client server apps

A
two or more machines
database and dbms
user interface apps
flexible
performance
cheap
consistent
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

data models

A

integrated concepts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

conceptual data

A

develops representation requirements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

conceptual schema

A

core definition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

view

A

defined query, base relation, conceptual schema, dynamic, virtual
updateable for single, non updateable for multiple

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

enity type

A

classifies

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

relationship occurence

A

unique association

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

relationship degree

A

entity types in relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

attributes

A

property
domain - acceptable values
simple - single
composite - multiple

How well did you know this?
1
Not at all
2
3
4
5
Perfectly