chapter 5 Flashcards

1
Q

when they ask you a real life example question how should you answer

A

dont think rationally think what would the teacher and makers of the course want you to say and answer accordinly ( dont use common sense)

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

what is the international standard languarge for processing a database

A

structured query language

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

what is another name for columns in a database

A

fields

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

what type of database feild is best for storing the response of a yes or no question

A

yes/no

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

what process operation is used to edit info stored in a database

A

modify

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

what is not a reason that the relational database model can be replaced

A

ACID transactions are not critical anymore

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

relational database storing data that represent relationships using what

A

foreign keys

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

what is content

A

its the data and stuff that is important to a organization

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

what is a DBMS and a CMS

A

content management systems

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

what is a spreadsheet

A

something that keeps lists involving a single important thing

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

what is a database

A

keeps a list of multiple related things ( themes) and is a set of tables that are logically related

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

what is a bit

A

its the smallest unit either 0 or 1

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

what is a byte

A

= to 8 bits and is the most common storage unit

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

what is a field (representation)

A

its a representation of one fact

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

what is a record

A

a group of related fields

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

what is the master record

A

a record representing the status of a business entity

17
Q

what is a transaction record

A

a record representing a event in a business

18
Q

what is a table (records)

A

its a set of records about a thing or a event

19
Q

what is a primary key (records)

A

its a field that uniquely identifies records

20
Q

what is a database application

A

a collection of forms and stuff that process a database and make its content more useful