Asked • 09/23/19

Give an example of a many-to-many relationship and explain its unsuitability for a relational database.

Designing a database requires both a logical design and a physical design. The logical design models the database from a business perspective. The organization's data model should reflect its key business processes and decision-making requirements. The process of creating small, stable, flexible, and adaptive data structures from complex groups of data when designing a relational database is termed “normalization.” A well-designed relational database will not have many-to-many relationships, and all attributes for a specific entity will only apply to that entity. Give an example of a many-to-many relationship and explain its unsuitability for a relational database.





1 Expert Answer

By:

REGGIE C. answered • 09/23/19

Tutor
New to Wyzant

Experienced Tutor Specializing in IT Systems/Security |MSc.|Cybersec

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.