Entity Relationship Section The LITTLE-PIZZA-PLACE pizzeriawants to develop a system that automates the pizza ordering andreservation process in the restaurant. The restaurant owner DavidLai has provided you with the following requirements for a databasemodel. The restaurant wishes to store details about different typesof pizzas it serves from its menu. For each pizza, a uniqueidentifier is stored along with details about the name, size(Small, Medium or Large), regular price, information about pizzatoppings and the pizza base type. There are four types of pizzabases that the restaurant uses: Thin Crust, Thick Pan, SeasonedBase and Stuffed Base. David also wants to store information aboutthese types of pizza bases in the system. The system should alsostore details about each order in the restaurant whether it is takeaway order, delivery order or customer eating in. We need to storeorder identifier, order date and time and the total price of theorder. If the type of order is delivery, details of the deliveryaddress, contact name and number must be recorded. If the order iscoming from customers eating in, the table number from where theorder is received must be recorded. Table information should alsoinclude its status (reserved or not), location and maximumcapacity. It is obvious that one order can comprise many pizzas butthere must be at least one pizza. For each pizza ordered, Davidalso wants to store the quantity and information about extratoppings on the ordered pizza. Extra toppings can include Bacon,Mushrooms, Extra Cheese, Pepperoni or Olives but this informationis stored as text only and creating a separate list of all extratopping information is not necessary. When a customer rings for atable reservation, a reservation identifier is recorded in thesystem. For a reservation to occur there must be an available tablenumber. For each reservation, following details are also recorded:eat-in date and time, number of customers, contact name and number,and special instructions if any (such as organising a birthdaycake).

a)

i) List 4 or more entities in the in the Pizza example. (5Marks)

II) List and describe 2 Many to Many relationships that willneed an intersecting entity (associative entity) to enable theitems to be correctly identified the relationship of items betweenthe entities. (10 Marks)

iii) List and describe possible sub-entities in the examplePizza problem. (5 marks)

b) A list of relations (equivalent to Finkelstein entitylist).

Produce complete relations for all entities and attributes for aPIZZA ORDER. Show all primary and foreign keys. Include allattributes that are specifically mentioned and all key attributes.You may need to create primary and foreign keys that are notspecifically mentioned. You must use the Finkelstein methodology asper the study book and tutorials.

c) Using DDL (Data Definition Language) statements write theCREATE TABLE that statement that will be used to create a table forthe PIZZA ORDER entity.

Use logical data types for each column for the tableattributes/fields.

Primary key and foreign key constraints must be created asapplicable.