CPSC 356: Database Design

Professor: Ellen L. Walker

Administrative links

• Syllabus

Resources on the Internet

• Textbook site
• MySQL home page
• Unified searchable interface to documentation for PHP, MySQL, HTML and more
• Learning PHP & MySQL (textbook) -- Available through Safari Books online (Start here for off-campus access)
• PHPMyAdmin on our server
• Babson College Rocket Pitch information
• The Collection of Computer Science Bibliographies
• ACM Digital Library

Project Information

• Project Assignment Overview
• Meeting Guidelines
• Acknowledgement

Lab Information

Lab 1 - Due Oct. 3

Class Notes

• Introduction (8/27)
• Introduction part 2 (8/29)
• Requirements & Specification (8/29)
• Entity Relationship Modeling (8/31)
• Conceptual Design Methodology (9/5)
• Zethus Database Experiences (Eric Parker) (9/7)
• Relational Model (9/10)
• Relational Algebra (9/12)
• Extended ER Diagrams (EER) (9/17)
• Transforming ER to Relational DB (9/19)
• SQL Data Definition (9/21)
• SQL Data Manipulation (9/21)
• Query Processing (10/1)
• Normalization (10/3)
• Normal Forms (10/5 and 10/22)
• PHP Introduction (10/15)
• PHP Access to MySQL
  • PHP Interface Example (10/15)
• Security (10/24)
• Transactions (10/26)
• Web Technology and DBMS (10/28)
• Introduction to Entrepreneurship Unit (11/5)
• Entrepreneur Example: Scott Cook and Intuit (11/7)

Homework Assignments

• Project Phase 1 Preliminary: Due Sept 14, 2007
• Chapter 11 Review Problems: Due Sept 10, 2007 (for discussion)
  • 11.10, 11.12
• Project Phase 1 Final: Due Sept 24, 2007 -- Assessment questions -- Submission Checklist
• Project Phase 2 Preliminary: Due Oct 5, 2007
• Chapter 4 and 5 Review Problems: Due Oct 8, 2007 (for discussion)
  • 4.8, 4.12 (Relational Algebra only)
  • 5.9, 5.10, 5.12, 5.14, 5.15, 5.18, 5.19, 5.23, 5.25
• Project Phase 2 Final: Due Oct 15, 2007
• Project Phase 3 Preliminary: Due Nov 2, 2007
• Examination of Scott Cook and Intuit as an example of entrepreneurship Due: Nov 9 (for discussion)
• Project Phase 3 Final Submission: Due Nov 12, 2007

Exams

• Test 1, Wednesday, Oct. 10. -- Covers material through Query Processing: Chapters 1, 2.1-2.5, 3, 4.1, 5, 6.1-6.3, 9, 10, 11, 12.1, 15, 16, 21.1 and 21.3. (As noted in class, the level of depth of the test will be consistent with the slides and class discussions).