Explain why a database does not have to be on a computer in order to be considered a database.

Q1: Explain why a database does not have to be on a computer in order to be considered a database.

Q2: Describe one way in which relational databases meet Codd's goal of making databases more reflective of real life.

Q3: Write a brief explanation for your fifth-grade cousin describing how relationships are implemented in relational databases using foreign and primary keys. Do not explain how the primary key is chosen.

Q4: You are given the following LOCATION/VEHICLE spreadsheet. Assume each line must have values for all of the information in it. Note: There is no link between this table and any other. There is no alternative way to get any of the information given in this table. 

SPECIAL EQUIPMENT INVENTORY

LOC NAME

LOC ADDR

LOC PHONE

SENIOR OFFICER

Employee ID

EQUIPMENT 

Equipment ID

7thStreet

123 S. 7th St

815-888-8888

August Domel

123

Pike Pole 

P04-01

7thStreet

123 S. 7th St

815-888-8888

August Domel

123

Jaws of Life

J03-99

PerryRoad

34 S. Route 23

815-777-9898

Chris Krupa

333

Pike Poles

P05-33

HawkHigh

12 S. Dresser

815-999-9090

Bridget Mazzio

224

Pike Poles

P04-02

HawkHigh

12 S. Dresser

815-999-9090

Bridget Mazzio

224

Jaws of Life

J01-90

7thStreet

123 S. 7th St

815-888-8888

August Domel

123

Hazard Suit

H00-01

Using this table, choose one anomaly and create/show an example of that anomaly. Write a two sentence explanation as to why this is an example.

Q5: Correct the table definition given in Q4 so the information in it is correctly stored in terms of relational database definitions and so each (if more than one) table is a relation. Using your example above, explain how this design corrects the anomaly you described in Q4.