Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

These are the instructions

image text in transcribed

This is the database that i've done in Xampp

image text in transcribed

This is the database table i've done.

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Upgrading Oracle Databases Oracle Database New Features

Authors: Charles Kim, Gary Gordhamer, Sean Scott

1st Edition

B0BL12WFP6, 979-8359657501

More Books

Students also viewed these Databases questions

Question

Will his ability to care for himself change after discharge? p-968

Answered: 1 week ago

Question

how would you have done things differently?

Answered: 1 week ago

Question

What were the reasons for your conversion or resistance?

Answered: 1 week ago

Question

How was their resistance overcome?

Answered: 1 week ago