You are required to normalise ,design and implement a database using MySQL RDBMS for online shopping store where customers can buy using their credit/debit cards. Developed database should be able to store different products categories e.g. clothes , electronics etc and customer information, buying and selling history. This scenario is a basic guide, creative imagination and sensible assumptions is encouraged and will be awarded the maximum marks
The proposed system should:
● Store online shopping details in MySQL database (information about customers, products, and buying history)
● Incorporate meaningful data and search capabilities to identify customer details, buying and selling details and any other relevant information which can be helpful to management team.
For this project you are required to develop a suitable database model. Your database must be in the 3rd normal form at a minimum and must not allow data duplications/redundancies. In addition, you must populate your database with data suitable to run complex queries on involving more than one table. Moreover, you must create two appropriate user views and triggers to help automate regular tasks and manage user views.