Answered step by step
Verified Expert Solution
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
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