Search & Filtering
SQL Statements to:
a) Find Total sales for a particular date
b) List available items having a given color
c) List available stock of clothes on a particular date with their accompanying including the store with that stock
d) List new stock received on a given date (order by branch)
The following stored procedures are required :
a) Return store details showing purchases done on a given date and the current stock of a given product
b) The system should ensure that during the quality check, if the product has a defect, it should be recorded in the
defect table and an appropriate message should be displayed
One metric ton is approximately 2205 pounds. Write a program that prompts the user to input the amount of rice, in pounds, in a bag. The program outputs the number of bags needed to store one metric ton of rice.
BINARY(ARRAY,LB,UB,ITEM,LOC) which finds the location LOC where ITEM appears in ARRAY
What can seller do to protect themselves from customers who deny that they placed an
order. Explain.
Write a C++ code to read a line of string as an input and do the following operations. Do proper input
validation to your input.
i) Capitalize first and last character of each word in the given string. [3 Marks]
ii) Delete a word from the given string. Popup a message if the string is empty. [5 Marks]
iii) Add a word in the middle of the given string. Capitalize the new word if it already exists. [5 Marks]
For proper input validation
Write a C++ code to read a line of string as an input and do the following operations. Do proper input validation to your input. i) Capitalize first and last character of each word in the given string. [3 Marks] ii) Delete a word from the given string. Popup a message if the string is empty. [5 Marks] iii) Add a word in the middle of the given string. Capitalize the new word if it already exists. [5 Marks] For proper input validation
Write a top-level program for creating a GRAPH instance and running both Prim’s and Kruskal’s algorithms on it, and printing out the respective MSTs returned, along with the total cost and runtime (in milliseconds) for each one. The input to this top-level program 1 should be an n × n cost matrix for a graph, n being the number of vertices (assume the diagonal elements will always be 0, and elements corresponding to unconnected vertices will be set to −1); this can be read in from a text file. A sample input file is provided at http://web.iitd.ac.in/~sumeet/input_graph.txt).
As many of the students like chats, chips, juice and chocolates, a vending machine is kept at several places. The person after putting the cash has to enter the product code so as to get it.
The code is as follows
Code Product
106 Haldiram Ratmali Sev
206 Haldiram Instant Bhel
306 Fuse Chocolate
406 Mixed Fruit Juice
506 Lassi
Depending on the code entered the item will be selected and given to the person who feeds the amount. An application has to be developed so that it automatically works after entering the code.
Peter runs a vehicle rental center. The vehicles are of three types, MICRO, MINI and SUV. The customer who travels in MICRO will pay Rs 15 per kilometer. The customer who travels in MINI will pay Rs 20 per kilometer and the customer who travels in SUV will pay Rs 25 per kilometer.
A software need to be developed to compute the cost of travelling by the customer with following requirements.
a. The distance travelled by customer need to be captured.
b. The type of vehicle to be captured (M for Micro, m for mini, S for SUV).
c. Check the type of vehicle.
d. Compute the final cost of the travel depending on the vehicle.
Display the final cost.
Delhi government has issued a circular to control the pollution due to vehicle. It has prohibited the use of odd numbers registered vehicle on Monday, Wednesday and Friday and not to use even number registered vehicles on Tuesday, Thursday and Saturday. Sunday they have to use public transport so no vehicle should be used.
A software application is to be developed by Delhi Government which will inform the owner of the vehicle on which day they can use the vehicle.
Following are the requirements to solve the problem
a. The registration number of the vehicle should be captured from the owner.
b. Check if the registration number is odd or even.
c. Inform user on which day they can use the vehicle.
