a. Draw a flow chart for the following problem: Ali sells bunches of flowers at the local shopping centre at amount of (registration number*0.5 e.g if reg# is 100 then 100*0.5). One day Ali's boss, Hassan, tells Ali that at any time during the day he (Hassan) will need to know: • how many bunches of flowers have been sold • what was the value of the most expensive bunch sold • what was the value of the least expensive bunch sold • what is the average value of bunches sold

a. Draw a flow chart for the following problem: Ali sells bunches of flowers at the local shopping centre at amount of (registration number0.5 e.g if reg# is 100 then 1000.5). One day Ali's boss, Hassan, tells Ali that at any time during the day he (Hassan) will need to know: • how many bunches of flowers have been sold • what was the value of the most expensive bunch sold • what was the value of the least expensive bunch sold • what is the average value of bunches sold

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

Write a program in C++ to handle the following scenario: Three friends Asif, Shahid and Bashir start the business. Input following from user. Enter amount invested by Asif (user will enter any value) Bashir’s contribution is equal to 250% of Asif’s contribution and Shahid’s contribution is equal to 75% of Bashir’s contribution. Display amount contributed by Bashir and Shahid. After 6 months business earned profit of 50% of total investment. Display the total profit and the amount each sharer will get (i.e. distribute profit as per percentage of their investment).
Consider the following mathematical functions: f(x)=x2−3 g(x,y)=x−f(f(y)) h(x,y,z)=g(x,y)+z (Use Python) Write three functions to Implement f(x), g(x,y), and h(x,y,z). No Docstrings Rquired. Write 3 assert_equal statements to test your functions.
10. Draw a DFA of strings where the 2nd last symbol is a. Σ= {a,b} [You may draw the NFA for this problem if you find it difficult to solve using DFA] Or, Draw a DFA of strings where the 3rd last symbol is 1. = {0,1} [You may draw the NFA for this problem if you find it difficult to solve using DFA]
Problem: This bowling center offers different charges for customer based different categories and special offer packages. You are required to write a C program to manage this 10 lanes of nine-pin bowling center. The following are the charges for each package: Categories/packages student adult Weekday weekend Public holiday School holiday weekday weekend Public holiday Normal hour (10am-6pm) a) the receipt for every game b) Summary of daily transactions by categories c) Summary of monthly avenue report. RM7.00 RM 10.00 RM12.00 RM7.00 2 + free 1 game RM8.00 RM 10.00 RM14.00 Peak hours (7pm-10pm) RM10.00 RM12.00 RM14.00 RM16.00 RM18.00 RM20.00 Shoes rental: RM5.00 Midnight special (10pm-12pm) RM10.00 2+free 1 game RM12.00 2+free 1 game RM14.00 RM14.00 2+free 1 game RM14.00 2+free 1 game RM18.00 Condition: This program is to calculates charges for every games and the monthly income of a bowling center. Your system should be able to calculate and print out: Show program modularity in your…
Problem: Read your name, distance to college, cgpa and allowance. Find new allowance based on the following conditions: If your cgpa is more than 3.5 and distance is more than or equal to 50 You get double the allowance. If your cgpa is more than 3.0 and distance is more than or equal to 50 You get 1.5 times of allowance Otherwise No change is allowance. Print your name, cgpa, distance to college and new allowance.
Define an enumerated data type Month. Write a function that takes a Month someMonth and aninteger n as parameters. Your function must return the month which is n days after someMonth.Note: Assume that all months have 30 days. These functions should be written in c programming.
c++program An insurance agent offers 5 insurance packages to his potential clients; Individual, Couple, Family, Medical and Saving. He would like to record the monthly number of new clients registered for each insurance packages that he offered. He wish to perform the following analysis after a year.1. Find number of clients that registered for a specific package in a specific month.2. Compare performance of 2 or more packages in a month3. Find the most popular packages4. Find the new registrations for the entire yearAdditional note: You may use one or more 1D or 2D array if necessary.
b. Translate the following function definition into clause form: z w = if null w then 1.0 else if head w == 9 then z (tail w) else z (tail w) + 5.0
Problem 5. We wish to write a python expression to find the largest amount of money spent by one person on any single date. We will use the following code: biggie = transactions. groupby (_ _) ['price_paid'] . sum() .max() What should we be pass in as our groupby predicate? Select only one answer. A. 'tdate' B. 'customer' C. ['item', 'tdate'] D. ['customer', 'tdate'] E. ['customer', 'item']
A performance venue hosts many concerts a year. Performers perform several times a year for the concerts. Each concert has one or more performers and has a name and a specified seating arrangement. A concert is held in one (and only one) of several concert halls, each of which has a room number and the number of seats. Each concert generates revenues from the sales of tickets. Assume that the price of the ticket is the same for the same concert, but different prices for different concerts.Identify several attributes and a key field for each entity. Represent this situation of concerts and performers with an E-R diagram
Write collection of production rules to calculate electricity bill as per following rules: •If the units consumed are less than and equal to 300, then the cost is Rs 10/- per unit. •If the units consumed are more than 300 and less than and equal to 500, then the cost is Rs 12/- per unit. •If the units consumed are more than 500 and less than 1000, then the cost is Rs 15/- per unit and surcharge of 15% of bill is added. •If the units consumed are more than 1000, then the cost is Rs 15/- per unit and surcharge of 25% of bill is added. Trace the production rules for the sample execution of the system given below;Write collection of production rules to calculate electricity bill as per following rules: •If the units consumed are less than and equal to 300, then the cost is Rs 10/- per unit. •If the units consumed are more than 300 and less than and equal to 500, then the cost is Rs 12/- per unit. •If the units consumed are more than 500 and less than 1000, then the cost is Rs 15/- per unit…
20. An employee in a company gets special allowance based on employee category. Input his basic salary and category. Calculate and print the special allowance. (Use switch-case) Category Special Allowance M or m 15% of Basic salary T or t 10% of basic salary C or c 7.5% of Basic salary |Any other 3% of basic salary