Week 3: Database Design and Creation
This week you will learn how to design a relational database, then create the database on a database server. You will also be introduced to the basic data actions of: Create, Retrieve, Update, and Delete (CRUD)
Beginning of Week (try to complete by end of Tuesday)
- Prepare: Database Design and Creation
Middle of Week
- Learning Activity: Movie Database Design and CRUD
- Team Activity: CRUD in Practice
End of Week
- Assignment: Design and Populate Art Database
- Complete the W03 Prove Quiz in Canvas
- Complete the W03 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.