WDIM331 Database Management Concepts

Submitted by wheelercreek on Sat, 11/26/2011 - 9:15am

Resources:

Textbook:  textbook website  (You can pick up digital free copy of chapter 1 there). 
Also on Amazon: Our text on Amazon  - the 6th edition is fine.

These are the slides I go through in class during weeks 1-4

To get the SQL files for the databases go here:

Helpful Articles

Article explaining Left / Right SQL joins 
(because our book only shows inner joins):
http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html

And how to write Left / Right joins in MySQL: 
http://dev.mysql.com/doc/refman/5.6/en/left-join-optimization.html

 

Assignments

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. 

 

Class Resources: 
For Week 2 homework queries.