Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create SQL Database and provide the following: 1) Detail user requirements including business rules 2) Detailed system design that includes your final DB proposal with

Create SQL Database and provide the following: 1) Detail user requirements including business rules 2) Detailed system design that includes your final DB proposal with all required tables and fields, entity relationship (ER) diagrams and a sample GUI for the database 3) Detailed code for the implementation of your database showing SQL code to create DB and tables with all necessary keys (Primary & Foreign), code to insert, modify, and delete data into the tables, and a sample SQL code to retrieve data 4) What conversion strategy you intend to adopt in the installation of the DB and how you plan to maintain the new software 5) Database output in Excel File Topic: Japanese Foodies School Reservation Japanese Foodies is one of the premier culinary training schools of Japanese cuisine in Dubai. Customers can make reservations on any Japanese cooking class based on their needs. Different classes are listed on their website with prices for each. class reservation must indicate class date, time, price, cuisine type (Dim Sum, Sushi, Ramen), the chef who will train, and lesson status code (completed, cancelled, in progress). Customers details are saved in the DB, such as the date they became customers, DOB, customer status (beginner, advanced), first and last name, amount of fees outstanding, email address, and phone number. Cooking classes payments are recorded separately indicating payment method (credit card, cash), date and time, and amount paid. please if possible provide a step by step answer with a er and a sql code as well and excel details

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

Hospitality Finance And Accounting Essential Theory And Practice

Authors: Rob Van Ginneken

1st Edition

0429015119, 9780429015113

More Books

Students also viewed these General Management questions