Write a program that can be used to determine the tip amount that should be added to a restaurant charge. Allow the user to input the total, before taxes and the tip percentage (15% or 20%). Produce output showing the calculated values including the total amount due for both the 15% and the 20% tips. Tax of 9% should be added to the bill before the tip is determined. Display subtotal showing the amount owed prior to applying the tip, show each tip amount and the totals with each tip amount. Be sure to provide labels for values and the totals with each tip amount. Write appropriate methods for your solution.
Write short notes on Recoverability.
What is scheduling and serializability of schedules?
What is concurrency control in transaction?
Explain briefly about ACID properties.
Write short notes on the following with suitable examples.
a. 4NF b. 5NF
Differentiate 3NF & BCNF
Write short notes on the following with suitable examples.
a. 1NF b. 2NF c. 3NF d. BCNF
Explain briefly about the need of normalization.
You’ve been asked to write a small menu driven inventory management system for a small convenient
store. Your application shall maintain the following information regarding an item.
Item ID – unsigned long
Item name – string
Item cost – float
Quantity - int
Following are the list of administrative functionalities your application shall support:
1.Add new item to the inventory. This function will be used to add a single new item into the inventory management system.
2.Print all item information in the store - This function will be used to display all items in the inventory. When this option is selected system shall print Item ID, Item name, Item cost and quantity.
3.Find item by ID – This function will be used to search item using an ID. If item exist print item information. If not display an error indicating item not found.
Here is a sample menu.
Inventory Management System Menu
1.Add new item
2.Print item list
3.Find item by ID
4.Find item by name
5.Sort by name
6.Quit