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.
Hi
I am database manager.
i mastered in management database using oracle, mysql, sqlite, monodb and NoSQL.
I have confidence about this job.
I can start now and can finish perfectly.
please send me message to discuss detail.
Thank you.
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.
PLEASE DO NOT GO THROUGH REVIEWS, I HAVE JUST STARTED FREELANCING
I understand the task that you just described. I will normalize the table and create 4 tables with pk and fk. After that I will create views and indexed and then I will write queries. I am really interested in this project and I would really appreciate if you reward this project to me. I can do it very easily in shortest time.
Thanks
Regards,
Hunain Humail, Database Designer at Galaxia Tech Solutions