Assignment ObjectiveTo help students understand the basics of database modeling by designing a simple databasefor a small business.Scenario and BackgroundYou have been hired by a small business, "Beach City Caf$,"$ to organize their customer, order,and product information. Beach City Caf$$ needs a simple database to keep track of theircustomers, the products they offer, and orders placed by customers. Your task is to create abasic database model that could help them manage their data more efficiently.Youve put some time into thinking about it$,$ and youve identified the following informationabout this new database structure:Identified Entities $-$ The key entities for the business will be:o Customerso Products $($i$.$e$.$ items on the menu$)$o OrdersDefined Attributes $-$ For each of the previously identified entities, there is a list of theimportant pieces of information $($i$.$e$.$ the attributes$)$ that should be captured for them:o Customer: Customer ID$,$ Name, Email, Phone Number and Zip Codeo Product: Product ID$,$ Product Name, Price.o Order: Order ID$,$ Date, Customer ID $($that links back to which customerplaced the order$),$ Product ID$($s$)($items included in the order$),$ Quantity.Relationships This defines how the entities are related to one another:o Each customer can place multiple orders.o Each order can include multiple products.o Each product can be part of many orders.Assignment InstructionsBased on the previously provided information, complete the following:$1.$ Draw an Entity$-$Relationship Diagram $($ERD$)($see figure $5-19$ in the textbook$)$ using asimple tool or even hand$-$drawing to sketch a diagram that visually represents:o The entities.o Their attributes.o The relationships between entities.o Use appropriate cardinality of the relationships $($i$.$e$.$ the Crows Foot diagram$)$MIS $302$ Team Assignment Instructions $|$ Instructor: Herzler $|$ Page $3$ of $4$o Use PK to identify Primary Key and FK to describe Foreign Key next to theappropriate attributes in the diagram $($see Figure $5-26$ in the textbook$)$ Remember: Each entity can only have ONE Primary Key but can havemultiple Foreign Keys as needed to link them together. Hint: Its especially relevant in the Order entity$\mathrm{.}2.$ Describe Relationships Using Simple TermsWrite a brief description of the relationships between the entities using basicterminology $($e$.$g$.,$ one$-$to$-$many, many$-$to$-$many$).$ You don't need to use advanceddatabase notation; just explain it in a way that makes sense$\mathrm{.}3.$ SQL Query Scenario: Once you have your database ERD model, imagine it has beencreated in a database management system, and you need to retrieve some information.In this part of the assignment, you will write a simple SQL query statement that searchesfor customer information based on a specific attribute. See p$.171$ in the textbook formore information.In this scenario, Beach City Caf$$ wants to send out promotions to customers who live ina specific zip code area. Write a SQL query that retrieves and displays the Customer ID$,$Name, and Email of customers based on their Zip Code.Assignment Deliverables ER Diagram: A simple diagram showing how the entities relate to each other. Relationship Description: A paragraph describing how the entities interact. A SQL query that returns a list of customers data based on their Zip Code