MIS Ch. 5

Question 0

Database

Answer 0

A self-describing COLLECTION of integrated RECORDS

Question 1

What is the Purpose of a Database?

Answer 1

To KEEP TRACK of things

Question 2

Columns

Answer 2

Fields

Question 3

Rows

Answer 3

Records

Question 4

Table

Answer 4

File

Question 5

Key/ Primary Key

Answer 5

A column or group of columns that identifies a unique row in a table

Question 6

Metadata

Answer 6

Data that describes data

Question 7

Foreign Keys

Answer 7

Keys of a different table than the one in which they reside

Question 8

Relational Databases

Answer 8

Databases that carry their data in the form of tables and represent relationships using foreign keys

Question 9

Database Management System (DBMS)

Answer 9

A PROGRAM used to create, process, & administer a database

• Ex: DB2, Access, SQL Server, & Oracle Database

Question 10

Structured Query Language (SQL)

Answer 10

And international standard language for processing a database

Question 11

Database Administration

Answer 11

Used to set up a SECURITY system involving user accounts, passwords, permissions, and limits for processing the database

Question 12

Database Application

Answer 12

A COLLECTION of forms, reports, queries, & application programs that serves as an INTERMEDIARY between users & database data

Question 13

Graphical Queries

Answer 13

CRITERIA are created when the user clicks on a graphic.

Question 14

Multi-User Processing

Answer 14

Multiple users processing the same database

Question 15

Lost-Update Problem

Answer 15

Two users update the same data item, but only one of those changes is recorded in the data.

Question 16

Entity-Relationship (E-R) Data Model

Answer 16

A TOOL for CONSTRUCTING data models by defining the entities that will be stored in the database and the relationships among those entities

Question 17

Entity

Answer 17

Something that USERS want to TRACK

• Ex: Order, Customer, Salesperson, Item

Question 18

Attributes

Answer 18

Describe characteristics of the entity

• Ex (for Order entity): OrderNumber, OrderDate, SubTotal, Tax, Total

Question 19

Identifier

Answer 19

An ATTRIBUTE or group of attributes whose value is associated with only ONE ENTITY instance

Question 20

Relationships

Answer 20

Associations among entities or entity instances in an E-R model, or an association among rows of a table in a relational database

Question 21

Crow’s Feet

Answer 21

LINES on an entity-relationship diagram that indicate a 1:N relationship between two entities

Question 22

Crow’s-Foot Diagram

Answer 22

A type of entity-relationship diagram that uses a crow’s foot symbol to designate a 1:N relationship

Question 23

Entity-Relationship (E-R) Diagram

Answer 23

A type of diagram used by database DESIGNERS to DOCUMENT entities and their relationships to each other

Question 24

1:N

Answer 24

One-to-many relationship

Question 25

N:M

Answer 25

Many-to-many relationship

Question 26

Normalization

Answer 26

The process of converting a poorly structured table into two or more well-structured tables

Question 27

Maximum Cardinality

Answer 27

The maximum number of entities that can be involved in a relationship

Question 28

Minimum Cardinality

Answer 28

The minimum number of entities required in a relationship

Question 29

Data Integrity Problem

Answer 29

When data items DISAGREE with one another

• Ex: two different names for the same customer

Question 30

Normal Forms

Answer 30

Forms of tables that remove duplicated data and other problems

Question 31

MongoDB

Answer 31

And open-source, document-oriented, non-relational DBMS

Question 32

NoSQL Databases

Answer 32

NON-RELATIONAL databases that support very high TRANSACTION RATES processing SIMPLE data structures, replicated on many servers in the cloud

Question 33

Data Model

Answer 33

Describes the data & relationships that will be stored in the database