Question: Create a database schema in MySql for the following requirements: The end user must be able to: 1. Sign into the application to maintain a
Create a database schema in MySql for the following requirements:
The end user must be able to:
1. Sign into the application to maintain a record of activities
2. Search for food items based on the search keyword
3. Apply filters and sort results based on different cuisines to get the best deals
4. Add all the selected food items to a cart and customize the purchase at the end
5. Perform a seamless payment process
6. Get an order summary page once the payment is complete
for example here, we would have a users table to keep track of the users when they sign into the website, a food_item table that has our food details like name ,price, and etc..etc for the other tables.
Step by Step Solution
There are 3 Steps involved in it
Certainly Based on the given requirements we can design a simplified MySQL database schema with the following tables 1 Users Table Fields userid Prima... View full answer
Get step-by-step solutions from verified subject matter experts
