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

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 General Management Questions!