QUESTION 1An admission charge for Bandar Orchid Wetlands varies according to the age of the customeras in Figure 1. The system will receive the input for the number of persons for each categoryas in Figure 2. Then, it will calculate and display the total charge (include SST 8%) and thecategory Figure 3. [Assume all items are required. The process is not involving any decision].Category (Age)50 and above13- 497-124-0Charge (RM)30.0035.0025.0015.00Below 4Figure 1: Charges for VisitorsFreeThe Bold items are the input from the user.WELCOME TO BANDAR ORCHID WETLANDSEnter the number of persons for each categoryAge Over 50Age 13 - 50Age 7 - 12Age 4 - 6Age Below 412Figure 2: The InputTotal for Over 50 (1 Fersons): BM 30.00Total for 13 - 50 (2 Persons): RM 70.00Total for 7 - 12 (4 Persons): RM 100.00Total for 4 - 6_(O Persons): RM0.00Total for Below 4 (FREE): RM0.00ITEMSRM200.0012.00TOTAL3ST (6R)SUB-TOTAL =212.00THANK YOU.ENJOY YOUR HOLIDAY!!Figure 3: The OutputQUESTION 2The program will ask the user to enter weight in pounds and height in inches and displays theBody Mass Index (BMI) status. The status for the BMI is shows in the table below. It then willdisplay the weight in kg. height in meter, the BMI and the status of the BMI.[Hint: 1 pound = 0.45359237 kilograms. 1 inch = 0.0254 meters]BMI = weight in kilogram / (height in meter)BMI< 16< 18< 24< 29<352 35Status / MessageYou are seriously underweightYou are underweightYou are normal weightYou are overweightYou are seriously overweightYou are gravely overweightFigure 4: BMI Status

We need to write a program that takes input for all the different-different age groups persons and…

QUE STION 1 An admission charge for Bandar Orchid WetLands varies according to the age of the customer as in Figure 1. The system will receive the input for the number of persons for each category as in Figure 2. Then, it will calculate and display the total charge (include SST 6%) and the category Figure 3. [Assume all items are required. The process is not involving any decision). Category (Age) 50 and above 13-40 7-12 4-0 Charge (RM) 30.00 35.00 25.00 15.00 Below 4 Figure 1: Charges for Visitors Free The Bold items are the input from the user. KELCOME TO BANDAR ORCHID KETLANDS Enter the number of persons for each categozy Age Over 50 Age 13 - 50: 2 Age 7 - 12 Age 4- 6 Age Below 4 Figure 2: The Input Total for Over 50 (1 Fersons): EM 30.00 Total for 13 - 50 (2 Fersons): BM 70.00 Total for 7 - 12 (4 Fersons): RM 100.00 Total for 4 - 6 O Fersons): RM Total for Below 4 (FREE) 0.00 : RM 0.00 ITEMS RM TOTAL 200.00 33T (E 12.00 SUB-TOTAL = 212.00 THANK YOU.ENJOY YOUR HOLIDAY!! Figure 3: The Output

QUE STION 1 An admission charge for Bandar Orchid WetLands varies according to the age of the customer as in Figure 1. The system will receive the input for the number of persons for each category as in Figure 2. Then, it will calculate and display the total charge (include SST 6%) and the category Figure 3. [Assume all items are required. The process is not involving any decision). Category (Age) 50 and above 13-40 7-12 4-0 Charge (RM) 30.00 35.00 25.00 15.00 Below 4 Figure 1: Charges for Visitors Free The Bold items are the input from the user. KELCOME TO BANDAR ORCHID KETLANDS Enter the number of persons for each categozy Age Over 50 Age 13 - 50: 2 Age 7 - 12 Age 4- 6 Age Below 4 Figure 2: The Input Total for Over 50 (1 Fersons): EM 30.00 Total for 13 - 50 (2 Fersons): BM 70.00 Total for 7 - 12 (4 Fersons): RM 100.00 Total for 4 - 6 O Fersons): RM Total for Below 4 (FREE) 0.00 : RM 0.00 ITEMS RM TOTAL 200.00 33T (E 12.00 SUB-TOTAL = 212.00 THANK YOU.ENJOY YOUR HOLIDAY!! Figure 3: The Output

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Create a formula that provides the start date of a project as follows: In cell H4, begin to enter a formula using the INDEX Use the Lookup table (range A2:E23) as the array. For the row_num argument, use the MATCH Use the Project ID (cell H2) as the lookup_value for the MATCH function. Use the ID column (range A2:A23) as the lookup_array for the MATCH function. Specify an exact match (0) for the MATCH function. Use the Start Date column (column 4) as the column_num for the INDEX function.
Define users, giving the three groups of users there are.
Finance do not use excel calculation sreen shot
Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.
Write a stored procedure called sp_apply_discount() that will apply percent discount to books in a subject. The stored procedure takes in 2 parameters, percentDiscount (DECIMAL(8,2)) and subject (VARCHAR(120)). Using these parameters, the stored procedure computes the discount for the book cost and stores it in the FINAL_PRICE field. For example, the following stored procedure call: call sp_apply_discount(0.15, 'Database');would compute 15% percent discount from the book cost in the Database subject category and store it in the FINAL_PRICE column as depicted in this image:
Vacation days are based on status. Using the information in the lower table below, do a lookup in the upper table determine the amount of vacation time earned by each employee. Status Vacation Time Earned Full TIme 10 Part Time 7 Contract 0 Employees Status Vacation TIme Earned John Contract Jane Part Time Al Full TIme
Normalise the data below to third normal form (3NF).
For this portion of the lab design the solution in the following manner: Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures:Starting at -10 through 100 in increments of 10. Thus, the Fahrenheit temperatures will be:-10, 0, 10, 20, 30, 40, 50…and so on.Display the contents of the list.Similarly create tables/lists for the following, starting at 0 through 100 in increments of 10:Miles to kilometersGallons to litersPounds to kilogramsInches to centimetersDisplay the contents of each listSave the program as firstname_lastname_Lab7a.py where you will replace firstname and lastname with your actual first and last name.
use the RUST
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
Customer (CID, CName, Street, City, State, Gender)Agent (AgentID, GName, Position, Salary, Gender, BranchNo)Invoice(InvoiceNo, CID, AgentID, Product, Quantity, Total_amt) List the total number of male agent, average salary and total amount of salary for all Branches with branch no that initial with ‘B1’ (eg. B10, B13…B21).
A social recreation club has a system to keep track of club members, committees and activities. Each club has a registration number and a title. Several members form committee. Members are male and females. Each committee has a name, a unique number and a date, which the committee has formed. The system stores the members' unique identification number, name, address, gender, birth date and club joining date. The club forms committees for different activities. A committee controls and organizes a number of activities, each of which has a unique name, a unique number and description of the event. An event has event ID and description of the event. An activity may consist of several events. Committee publishes many online advertisements about the activities. Advertisement details are ID and a title. Draw the ER diagram to represent the above scenario