305 Creating and (Web design tools) Refining Tables During the Design
Sunday, November 25th, 2007305 Creating and Refining Tables During the Design Phase Figure 10-29 enforces referential integrity properly, between all primary and foreign keys, for all tables. This stage limited the many-to-many relationships between INSTRUMENT and MUSICIAN, SKILL and MUSICIAN, and GENRE and MUSICIAN. Figure 10-29: Enforcing referential integrity between all primary key and foreign keys. Instrument section_id instrument instrument_id Skill musician_id (FK) skill skill_id Genre parent_id genre genre_id Musician instrument_id (FK) band_id (FK) name phone email musician_id Band genre_id (FK) name members founding_date band_id Discography band_id (FK) cd_name release_date price discography_id Merchandise band_id (FK) type price merchandise_id Show band_id (FK) location address directions phone show_date show_times show_id Advertisement band_id (FK) musician_id (FK) ad_date ad_text phone email requirements advertisement_id
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check mysql web server services.