Introduction to Relational Databases

1. Identifying entities, relationships, and keys
2. Entity-Relationship Diagrams (ERDs), Schemas, and Data Dictionaries (DDs)
3. Sidebar: Firefox history is a relational database
4. Normalization (for ease of maintenance and performance)
5. Example: Given a DFD, now create an ERD
6. HoE: Design a relational database (ERD) (Creately, Gliffy, MySQL Workbench)
7. Discussion
8. Action Items (readings, videos and tasks)
9. See also:

• Gliffy
• ERD Tutorial
• Databases and SQL Video
• MySQL Workbench EER Diagram
• ERD Training Video
• UML Data Modeling Video
• DB Designer
• Sqlite Installation
• Firefox History Sqlite DB
• SANS Google Chrome Forensics