Link to login to Microsoft to download Office 365 (free with your student login) – https://www.office.com/

Databases:

• Chinook Database for Access (Lab 01)
• Load Data SQL File (for Lab 03)
• Chinook Database for MySQL (MySQL Server Installation Lab)

Agenda:

1. 1. Attendance
   2. Discussion/Lab Overview
      1. Introduction
      2. Syllabus
      3. Teams
      4. Performance Based Assessment
      5. Setup Doc
      6. Intro to Databases
      7. Lab 01 – Tables, Columns, Rows, and Primary Keys

Assignment(s):

• • Complete Lab 01 – Tables, Columns, Rows, and Primary Keys
  • Watch “What are Databases?” (7:39)
  • Start Setup Doc for Database Server Administration

Agenda:

1. 1. Attendance
   2. Discussion/Lab Overview
      1. MySQL Server Installation

Assignment(s):

• • Complete MySQL Server Installation
  • Read “Database Basics: Concepts and Examples for Beginners“
  • Read “Relation Data Model“

Agenda:

1. 1. Attendance
   2. Discussion/Lab Overview
      1. Relationships and Cardinality
         • One to One
         • Many to Many
         • One to Many
      2. Foreign Keys and Relationships
      3. phpMyAdmin

Assignment(s):

• • Watch “Relationships and Cardinality” (11:24)
  • Watch “Foreign Keys and Relationships” (5:31)
  • Complete Lab 02 – Foreign Keys and Relationships
  • Complete Lab 03 – Basic Usage of phpMyAdmin

Supplemental/Optional Learning:

• • “One to One and Many to Many (Advanced)” (9:50)

Agenda:

1. 1. Attendance
   2. Discussion/Lab Overview
      1. Data Types
      2. Normalization
         • Intro to Normalization
         • First Normal Form (1NF)
         • Second Normal Form (2NF)
         • Third Normal Form (3NF)
         • Normalization Summary
      3. Group Presentation on Normal Forms
      4. Database Design
         • Parrots for Pirates
      5. Database Building
         • Parrots for Pirates

Assignment(s):

• • Complete Lab 04 – Parrots for Pirates Database Design
  • Complete Lab 05 – Building Parrots for Pirates