My last name is Iredia-Owie So am to do F - J which is Schema 1 and 3. Below is the Narative section 6.4.1.1 Orders Database

narrative file (case study) to be used for completing this assessment. Tasks: Referring to narrative section 6.4.1.1. "Orders Database" in your course's case narrative you will: 1. Utilizing Microsoft VISIO, you are to leverage the content within the prescribed narrative to develop an Entity Relationship Diagram (ERD). Make use of the 'Crow's Foot Database Notation' template available within VISIO. 1.1. You will be constructing the entities [Tables] found within the schemas associated with the first letter of your last name. 1.2. Your ERD must include the following items: - All entities must be shown with their appropriate attributes and attribute values (variable type and length where applicable) - All Primary keys and foreign Keys must be properly marked - Differentiate between standard entities and intersection entities, utilize rounded corners on tables for intersection tables - Specify minimum and maximum cardinalities using crow's foot notation 1.3. Formatting requirements: - Avoid unnecessarily crossing relationship lines between tables - Cardinality must be clearly visible and legible, symbols for cardinality are to be lined up to the exterior of the table - Align tables in a grid-like fashion when possible - Attempt to maintain similar buffer space between tables B.2.1. ORDERS SCHEMA B.2.4. MEMBERSHIP SCHEMA Schema 1 Schema 4 Indexes retail customer orders placed through Customers whom have enrolled in our the online eCommerce site for CBR. This system membership rewards program. Maintains an does not index retail transactions in-store, a index of all current, and former, subscription separate system is leveraged to process in-store members along with basic subscription order transactions due to a different product mix and details. reduced requirements for data collection. B.2.2. PRODUCT SCHEMA B.2.5. ADDRESS SCHEMA Schema 2 Schema 5 Contains all data relevant to product, type, and Address data for customer shipping and product mix currently offered. Out-of-stock payment purposes. Country, and country codes, items will continue to be indexed within this have been indexed to meet planned business dataset unless they are to be discontinued. expansion goals to serve a larger international community for online orders. B.2.3. CUSTOMER SCHEMA Schema 3 Customer data and details, controlled and self-administered by the customer through associated web and app portal interfaces. B.2.6. PAYMENT SCHEMA Schema 6 Contains all financial data for customers, but no customer information. Bifurcation of customer and financial data must be maintained no matter what circumstance(s). c oi o c ORDERS,CUSTOMERORDER.SHIPPINGADDRESSID ORDERS.CUSTOMERORDER.TAX 1 C21. product therodect 4. Orders. ProductSelection ORDERS.PRODUCTSELECTION.PRODUCTID IC 0 D.4.1. Customer.CustomerDetails CI CU su "s