Data Storage Methods

Question 1

Building blocks of information

Answer 1

Data

Question 2

Produced by processing data; reveals the meaning of data

Answer 2

Information

Question 3

Shared, integrated computer structure

Answer 3

Database

Question 4

Two types of data

Answer 4

End user data

Metadata

Question 5

Main data

Answer 5

End user data

Question 6

Data about data

Answer 6

Metadata

Question 7

Manages Database Structure
Controls access to data
Contains query language

Answer 7

Database Management System (DBMS)

Question 8

Good at storage and easy to access

Answer 8

Database

Question 9

Good at calculation

Answer 9

Excel

Question 10

Has storage capacity limitation

Answer 10

Excel

Question 11

Better when parts of the data needs to be updated

Answer 11

DB

Question 12

Importance of DBMS (5)

Answer 12

Makes data management more efficient and effective

Query language allows quick answers to ad hoc queries

Provides better access to more and better-managed data

Promotes integrated view of organization’s operations

Reduces the probability of inconsistent data

Question 13

Importance of good design (2)

Answer 13

Poor design results in unwanted data redundancy

Poor design generates errors leading to bad decisions

Question 14

Focus on principles and concepts of database design; importance of logical design

Answer 14

Practical approach

Question 15

Raw facts

Answer 15

Data

Question 16

Group of characters with specific meaning

Answer 16

Field/Attribute (column header)

Question 17

Logically connected fields that describe a person, place or thing

Answer 17

Record/Row/Tuple

Question 18

Collection of related records

Answer 18

Table

Question 19

Entity/relation

Answer 19

Table

Question 20

Field/attribute

Answer 20

Column

Question 21

Record/instance

Answer 21

Row

Question 22

Stores data in several tables that are connected to each other

Answer 22

Relational Database Model

Question 23

Relational Database Model (3)

Answer 23

Perceived by user as a collection of tables for data storage

Tables are a series of row/column intersections

Tables related by sharing common entity characteristic(s)

Question 24

A column or several columns in the table, which uniquely identify each record in that table; there must be one and only one in each table

Answer 24

Primary key

Question 25

A column or several columns in a table, which are in then a PK in some other table; there may be more than one or none in a table

Answer 25

Foreign key

Question 26

Primary key placed in another table is a

Answer 26

Foreign key

Question 27

Database design requirements (3)

Answer 27

Store all data Avoid redundant storage of data Preserve the relationships between data

Question 28

How do we minimize data redundancy?

Answer 28

Primary Key

Question 29

How do we preserve relationships

Answer 29

Foreign Keys