The case study of Myntra shopping site aimed to replicate its database for better understanding and functionality of the website. The replication process involved creating a database that could perform various functions, such as new customer registration, password reset for customers who forget their password, searching for products, adding products to a basket, and applying discounts through coupons. To achieve these goals, SQL queries were written for each of the mentioned functions. The query for new registration allowed customers to sign up for an account using either their email address or phone number. The password reset query provided a solution for customers who had forgotten their password, allowing them to reset it easily. The search bar query enabled customers to search for the products they were looking for, while the basket query allowed customers to add products to their basket. Finally, the discount coupon query allowed customers to apply discounts after purchasing a certain amount. In conclusion, the case study was a success as it successfully replicated the database of Myntra, providing a better understanding and functionality of the website. The use of SQL queries allowed the site to perform various functions, making the shopping experience smoother and more efficient for customers.
-
Notifications
You must be signed in to change notification settings - Fork 0
The case study focuses on the replication of the database of Myntra, an online shopping site. The goal was to create a database replication for the site that could perform various functions. SQL queries were written for new registration with either an email or phone number, password reset for customers who forget their password, searching for prod
pratik0502/Enhancing-the-User-Experience-through-Database-Replication-A-Case-Study-of-Myntra-Shopping-Site
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
The case study focuses on the replication of the database of Myntra, an online shopping site. The goal was to create a database replication for the site that could perform various functions. SQL queries were written for new registration with either an email or phone number, password reset for customers who forget their password, searching for prod
Topics
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published