Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following database design consists of only one table: Track the target recipients for each mailing list category. TargetName Address City State ZipCode Project

  

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.

Step by Step Solution

3.44 Rating (141 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

=+3. A specific group of consumers you want to reach

Answered: 1 week ago

Question

When do you use an update query?

Answered: 1 week ago

Question

Why is system availability an advantage in a distributed database?

Answered: 1 week ago

Question

What is a LAN?

Answered: 1 week ago