The following database design consists of only one table: Track the target recipients for each mailing...

  

Transcribed Image Text:

The following database design consists of only one table: Track the target recipients for each mailing list category. TargetName Address City State ZipCode Project Requirements: List all fields that violate the first normal form. Redesign the database on paper to meet the following business rules and design requirements. MailingListCategory1 MailingListCategory2 Mailing ListCategory3 Mailing ListCategory4 Mailing List Category5 Business Rules: A target recipient can be on any number of mailing lists. The design should allow any number of mailing list categories. The design should allow any number of target recipients. Design Requirements: Values for target recipient names, addresses and mailing list category names should be entered only once into the database. Provide names to fields and tables based on recommended naming conventions. The design must be in first normal form. Specify the primary key fields in each table by placing an asterisk beside the fields. Draw a line between the fields of each table to show the relationships between each table. This line should be pointed directly to the fields in each table that are used to form the relationship. Specify which table is on the one side of the relationship by placing a one next to the field where the line starts. Specify which table is on the many side of the relationship by placing a crow's feet symbol next to the field where the line ends. The following database design consists of only one table: Track the target recipients for each mailing list category. TargetName Address City State ZipCode Project Requirements: List all fields that violate the first normal form. Redesign the database on paper to meet the following business rules and design requirements. MailingListCategory1 MailingListCategory2 Mailing ListCategory3 Mailing ListCategory4 Mailing List Category5 Business Rules: A target recipient can be on any number of mailing lists. The design should allow any number of mailing list categories. The design should allow any number of target recipients. Design Requirements: Values for target recipient names, addresses and mailing list category names should be entered only once into the database. Provide names to fields and tables based on recommended naming conventions. The design must be in first normal form. Specify the primary key fields in each table by placing an asterisk beside the fields. Draw a line between the fields of each table to show the relationships between each table. This line should be pointed directly to the fields in each table that are used to form the relationship. Specify which table is on the one side of the relationship by placing a one next to the field where the line starts. Specify which table is on the many side of the relationship by placing a crow's feet symbol next to the field where the line ends.