MenuItemSize FoodOrder orderNumber datetimevisit tableNumber numax consistsof OrderItem ordexNumber orderitemNo # isFor dish Id + size price refers to MenuItem tl diahid di shName Figure Q3a(1) 1) Refer to the description of columns in Table Q3, and implement the tables using the appropriate SQL statements. List the SQL statements in the order that they should be executed size Columns Description order Number 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. datetimeVisit 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 5pm 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 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 datetimeVisit, tableNumber and numPax is unique MenuItemSize FoodOrder orderNumber datetimevisit tableNumber numax consistsof OrderItem ordexNumber orderitemNo # isFor dish Id + size price refers to MenuItem tl diahid di shName Figure Q3a(1) 1) Refer to the description of columns in Table Q3, and implement the tables using the appropriate SQL statements. List the SQL statements in the order that they should be executed size Columns Description order Number 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. datetimeVisit 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 5pm 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 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 datetimeVisit, tableNumber and numPax is unique
