IMPORTANT Get in touch with me if you run into problems you can't solve (eg, something doesn't install correctly)
While this class is not about any particular implementation of an RDBMS, we're going to start with SQLite.
Individual project assignments will not be time-intensive and keeping up with each step is important.
You will be graded on an export of the database and your documentation. These will be turned in during the third week of class, midterm week and finals week.
Keep track of everything you do regarding this project. I don't expect polished Word documents filled with fancy graphs or even complete sentences. However, you should imagine that you're writing the documentation for a team member who needs to replicate your work, understand how you reached a particular design/implementation, and what maintenance was done.
Keep it simple, but thorough. Here's a minimal example.
Jon Q. Hacker. jhacker@mines.edu
download mysql complete http://dev.mysql.com/downloads/mysql/5.0.html
unzip
run installer
"typical" install
"configure now"
"detailed"
"developer"
"multifunctional"
"dss/olap" (but really you'd want oltp in production)
enable tcp/ip -- default port is 3306
utf8 default charset
install as service
include bin in path
specified root password (safely stored somewhere else)
do not enable remote root
MySQL Configuration Wizard should finish successfully.
...