CSE 3330 – Spring 2015

Administrative Info:

• Course Syllabus
• Introductory Slides

Homework Assignments:

• Homework 01 (soln & sql for last set of problems)
• InClass SQL 

Course Project Information:

• Project Handout
• Functional Specification Doc Template
  • Read the details in the first tab on how to “submit” for review
  • Note: For the Initial submission of this document, you need to have the following Tabs filled out completely (this doesn’t mean they can’t change in the future):
    • Cover Sheet
    • System Actors
    • Story Summaries
    • Story Details
    • Data Model (first pass)
    • Data Model Verification
    • Prof Jackson may require a couple additional tabs. Stay tuned for this.
• Mini Collab Homework

Topics and Links:

• The Relational Model & Relational Algebra
• Handout on MySQL
• SQL: one, two, three
• AWS
  • What is Cloud Computing, Overview and The Free Usage Tier
  • EC2 – Elastic Cloud Compute – Overview, Everything you wanted to know about EC2
  • Docs, Docs, and more Docs
• Vagrant
  • Getting Started
  • Info on the Vagrant File
    • Your team should share one Vagrant file (via GitHub).  If you all have different Vagrant files with different settings, you miss the power of using Vagrant to keep things consistent between devs as well as what ends up in the cloud.
    • Now, if you have a db server running mysql and web server running apache and php (or some other server configuration), you may ultimately have different Vagrant files.
  • Check out the Provisioning Docs.  This will give you info about how to add specific software to your base Vagrant box.  The base box you use (hashicorp/precise64 for example) won’t necessarily have all of the software installed that you’ll need or want (mysql for example).  You can use provisioning to get that done automatically.
  • StackOverflow questions tagged with Vagrant; Vagrant Subreddit
  • Where to find base boxes: vagrantbox.es, Hashicorp Vagrant Boxes
  • Info on Deploying on AWS coming soon…
  • When in doubt, read the docs and ask the profs questions 🙂

Database Design and MySQL Online Resources:

• SMU Library has some great electronic resources.  However, it is challenging to provide links because accessing them is different on campus than off campus.  So, I’m going to provide a reference to them.  You’ll have to search at smu.edu/cul to be able to download/access them.
  • Charles Bell. Expert MySQL, 2nd edition.  Apress, 2012.  Available through the SpringerLink collection.
  • Marc Rockhind. Expert PHP and MySQL: Application Design and Development. Apress, 2013. Available through the SpringerLink Collection.
  • Clare Churcher. Beginning Database Design: From Novice to Professional. Apress 2012.  Available through SpringerLink.
  • Peter Lake & Paul Crowther. Concise Guide to Databases: A Practical Introduction. Springer, 2013. Available through SpringerLink

PHP:

• Slides – Set 1, Set 2, Set 3
• Also see the books in the MySQL section above related to PHP.  There are quite a few other free resources (good books, not trash) available through the SMU Central University Library digital offerings.
• Some references to peruse (these are IMHO, not blessed by any organization):
  • PHP Best Practices
• Another Books
  • Adrian W. West. Practical PHP and MySQL Web Site Databases: A Simplified Approach.  Available through SpringerLink.

Relational Database Design:

• The Entity Relationship Model
• The Relational Model (only section 1 of this PDF)
• ER Diagrams
  • Entity-Relationship Model
  • Crow’s Foot Notation
  • Drawing the Entity-Relationship Diagram
• Constraints (the referential integrity constraints stuff)
• Normalization
• Normal Forms
• Too Much Normalization