Week 1: Understanding Data
This week you will explore data and how it is used. You will also install MySQL Workbench which will be used to work with data throughout the semester.
Beginning of Week (try to complete by end of Tuesday)
- Prepare: Understanding Data
- Learning Activity: Data Gathering
This activity takes 3 days to complete and is needed for the Tabular Data assignment due on Saturday.
Middle of Week
- Learning Activity: Data to Decisions
- Setup Activity: Setup MySQL Workbench
- Team Activity: Group Sign-up
End of Week
- Assignment: Tabular Data
- Assignment: Explore MySQL Workbench
- Complete the W01 Prove Quiz in Canvas
- Complete the W0 60-second Status Update in Canvas
Useful Links:
Additional Resources (Optional):
- Read Chapter 8: The Entity Relationship Data Model from the Database Design textbook.
-
Microsoft's Video Course: Database Fundamentals - 02 Relational Concepts
Watch Microsoft's Video Course: Database Fundamentals - 02 Relational Concepts. Use the following timestamps:
- 1:15 to 14:08 Normalization
- 14:08 to 18:08 Referential Integrity
- 21:30 to 22:44 Composite Key
- 22:45 Constraints
- Read Normalization In DBMS from the Beginner's Book.
- Watch Database Design 36 - 1NF (First Normal Form) (06:50 mins, “Database Design 36 - 1NF” Transcript)
- Watch Database Design 37 - 2NF (08:50 mins, “Database Design 37 - 2NF Transcript”)
- Watch Database Design 38 - 3NF (06:19 mins, "Database Design 38 - 3NF" Transcript)
- Start watching 1NF through 6NF at 8:05 for Boyce Codd and continue (10:20 mins, "1NF through 6NF" Transcript)
- Read How to Insert, Update and Delete Data into Tables.
- Read How to Create Dynamic Foreign Key Inserts.
- Watch O'Reilly: Introduction to MySQL. (If you are having trouble seeing the whole video go to the BYU–Idaho Library Page and select 'A-Z library databases', select 'S' and choose 'Safari Books Online'. Search Introduction to MySQL and you'll see the text by Steve Perry.) Do not start a free trial.