"1. Atomicity:It requires that each transaction be "all or nothing": if one part of thetransaction fails, then the entire transaction fails, and the database state is leftunchanged.Gourmet Pizza: If an order is place by means of the telephone. The authenticity of thecustomer is verified by calling back the same number and taking the order. If none replies,then it is considered as HOAX call which means nothing. If the order is placed by existingcustomer, then order is taken fully.2. Consistency: This property ensures that any transaction will bring the database from onevalid state to another. Any data written to the database must be valid according to alldefined business rules, including constraints, cascades, triggers and any combinationsthereof.Gourmet Pizza: when an order is placed, it should be according to the items and its sizespresent within the menu. A customer can place an order for more than one item. If acustomer deals to follow the certain rules of discount and payments.3. Isolation: This property ensures that the concurrent execution of transactions results in asystem state that would be obtained if transactions were executed sequentially.Gourmet Pizza: If the order has been taken either by phone or walk-in customersimultaneously, the delivery or execution of the order is done in a sequential form so that itdoesn’t create errors in the database.4. Durability:This property ensures that once a transaction has been committed, it will remain so,even in the event of power loss, crashes or errors Gourmet Pizza: if the order is placed by the customer, it need to be delivered at any costand if the order is placed then it’s mandatory that the payment should also be made by thecustomer.There are certain data manipulations on the queries of Gourmet Pizza database.1. Insertion and modification of tables such as update and delete on all the tables relatedto the database should be possible2. It is mandatory that the column of each table which holds the integrity constraint“primary key” property should have a value compulsory.3. All the column values of tables should be viewed based on the queries generated.4. The data should be inserted depending on the conditions of check constraint, on deletecascade and update cascade.5. The values inserted in the column names of each table should be according to its datatype and specified length.3. Business Rule Business Rules are the rules that define your business. A Business Rule is often a constraint or adescription of an operation within your business. A Business Rule must be atomic in other words; it’sbeing able to be either true or false. The most important topic of Business Rules which must underlayany database Schema. These are often implemented as 'Constraints' in the Database.These Business Rules are important because they define the conditions that the Database must meet.? All orders that are generated by a telephone should be verified by making a callback to thecustomer. ? The order of the item should be same as mentioned in the menu.? The discount rules and percentage will not be changed as per customer’s request but aredesigned and decided by the management of Gourmet Pizza.? The payment should be done by means of card.? The customers should be authentic and their address should be valid .? The Deliveries of the ordered item is done by the employees of the Gourmet Pizza.? The ingredients will be same in quantity and quality.? The Suppliers should supply the required ingredients as mentioned in the required format.? The Customer should have alteast one or many ORDERS.? The customer can be associated with only one ADDRESS.? Thedelivery is associated with just one order at a time? An order must be associated with one and only one CUSTOMER.? An order can be associated with one or many items of a menu.? A payment must be associated with one and only one ORDER but with many items.3. Normalize relational schema to BCNF:Normalization: Normalization is a process of organizing the data in database to avoid data redundancy,insertion anomaly, update anomaly & deletion anomaly. Following are the general concept of the tables even though they are related , which comes into exist ifnormalization doesn’t take place. "