Web hosting control panel - Denormalizing 2NF The role of 2NF is to
Saturday, September 15th, 2007Denormalizing 2NF The role of 2NF is to separate static data into separate tables, removing repeated static values from transactional tables. Figure 6-11 shows an example of over-application of 2NF. The lower right of the diagram shows an extreme of four tables, created from what is essentially a more-than-adequately normalized COMPANY table at the upper left of the diagram. Figure 6-11: Denormalization of 2NF into a single static table. Listing listing exchange (FK) ticker Classification classification Exchange exchange classification (FK) Company company listing (FK) address phone fax email Company company listing (FK) address phone fax email Listing listing classification exchange ticker Company company address phone fax email classification exchange ticker Company is static datatoo much normalization Insanely over normalized Over normalization 160 Chapter 6
You want to have a cheap webhost for your apache application, then check apache web hosting services.