3.Rose Theater Company  For this assignment you will modify the Rose Theater Company assignment created in chapter 2. Rose Theater company sells tickets to their productions. There are three seating options for purchase at Rose's theater; Orchestra seats, Center Stage seats, and Outer Stage seats. Orchestra seats cost $75 each, Center Stage seats cost $50 each, and Outer Stage seats cost $25 each. The theater company also gives a discount of 5% on tickets to the local theater group members. The user will enter the number of Orchestra, Center State, and/or Outer stage seats the customer wants to purchase along with whether the customer is a member of the local theater group. The program will calculate and display the income from each type of seat sale along with the discount, and total sale. Requirements Must include use of named constants Must include meaningful variable names Must include a main function with a call to the main function. Must include at least one value returning function

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: List the item ID as ITEM_ID and description as ITEM_DESC for all items. The descriptions should…

A: Below is the query to get the desired output:

Q: You need to return all travel data from the TRAVELS table for the CAR_ID which has a plate number…

A: Here, you need to join both the tables with same car_id whose car_plate is BB-883-***

Q: After increasing the monthly rent of each large property by $150 in Task 3, StayWell decides to…

A: Given: After increasing the monthly rent of each large property by $150 in Task 3, StayWell decides…

Q: Task 6: List the item ID and description of each item that is not in category HOR.

A: The above question is solved in step 2 :-

Q: Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on…

A: SQL query to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF…

Q: need the awnsers to the following. Lab 8-2: StayWell Student Accommodation Task 5: Create the…

A: According to our expert answering guidelines, we can answer up to 3 subparts questions at a time,…

Q: Task 21: List the item ID, description, and category of all items that are in the DOG or CAT…

A: The above question is solved in step 2 :-

Q: Make the functions below according to the attached class diagram and GUI program mockup. No The…

A: Actually, java is a object oriented programming language. It is a platform independent.

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

Q: Determine whether the following statement is true or false. To invoke the binary constraints on the…

A: Bin:       A bin is a container or receptacle used to store and organize items. A bin can be made…

Q: The InstantRide received some traffic violation tickets from the government. The Legal team of…

A: LEFT JOIN is a type of join which returns all the contents(rows) from the left table and the…

Q: Create a formula that provides the start date of a project as follows: In cell H4, begin to enter a…

A: Question given:  A excel table is given. This table stores project details. Create a formula using…

Q: Given the following relation that stores details about students'  activities:   StudentID…

A: here have to determine functional dependencies are consistent or not.

Q: Lab 8-1: KimTay Pet Supplies Task 6: Create the GET_INVOICE_DATE procedure to obtain the customer…

A: GET_INVOICE_DATE procedure: CREATE PROCEDURE GET_INVOICE_DATE @INVOICE_NUM nvarchar(10) AS SELECT…

Q: What are the three primary elements of the SELECT statement.

A: SQL, which stands for Structured Query Language, is a widely used programming language for managing…

Q: Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the…

A: Given : Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of…

Q: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing…

A: sql command for the question is given in step 2

Q: Task 3: StayWell is offering a monthly discount for residents who pay their rent on a quarterly…

A: 1: Select the columns OFFICE_NUM, ADDRESS, OWNER_NUM. LAST_NAME, MONTHLY_RENT in the PROPERTY table…

Q: Exercise: Create a statement that will make a copy of the vendors table. The name of the copy should…

A: Statement to copy content of one table into another table in SQL Statement which delete a table in…

Q: For this portion of the lab design the solution in the following manner: Create a table using a…

A: Program Explanation:   Define the function for conversion. Inside the function create the table for…

Q: (1) for each Customer (e.g., customer C), display all other customers who have higher salary than…

A: To display all customers and their corresponding higher salaries use below query,   SELECT c.id,…

Q: Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc.…

A: Hello studentIn SQL querying, crafting precise SELECT statements is crucial to retrieving accurate…

Q: RESIDENT_ID FIRST_NAME SURNAME PROPERTY_ID 1 Albie Oʻ'Ryan 1 Tariq Khan 1 3 Ismail Salib 1 4 Callen…

A: Queries are used in processing to extract data. Computer requests, on the other hand, are submitted…

Q: Query 3: Write a parameter query to display the names of all prospects each member tried to recruit…

A: Here have to determine query for given problem.

Procedures in SQL

A pre-compiled stored procedure is a logical unit made up of one/more SQL statements (SQL stands for Structured Query Language). The database server saves it as an object. An SQL procedure is a collection of SQL statements and logic that is written and saved to accomplish a specified goal. An SQL procedure consists of a name, a parameter list, and a set of Transact-SQL statements. Stored procedures are stored as named objects in SQL Database Server.