Basic Relational Database Design Principles

Question 1

Transactional vs analytical purposes

that firms use information for

Answer 1

Day to day operations; trend analyses, forecasts, and input generation for strategies that improve profit or long-term sustainability - compete on analytics

Question 2

Columns store a specific kind of data called

Answer 2

An attribute or field

Question 3

Rows store values of attributes about

Answer 3

A specific example of something in the real world. Also called a record

Question 4

Major purpose of a database

Answer 4

To keep track of related information about more than one thing

Question 5

A named, two dimensional table of data which consists of rows (records) and columns (attributes or fields)

Answer 5

A relation

Question 6

Requirements for a table to qualify as a relation

Answer 6

Table must have a unique name
Attributes must have unique names
Each attribute must be atomic (not multivalued)
Each record must be unique
Order of rows and columns must be irrelevant

Question 7

relational database

Answer 7

Consists of one or more (probably interconnected) relations

Question 8

Crucial activities of a relational database (3)

Answer 8

1. Input information into the database
2. Update/delete information in the database
3. Retrieve information from the database, i.e. run a query on the database