COM372X—Programming assignment, week 5
(given 2/12 | due 2/20)

Assignment 5: Setting up a database

Purpose To gain familiarity with database design, using the phpMyAdmin interface.

The assignment: Work through the exercise of creating and using the book-o-rama database, as presented in chapters 9 and 10, using the server's phpMyAdmin interface (here). In chapter 9, you will create the database, which has 5 tables. The chapter 9 reading notes (here) will walk you through this. You will log-on (to MySQL through phpMyAdmin) using the 5-letter name that you use for your ftp folder, which is now set as your phpMyAdmin username and password. The reading notes on chapter 9 will walk you through the creation of tables and fields (i.e., columns). With the 5-table database created, carry out the exercises in chapter 10, again using the phpMyAdmin interface.

Grading: This assignment is worth 5 points. Merely complete the two chapters for full credit. You are on your honor for this (although you probably won't be able to go much further in the course without it!).