CPSC 356: Database Design

Professor: Ellen L. Walker

Administrative links

• Syllabus

Resources on the Internet

• Textbook site
• Jurassic Software: A Look Back at the Beginnings of Consumer Software (Time Stamps of Scott Cook highlights)
• MySQL home page
• Unified searchable interface to documentation for PHP, MySQL, HTML and more
• Learning PHP, MySQL & JavaScript (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
• 2011 Project Descriptions

Lab Information

Class Notes

• Introduction (ch.1)
• Introduction part 2 (ch. 2)
• Requirements & Specification (ch. 10)
• Entity Relationship Modeling (ch. 12)
• Conceptual Design Methodology (ch. 16)
• Entrepreneur Example: Scott Cook and Intuit
• Entrepreneurship - Creation and Innovation
• Extended ER Diagrams (EER)
• Relational Model (ch. 4)
• Relational Algebra (ch. 5.1)
• Transforming ER to Relational DB
• SQL Data Definition
• SQL Data Manipulation
• Query Processing
• Normalization
• Normal Forms
• Web Technology and DBMS
• PHP Introduction
• PHP Access to MySQL
  • PHP Interface Example
• Security (ch. 20)
• Transactions (ch. 22)
• Recovery (ch. 22)
• Professional, Legal and Ethical Issues (ch. 21)

Homework Assignments

Exams