Question: 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.

This is the question that asked to create a system. i've been

These are the instructions

struggling on this one and since i'm still new, im stuck and

This is the database that i've done in Xampp

i want to develop it in php. These are the instructions This

This is the database table i've done.

is the database that i've done in Xampp This is the database

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 More

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!