Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is the question that asked to create a system. i've been struggling on this one and since i'm still new, im stuck and i
This is the question that asked to create a system. i've been struggling on this one and since i'm still new, im stuck and i want to develop it in php.
These are the instructions
This is the database that i've done in Xampp
This is the database table i've done.
Web-based Database Application Development Mama's Caf wishes to develop a simple web-based database application to manage their menu. They hired you as a database application developer. Using JSP and Oracle database, develop a web-based database application. The main functions for the Menu Management Application are to List, Add, Update and Delete menu. The following is an example of the index.html page. You can design your own View layouts according to your own creativity. Mama's Cafe Menu Management: List Menu Add Menu Update Menu Delete Menu This is an example View of the Menu List when the List Menu button is clicked. Mama's Cafe Menu List Menuld Name Size Price 1 Lasagna Large 12 2 Lasagna Regular 8 3 Pot Pie Large 10 4 Pat Pie Regular 8 5 Red Velvet Large B 6 Red Velvet Regular 5 1. Create a table name MENU with the following detail: Column Name menul mname msize price Data Type Number (auto generated) Varchar2(50) Varchar2(15) Number(2) 2. Insert the following data into MENU table. Menu Name Lasagna Lasagna Pot Pie Pot Pie Red Velvet Red Velvet Size Large Regular Large Regular Large Regular Price 12 8 10 6 8 5 menu200545 New o menu OH Columns HB New Menuld (PRI, int) I mname (varchar) I msize (varchar) price (int) +- Indexes Table structure Relation view # Name Menuld 1 Drop More d C d Attributes Null Default Comments Extra Action No None Change No None Change No None Change 2 Type Collation int(255) varchar(50) utf8mb4_general_ci varchar(15) utf8mb4_general_ci int(2) mname Drop More Drop More 3 msize 4 price No None Change Drop MoreStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started