This paper circulates around the core theme of 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. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Scenario:
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.