Chapter 5

Question 1

What is a Database?

Answer 1

Allows you to access, manage, & update data.

Question 2

Islands of info?

Answer 2

Body of info that needs to be shared but has no network connection

Question 3

Data hierarchy:

Answer 3

Bit - 0-1's
Byte - 8 bits in a byte
Field 
Record
Table (file)
Database

Question 4

Primary/Secondary Keys?

Answer 4

Primary - A field that uniquely identifies records

Secondary - An additional key that can be used with primary to locate specific data (more secure)

Question 5

What is DBMS and what does it do?

Answer 5

Software package designed to store, manipulate, retrieve, & manage data in a database.

Helps reduce: Redundancy, inconsistency, security,

Question 6

What do SQL (Structured query language) /Form/Report/Query/App Multi-users do?

Answer 6

Retrieve/store/modify/delete data

Question 7

Normalization - 1st form

Answer 7

1. It should only have single(atomic) valued attributes/columns.
2. Values stored in a column should be of the same domain
3. All the columns in a table should have unique names.
4. Order in which data is stored, does not matter.

Question 8

Normalization - 2nd Form

Answer 8

• Deals with data redundancy in vertical columns
• Should be no partial dependency (where an attribute in a table depends on only a part of the primary key and not the whole key)

Question 9

Normalization - 3rd Form

Answer 9

• Very Uncommon
• Looks for data in tables that are not fully dependent on primary keys
• Transitive Dependency (

Question 10

What are the types of relationships?

Answer 10

One - One
One - Many
Many - Many

Question 11

What is MetaData?

Answer 11

• Data that describes data

- Makes databases more useful & easier to use