Students learn the basics of the planning and design of relational databases and the use of the Structured Query Language (SQL). Students gain hands-on experience in implementing database solutions based on criteria obtained during client-programmer role-playing exercises. Topics of study include information design, data tables and the forming of complex queries as well as implementation planning.
Slides will not be used for all classes. If slides are presented for a class a link to the slides will appear on this page.
An overview of the final project can be found in the slides presented on October 26, 2010.
Links to MySQL GUI software:
Dia DownloadDia is a free software program you can use to draw Entity Relationship Diagrams. You don't need to use Dia but your diagram does need to use the "crow's foot" notation we've used in class. It does not need to be as detailed as the notation in the book. You can download Dia here or from the Dia website.