You have seen several database designs at various stages of development, including BOOK_CLUB and SPOTIFY. You have seen these developed from UNF to 3NF; hopefully, you have been able to get a basic understanding of the process for how we engage a business topic and create a basic database that will support the long-term operations of an application supporting the organization.

You are now ready to further develop your database topic! Previously, in 2.19, you brainstormed the nouns that are associated with your database topic; now you will create a draft ERD in draw.io by taking your conceptual database diagram and going through the normalization process to target 3NF. Once you have completed your updates, you will submit them in Canvas.

To receive maximum points, you need to avoid thecommon mistakes below that early developers make (as outlined in the previous sections):

• PK/FK going in the wrong direction
• Yes/no questions as column headers
• Missed M:M relationships
• Referential loops
• Transitive dependencies