Showing posts with label tables. Show all posts
Showing posts with label tables. Show all posts

2007-05-16

phpMyAdmin - Notice on db Rename

this illustrates an xdebug notice which occurred when creating, then renaming a database

 
Posted by Picasa
Rename Database

NOTE: this posted only to provide insight to the phpMyAdmin developers. phpMyAdmin is an excellent, reliable software.

The notice is due to the php.ini settings for error reporting on this user's local system, not due to the phpMyAdmin software.

2007-03-17

DB View : Retail Inventory Mgmt

note the data fields which hold, in this example, an inventory of musical instruments where various colors (or other differences) are listed, vs the second table shown.


i also have a table which holds only each item's respective "Manufacturer" info, so i don't think i want that here-- therefore, i should remove the Manufac. names from the "nickname" (3rd field, top table) and keep it only in the Manufacturer's table.

I wonder: Is this as close as i might come to the 3rd normal form for these data types?...