Unit 4a

Question 1

Defined as recorded facts and figures

Answer 1

Data

Question 2

Purpose to collect meaningful Information

Answer 2

Database

Question 3

Systematic way to access data stored within database

Answer 3

Database System

Question 4

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

Answer 4

Database Management System (DBMS)

Question 5

Database consists of one large table

Answer 5

Flat File Database

Question 6

Consists of numerous tables containing rows and columns of data

Answer 6

Relational Database

Question 7

Known facts recorded and have implicit meaning

Answer 7

Data

Question 8

Data in database remains unchanged until acted upon

Answer 8

Persistent

Question 9

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

Answer 9

Integrated

Question 10

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

Answer 10

Shared

Question 11

Computer equipment needed to use and maintain database

Answer 11

Hardware

Question 12

Individuals using, manipulating or maintaining aspects of the database

Answer 12

User

Question 13

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

Answer 13

End User

Question 14

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

Answer 14

Database Designer

Question 15

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

Answer 15

Database Administrator (DBA)

Question 16

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

Answer 16

Application Programmers

Question 17

Refers to an object to store information in

Answer 17

Entities

Question 18

Provide description of the characteristics of the entity (Table)

Answer 18

Attributes

Question 19

Single unique occurrence of an entity within table

Answer 19

Instance

Question 20

Relational databases use this to express an absence of value

Answer 20

Null

Question 21

Can dictate attribute must have value

Answer 21

Not Null

Question 22

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

Answer 22

Unique

Question 23

Provide “key” to making relational theory work

Answer 23

Special Attributes

Question 24

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

Answer 24

Primary Key

Question 25

Attributes within an entity (Table) that exist as Primary Key in another entity (Table)

Answer 25

Foreign Key

Question 26

Relationships used to show where shared data values occur between entities

Answer 26

Parent-Child Relationships

Question 27

Used to visually represent relationship of all entities in database

Answer 27

Entity Relationship (ER) Diagram