"1. Requirement Scope:The commercial profit of Gourmet Pizza dis based on the orders made for an item which isplaced by the clients on the desktop of the business store.There are majorly two types of methodsto place an order by the customer.Generally it is by telephone”.Secondary it is by means of “walkin” clientsFor the first case , the clientcalls the business store by means ofa telephone callto makean order fora item .If the clientis making an order for first time, thedesktop employee need to genuine of theclient , the desktop makes a reverse call tothe same number and takes the order. While taking theorder, a new customer record is generated. If the call is not received, then it is reflected as hoax. Thedetails of telephone number along with date, duration of call, start time and end time is recorded intothe database. If the call is genuine, then the telephone is added to new customer record. In the secondary situation, the customer comes into the gourmet pizza and puts anorder for an item along with its size as specified within the menu.Requirement Specification:Gourmet Pizza does business based on basically few components, primarily … orders and clients whomakes the orders.The composite components for Gourmet Pizza are menu item, ingredients, paymentmode, suppliers, hoax call details and lastly but least employee information along with the details ofsalary based on hourly or shift basis.Gourmet Pizza will also store the information of ingredients whichare added to the item of menu.Menu consists of an item details with a selling price tag. Gourmet Pizzaalso keeps track of the inventory stock level of ingredients and also stores supplier’s details from wherethe ingredients are purchased. The following specifications represent the requirements of Gourmet Pizza? Order:It consist of the date on which order is made , order number, number of itemsand quantityof items, price per quantity of item, discount details if any applicable , payment method details inform of bank card , thecustomerdetails who made an order , type of order and statusof theorder.? Cilent :This give the details about the customer like customer id,customer name , customeraddress , customer phone number.? Employee: Gourmet Pizza has two types of employees based on hourly basis and deliverybasis. Gourmet stores the details of an employee such as employee id, first name, last name,address, telephone number, date of joining, tax pin number, salary, type of employee.? Menu: In the menu, Gourmet Pizza maintain a list of items along with the item number, itemname, selling price, size.? Ingredients:The pizza store keeps information of ingredients in form of the ingredient code,name, type, present usage of the ingredients and the minimum level of the ingredients and thecode of the Supplier who supplies it.? Supplier:Gourmet Pizza requires ingredients to make pizza. These ingredients are supplied bysome business man named as suppliers here. Gourmet Pizza stores details of supplier such assupplier code, supplier name, supplier address, ingredients supplied code, quantity ofingredients supplied,total prize.To make the customers happy and increase the sales, Gourmet Pizza started a concept ofdiscount Discount: It holds the value of discount code, scheme name, discount rate, start date, end dateand condition All the customer pay through cards .so the details of the cards are also stored which isassociated along with customer number and order number Pay mode:It holds the details of transaction made through a bank card. It consist ofcardnumber, bank code, customer number, amount.Bank: bank code, bank name, account name, customer name.The calls made by the customers are also recorded with following valuesCall:call date, phone number, start time, end time.Stock level:base level, current value, ingredient id, supplier id2. Transaction rules: A transaction symbolizes a unit of work performed within a database management system (orsimilar system) against a database, and treated in a coherent and reliable way independent ofother transactions. A transaction generally represents any change in database. Transaction ruledeals with ACID properties. The acid properties are atomicity, consistency, isolation anddurability.In case of Gourmet Pizza database, the acid properties are followed as per their respectivedefinition and real time implementation. "