Database Normalization. To infinity and beyond? -

Text after "

In fact how far should you generalize the example given below, and actually the level of generalization that meets this example?

("id" serial, "home_phone" text, "mobile_phone" text, "work_phone" text, "fax_phone" text, "email" text, "line 1" text, "line 2" text , "City_text", "state_id" integer, "pincode" text, "preferred_type" text, "first_name" text, "last_name" text, constraint "contact_info_pkey" primary key ("id"), "contact_info_fk_state_id" OIDs with the foreign key ("state_id") remove any action from the update on the "public states" ("id"), then not the action DEFERRABLE;

It should be noted that each record can only record 0 or 1 house, mobile, work or fax number. Every phone number is fully functionally dependent on my primary key. What do I know about the generalization of the database, I think it meets 5 NEF, but 6 NF fails < Since the phone number definitions (no new phone number type, no multiple home_phone entries, etc.) are set in stone, then for any reason I have a different tracked connection in the phone number divide Want to add (contact_info_id, PHONE_NUMBER, type)?

After the

Because you have defined this system for only 0 or 1 telephones, The system is completing a higher standard level than the more accurate system.

Individually, I will store phone numbers in a separate table with ID number, public ID, type, area code, exchange, suffix and extension. If you need to select all with one of these values, then it will be more difficult to do programmatically in SQL.

In the same way, you have chosen to break the name of the person in the first and the last parts (though ignoring prefix, middle name and suffix). If you can break a column in logical parts, then it can argue that you have not passed the BCNF.

You choose primarily about how far you want to make your table to normalize. To reach the data, for most people, breaking a column like a phone number in over many parts is overworked, but if any of the points above me are useful for your needs, then assume it.

PS. What are line 1 and row 2?