What is the minimum age for an individual to purchase dextro…

Questions

Whаt is the minimum аge fоr аn individual tо purchase dextrоmethorphan in Wisconsin WITHOUT a prescription?

Business scenаriо: Glоbаl Artisаn Teas is a premium brand that curates and distributes specialty teas thrоugh a network of tasting lounges and retail locations. The database developed for Global Artisan Teas supports the company’s day-to-day operations and helps track its wide variety of teas, suppliers, and lounge offerings. Business Requirements: Regional Operations: Global Artisan Teas runs several regional hubs, each overseeing a group of lounges in nearby cities or towns. Tea Lounge Information: Each lounge reflects the culture of its location and serves a curated menu of teas. Tea Inventory: The central catalog includes detailed records of all teas available in the lounges, including origin, flavor notes, and pricing. Tea Types: Each tea is categorized by type (e.g., green, black, oolong), region of origin, or unique processing methods. Supplier Records: The company works with artisan tea growers and suppliers worldwide, and their information is maintained in a dedicated table. Customer Favorites: Customers who frequent the lounges can mark certain teas as their favorites. This helps lounges better understand customer preferences. Database: Region (Reg_ID, Reg_Name, Reg_Manager, Reg_Phone, Reg_Address, Reg_Code) Tea_Lounge (Lg_ID, Lg_Name, Lg_Phone, Lg_Website, Reg_ID) Tea_Inventory (Tea_ID, Tea_Name, Tea_Description, Tea_Origin, Tea_Flavor_Profile, Tea_Processing, Tea_Price, Type_ID) Tea_Type (Type_ID, Type_Name, Type_Description) Supplier (Sup_ID, Sup_Name, Sup_Country, Sup_Contact) Customer_Favorites (Fav_ID, Customer_Name, Tea_ID, Lg_ID, Date_Added)   Question 1: For the given business rules, the database provided above does not include one of the tables. Identify the missing table and write a single SQL query to create the missing table. Make sure to include all the required constraints. Use Oracle naming conventions for constraints' names. Do not add new business rules. Explain why this new table is needed.   Question 2: For the database you completed in Question 1 above, write a single complex SQL query that is based on multiple tables and includes ALL of the following: Subquery GROUP BY, WHERE, and HAVING statements One group function One single-row function If you would like to, you can add more table(s) and/or columns to the existing tables. In that case, provide the structure of the new or updated table(s) using the same format as above. If you need to make any assumptions, provide a clear explanation of each assumption.  Explain what the query is intended to do in a complete, coherent sentence without database jargon. Answers that just repeat the question and state that it is “a complex SQL query that is based on multiple tables and includes the following...” will not receive any points. You have to clearly explain what data your query will retrieve from the given database to receive points for the answer.