Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create the flowchart based on ERD Diagram to represent workflow . Give some explanation to make me understand. CUSTOMER PK CUST_ID VARCHAR(45) CUST_FIRSTNAME VARCHAR(45) CUST
Create the flowchart based on ERD Diagram to represent workflow . Give some explanation to make me understand.
CUSTOMER PK CUST_ID VARCHAR(45) CUST_FIRSTNAME VARCHAR(45) CUST LASTNAME VARCHAR(45) CUST PHONENO INT ORDERS PK ORDER_ID INT DATE_ORDER DATE TYPE_OF_CAKE VARCHAR(45) QTY_OF_CAKE INT CUST_EMAIL VARCHAR(45) H -HAS CUST_HOUSENO VARCHAR(45) CUST_STREET VARCHAR(45) CUST_POSTCODE INT CUST_CITY VARCHAR(45) CUST_STATE VARCHAR(45) HAS TYPE_OF_DELIVERY VARCHAR(45) -HAS- DATE_DELIVERY DATE TIME DELIVERY TIMESTAMP (6) COMMENTS VARCHAR(250) FK CUSTOMER_CUST_ID VARCHAR(45) FK PRODUCT_PRODUCT_ID INT H -HAS PRODUCT PK PRODUCT_ID INT PRODUCT_DESC VARCHAR(45) PRODUCT PACKING VARCHAR(45) PRODUCT_PRICE INT PRODUVT_REMARK VARCHAR(45) PRODUCT_TYPE VARCHAR(50) FK COMPANY_COMPANY_ID INT PAYMENT PK PAYMENT_ID INT PAYMENT_DATE DATE AMOUNT INT FK CUSTOMER_CUST_ID VARCHAR(45) FK EMPLOYEE_EMPLOYEE_ID INT COMPANY PK COMPANY_ID INT COMPANY NAME VARCHAR(45) COMPANY ADDRESS VARCHAR(200) COMPANY_EMAIL VARCHAR(45) COMPANY_PHONENO INT HAS d INCHARGE EMPLOYEE PK EMPLOYEE_ID INT EMPLOYEE_FIRSTNAME VARCHAR(45) EMPLOYEE_LASTNAME VARCHAR(45) EMPLOYEE_EMAIL VARCHAR(45) EMPLOYEE PHONENO INT JOB TITTLE VARCHAR(45) FK COMPANY_COMPANY_ID INT H HAS SUPPLIER PK SUPP_ID INT SUPP_FIRSTNAME VARCHAR(45) SUPP_LASTNAME VARCHAR(45) SUPP PHONENO INT SUPP_EMAIL VARCHAR(45) SUPP_DESC VARCHAR(45) SUPP_BUILDINGNO VARCHAR2(10) SUPP STREET VARCHAR(45) SUPP_POSTCODE INT SUPP CITY VARCHAR(45) SUPP_STATE VARCHAR(45) SUPP_TYPE VARCHAR(90) FK COMPANY_COMPANY_ID INT CARD CASH CHEQUE EWALLET PK PK PK PAYMENT_ID INT PAYMENT_ID INT PAYMENT_ID INT FK FK FK PK FK PAYMENT_ID INT PAYMENT DATE DATE PAYMENT DATE DATE PAYMENT_DATE DATE PAYMENT_DATE DATE AMOUNT INT AMOUNT INT AMOUNT INT AMOUNT INT
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started