Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help with the mysql query/statements to create tables in mysql usnig the below ER FoodOrder ordexNumber datetimev1311 tableNumber num. Fax OrderItem consist of orderNumber
Please help with the mysql query/statements to create tables in mysql usnig the below ER
FoodOrder ordexNumber datetimev1311 tableNumber num. Fax OrderItem consist of orderNumber korderi tenNo MenuItemSize isFor dishid Haize price # MenuItem refers to Il dishid diahName Figure Q3a(i) Columns Description orderNumber A string that is exactly 10 characters long. The first is a letter and last character is either A, G, H, L. The characters in between are digits. datetime Visit A date and time where the date cannot be later than the current date, and the time is between 11am to 2.59pm and between Spm to 9.59pm. tableNumber A whole number that is between 1 and 10. numPax A non-negative whole number. orderItem No A whole number dishid An auto-generated value starting with 1 and an increment of 1 size A value that is either small, medium, large, standard price A non-negative decimal value, with default value 9.90 dishName A value that is at most 30 characters long Foreign key constraints Minimum cardinality between FoodOrder and OrderItem is 1:N, M:M with delete and update cascaded. Minimum cardinality between MenuItemSize and OrderItem is 1:N, M:O with delete disallowed and update cascaded. Minimum cardinality between MenuItem and MenuItemSize is 1:N, M:M with delete and update disallowed. Other constraints The combination of datetime Visit, tableNumber and numPax is unique
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