Background: Sal's Bagel shop is in desperate need of a relational database to manage sales. Sal's head of IT has gone on strike and they need a replacement quick. Can you help? Sure, you can, you are in the IT 3060 Database Il course. Database Requirements: - The bagel shop database needs to track their menu items. Each item will be assigned a menu type such as; bagels, drinks, and spreads (cream cheese, butter and other flavored toppings for the bagels). - They offer a customer loyalty program and need to track their customer information. They offer incentives for frequent customers and a special discount during a customer's birthday month. - Sal wants to be able to pull the following reports: - A menu displaying items and price, sorted by menu item type. - A list of orders that includes the order date, customer, order items, quantity order and total item price. - Total monthly sales for a given date range. - List of customers getting the birthday month discount for a given month. To help you get started, I have provided a list of fields that you will need to include in the database. The 1...n listed next to the column indicates the field will need to be a primary key and be set to have the property identity specification. Menultem, MenultemType, Customer, and Order. Note: This field list gets you started with the main tables and is not a full list of all the tables/fields in the database. Read over the database requirements and determine the relationships between these tables to determine what other tables/fields are required. MenultemID (1..n) Menultem MenultemDescription MenultemPrice MenultemTypelD (1...n) MenultemType CustomerID (1...n) CustomerLast CustomerFirst CustomerBirthMonth OrderlD(1...n) Create an E-R Diagram with a normalized data model. The E-R Diagram must include notation for primary keys, foreign keys and illustrate the proper relationship between relating tables. The diagram should also include the data type for each data field. Print/Export this document to PDF to submit named, 3060Midterm_ERD_[LastName].pdf