Week 4

 Week 4 (5/21-5/27)

Halfway done already? Time sure flies.

Five things I have learned these four weeks of class:

1. Create an ER (Entity Relationship) diagram in MySQL. I have created them in Lucid before, but never in MySQL, and this is a great feature.

2. How to use simple and complex queries

3. How to use the Binary Search Algorithm in Java for OrderedIndex

4. Storage media: Speed, cost, capacity, and volatility, and the types of media: main and flash memory, and magnetic disk

5. Entities, relationships, and attributes (PK and FK) and database design: conceptual, logical, and physical design

Questions I have about databases:

1. When do we implement dotted lines when creating relationships between entities?

2. How efficient is the Boyce-Codd normal form in large datasets and memory?

3. What are some disadvantages of views?