Unit 4a Flashcards

1
Q

Defined as recorded facts and figures

A

Data

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

Purpose to collect meaningful Information

A

Database

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

Systematic way to access data stored within database

A

Database System

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

Set of programs and utilities executed on computer to create, process, and administer a database

A

Database Management System (DBMS)

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

Database consists of one large table

A

Flat File Database

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

Consists of numerous tables containing rows and columns of data

A

Relational Database

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

Known facts recorded and have implicit meaning

A

Data

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

Data in database remains unchanged until acted upon

A

Persistent

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

Data in database interacts and corresponds with other data within the database

A

Integrated

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

Data in database has ability to be accessed and/or manipulated by multiple users

A

Shared

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

Computer equipment needed to use and maintain database

A

Hardware

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

Individuals using, manipulating or maintaining aspects of the database

A

User

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

Customers using product to query, update and generate reports generally using “canned transactions”

A

End User

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

Responsible for identifying data to be stored in database as well as choosing appropriate structures to represent and store data

A

Database Designer

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

Primary individual (or individuals) responsible for technical implementation and maintenance of database

A

Database Administrator (DBA)

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

Write programs designed to use or allow access to database with specific intended purpose

A

Application Programmers

17
Q

Refers to an object to store information in

18
Q

Provide description of the characteristics of the entity (Table)

A

Attributes

19
Q

Single unique occurrence of an entity within table

20
Q

Relational databases use this to express an absence of value

21
Q

Can dictate attribute must have value

22
Q

May dictate attribute entered into table is distinctly different from all other values in that attribute

23
Q

Provide “key” to making relational theory work

A

Special Attributes

24
Q

Specific attribute or set of attributes having been selected as unique identifier for the entity (Table)

A

Primary Key

25
Attributes within an entity (Table) that exist as Primary Key in another entity (Table)
Foreign Key
26
Relationships used to show where shared data values occur between entities
Parent-Child Relationships
27
Used to visually represent relationship of all entities in database
Entity Relationship (ER) Diagram