Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me on 6-3 and 6-12. 6-1. Outdoor Clubs database: Create a PL/SQL anonymous block program unit that sporting club, membership details in the

image text in transcribed

image text in transcribed

Please help me on 6-3 and 6-12.

6-1. Outdoor Clubs database: Create a PL/SQL anonymous block program unit that sporting club, membership details in the form of membership_id, membership display sporting name, last_name, and duration attribute values. For those sporting clubs that, firste any membership, "No Membership Yet" message should be displayed. Save th have anonymous block program unit as a seript file. product name attribute values from the product table, and a status text based on the price attribute value. Save the PL/SQL anonymous block program unit as a script file. The rules the nataonrizing the price status text display are: A partial display of program unit output is shown below: 6-3. Outdoor Clubs database: Create a PL/SQL anonymous block program unit that counts howme products listed in the product table fall within the price range categories shown below. Savetif PL/SQL anonymous block program unit as a script file. The rule for categorizing price ravge The program unit output is as follows: Product Count Price Status 255HighLowMroductCountMriceStatus 6-4. Outdoor Clubs database: Create a PL/SQL anonymous block program unit that displays product_name and price attribute values for those products that have been ordered in qua of more than 3. Save the PL/SQL anonymous block program unit as a script file. 6-5. Outdoor Clubs database: Create a PL/SQL anonymous block program unit that lists the product_name attribute value and a demand status text display. The demand status text is determined by counting the number of times a product has been ordered so far. The del status text display will be either "Low Demand" or "High Demand". Low Demand is displ? the produet has been ordered less than 2 times. High Demand is displayed if the product Clubs database: Create a PL/SQL anonymous block progr il ild 10 or Clubs at atribute values listed in the club_activity table along program unit that displays the (n) sivit) at lubs table that provide the activity. Save the PL/SOL ano count of the clubs in the sporting sipt file. sp sp riving- script file. A partial display of program unit output is shown below: ailiside rountain Club sranson Climbing Club canoeing Cherokee Rafting Club (hite Plains Club (-8. Outdoor Clubs database: Create a PL/SQL anonymous block program unit that displays the first_name and last_name attribute value from the customer table along with a list of club activities for those customers who have club membership. Save the PL/SQL anonymous block program unit as a script file. 6.9. Outdoor Clubs database: Create a PL/SQL anonymous block program unit that displays the customer first_name and last_name attribute values and a customer status text display. The customer status text display is determined by counting the number of times a customer has placed an order so far. The customer status text display will be either "Average Customer" or "Good Customer". Average Customer is displayed if the customer has ordered less than 2 times. Good Customer is displayed if the customer has ordered 2 or more times. Save the PL/SQL anonymous block program unit as a seript file. 6-10. Outdoor Clubs database: Extend problem 6-1 to take care of a business rule to support a promotion where sporting clubs based in Missouri (state MO) want to reduce their club membership amount by $50 to generate club memberships. Save the PL/SQL anonymous block program unit as a seript file. 6-11. Outdoor Clubs database: Extend problem 6-1 to take care of a business rule to encourage memberships in sporting clubs based in Missouri (state MO) by adding a bonus month to their existing and new club memberships

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning ASP.NET 4.5 Databases

Authors: Sandeep Chanda, Damien Foggon

3rd Edition

1430243805, 978-1430243809

More Books

Students also viewed these Databases questions

Question

Complexity of linear search is O ( n ) . Your answer: True False

Answered: 1 week ago

Question

How do Data Types perform data validation?

Answered: 1 week ago

Question

How does Referential Integrity work?

Answered: 1 week ago