Practical Slip 11 - 2019 Pattern

 C Language:

Q1) Write a C program to accept the cost price and selling price from the user. Find out if the seller has made a profit or loss and display how much profit or loss has been made.

Q2) Accept radius from the user and write a program having menu with the following options and corresponding actions

DBMS:

Q3) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints.

Bill (billno, day, tableno, total)

Menu (dish_no, dish_desc, price)

The relationship between Bill and Menu is Many to Many with quantity as descriptive attribute.

Constraint: Primary key, price should be > 0.

Consider the above tables and execute the following queries:

1. Display the tableno whose dish_desc is “Veg”.

2. Display the special menu of Monday.

Q4) Consider the above tables and execute the following queries:

1. Display receipt which includes bill_no with Dish description, price, quantity and

total amount of each menu.

2. Find total amount collected by hotel on date 09/07/2019.

3. Count number of menus of billno 301.

4. Display menu details having price between 100 and 500.

5. Display the tableno and day whose bill amount is zero.