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.
7 freelancers are bidding on average $159 for this job
Dear client. I've read your project description carefully and very interested. Let's discuss over chat and get started. Waiting your reply. Best regards.