In this first database assignment, you will create a Pet Catalog database which is taken from the textbook PHP amd MySQL for Dummies (51-60). You can access this text in electronic format from the Thompson Library, with a UM-Flint id and LAN password. The design process for this pet catalog is illustrated in these screen captures from the Dummies textbook, pages 51-53 (3 large images so page may take some time to load).
As described in the textbook, the database will be named: PetCatalog.
You may create your MySQL database manually or using the MySQL Database Wizard built directly into the cPanel interface. I have created on large page which includes the help pages from the hostdime server, along with screen captures from their video tutorials. (Note: both of these links open very large files, which may take a long time to fully open. You can access all of this information separately using the tutorials on your profhicks account.)
Add as users of your database the following names:
| User | Password |
| yourself | 363Sp10 |
| profhicks | 363Sp10 |
The database will include three tables named: Pet, PetType and PetColor with field types summarized by the screen capture linked here.
Screen captures of steps taken when I created the PetCatalog database and tables, using my student account at: hickslm.profhicks.com. Follow these steps to create your database.
To verify that you have created this database with tables specified, I want you to create four screen captures from within phpMyAdmin to verify your database and tables exists.
1. Your first screen capture from phpMyAdmin should show the PetCatalog database exists, with the tables specified in the assignment. My example page follows.
2. Select the Pet table and take another screen capture as illustrated below:
3. Select the PetColor table and take another screen capture as illustrated below:
4. Select the PetType table and take another screen capture as illustrated below:
5. Place links to these screen captures on your course home page as I have with my demo home page at: http://aeneuman.profhicks.com/index.php
[top]