WDIM331 Database Management Concepts
These are the slides I go through in class during weeks 1-4
To get the SQL files for the databases go here:
Article explaining Left / Right SQL joins
(because our book only shows inner joins):
And how to write Left / Right joins in MySQL:
Week 1: Read Chapter 1 in the book. Do review questions 1,3,4,6,12 and 21. Do all the Premiere Products exercises (except #8).
Week 2: Chapter 2, Do review questions 1-10. Do all the Premiere Products exercises QBE, skip the relational algebra section, and do the Henry Books exercises.
Week 3: Chapter 3, Do all the review questions. Do all the Premiere Products exercises.
Week 4: Chapter 3 (still) Do the Henry Books Case exercises from chapter 3 in MySQL. Work on design wireframes for your final project.
Week 5: Read chapter 4. Complete the Manhattan Physicians Database Assignment
Week 6: Read chapter 5. Build the Manhattan Physicians Database, and populate with sample data. Write 5-6 different queries for the required views.
Week 7: Complete the Small Business Accounting Tool Assignment
Week 8: Build the actual Small Business Accounting database and input sample data. Write the 6-7 different queries for the required views. Work on design wireframes for your final project.
Week 9: Begin Final Project Assignment, database design.