7. Define a class Departmental with …

7. Define a class Departmental with the following specification : private data members Prod_name string (45 charactes) [ Product name] Listprice long Dis_Price long [ Discount Price] Net long [Net Price ] Dis_type char(F or N) [ Discount type] Cal_price() – The store gives a 10% discount on every product it sells. However at the time of festival season the store gives 7% festival discount after 10% regular discount. The discount type can be checked by tracking the discount type. Where ‘F’ means festival and ‘N’ means Non- festival .The Cal_price() will calculate the Discount Price and Net Price on the basis of the following table. Product Name List Price(Rs.) Washing Machine 12000 Colour Television 17000 Refrigerator 18000 OTG 8000 CD Player 4500 public members Constructor to initialize the string elements with “NULL”, numeric elements with 0 and character elements with ‘N’ Accept() - Ask the store manager to enter Product name, list Price and discount type . The function will invoke Cal_price() to calculate Discount Price and Net Price . ShowBill() - To generate the bill to the customer with all the details of his/her purchase along with the bill amount including discount price and net price.

A Railway company uses machines to sell tickets. The machine details and daily sales information are recorded in two tables: Table Name: Machine Table Name: Sales The primary key of the table Machine is Machine_ID. Records in the table Sales are uniquely identified by the fields Machine_ID and Date. (a) Create the tables Machine and Sales. (b) Write a query to find the number of ticket machines in each station. (c) Write a query to find the total ticket income of the station “New Delhi” of each day. (d) Write a query to find the total number of tickets sold by the machine (Machine_ID = 122) till date.

Differentiate between function and argument

Write a python program to count three letter words in a given file

Write a program in python to accept a number and check whether the number is divisible by 3 as well as 5 otherwise decide : (a) Is the number divisible by 3 and not by 5 (b) is the number divisible by 5 and not by 3 (c) is the number neither divisible by 3 or by 5

What are called tokens

Which book do you all follow for cs? How many chapters are there in the syllabus

Write a python program to count threwords in a given file

1.1. In a table in MYSQL database, an attribute A of datatype varchar(20) Nes the value "Keshar The attribute S of datatype char(20) has value "Meenakshi". How many characters are occupied by attribute A and attribute 67 a. 20,6 6.6,20 ८. 9,6 d. 6,9

What is mean by buffering in file handling?

Your school has a document enlisting names of school students who have pass this year and taken admission in further courses. You have to edit the documents with the following changes: a) Find the word ‘utilitarian‘ and replace it with the word ‘pragmatic’ (Take care not to replace the word utilitarianism). b) The word college as it occurs in the text should be capitalize. Replace the word college with the correct capitalization i.e with College throughout the text using the appropriate option.