307 Creating and Refining Tables During the Design (Web hosting billing)
307 Creating and Refining Tables During the Design Phase Figure 10-31 refines the database model with normalization. This is about as far as this database model can be normalized. The INSTRUMENT and GENRE tables could be normalized if the number of layers in the hierarchies of the two tables is known. For the purposes of this example, it is assumed this is not the case. Some fields have been removed from various tables for being inappropriate. For example, the PHONE, EMAIL, and REQUIREMENTS fields have been removed from the ADVERTISEMENT table, assuming they are included in the AD_TEXT field. Some fields have been renamed. Figure 10-31: Refining the database model with normalization. Skill musician_id (FK) skill Musician_Phone musician_id (FK) phone Venue_Phone venue_id (FK) phone Venue_Directions venue_id (FK) directions Venue_Address venue_id (FK) address Musician_Name musician_id (FK) musician Band_Name band_id (FK) band Musician musician_id instrument_id (FK) band_id (FK) Band band_id genre_id (FK) founding_date Instrument instrument_id section_id (FK) instrument Genre genre_id parent_id (FK) genre Venue venue_id venue Type type_id description Advertisement advertisement_id band_id (FK) musician_id (FK) ad_date ad_text Discography discography_id band_id (FK) cd_name release_date price Merchandise merchandise_id type_id (FK) band_id (FK) price Show show_id venue_id (FK) band_id (FK) date time Musician_Email musician_id (FK) email
Searching for affordable and proven webhost to host and run your servlet applications? Go to Linux Web Hosting services and you will find it.