SQL normalization project

You will design a normalized (E-R) logical database model to store data related to the customer, invoice, and invoice order. Next, you will create four tables with primary and foreign keys that are derived from your E-R model. Once the tables have been built, then you will create views and indexes to protect and fine-tune query performance. You will populate each of the tables with sample data. Finally, you will create both a simple “select-from-where” (sfw) query and a complex join query to produce meaningful reports on individual orders and summaries to determine which products sell the best.