TABLES
Table Name: TESTPRODUCT
—————————————————–
Column Name Type
—————————————————–
TESTPRODUCT Id Int
TESTPRODUCT Name Varchar
TESTPRODUCT Type Varchar
TUnitPrice Float
TQuantity Varchar
TUnits in stock Int
TUnits on Order Int
—————————————————–
Table Name: TCUSTOMER
————————————————Column Name Type
————————————————
TOrder Number Int
TOrder Date Date
TCustomerName Varchar
TBillAddress Varchar
TShippingAddress Varchar
TPhoneNumber Varchar
TEmail-Id Varchar
TAmount Float
TShipped Status Varchar
——————————————
Table Name: TPRODTABLE
————————————————Column Name Type
————————————————
TProdId Int
TTESTPRODUCTName Varchar
TPrice Float
————————————————
Table Name: TCREDITCARD
————————————————
Column Name Type
————————————————
TCardType Varchar
TCardNumber Varchar
————————————————
DATAFLOW DIAGRAMS
CONTEXT DIAGRAM
FIRST LEVEL DATA FLOW DIAGRAM FOR MARCHANT LOGIN TO ENHANCE STORES
FIRST LEVEL DATA FLOW DIAGRAM FOR MARCHANT LOGIN TO ENHANCE STORES
FIRST LEVEL DATAFLOW DIAGRAM FOR TCUSTOMER PROCESSING ON TESTPRODUCTS
SECOND LEVEL DATA FLOW DIAGRAM
