Thursday, 9 March 2023

Furniture Selling System/Mobile or Cycle Selling System-ERD Diagram


 Customer:-Cid, Cname, Cadd, Mobileno, C_Date

Salesman:-Sid,Sname,Sadd,S_Joiningdate

Model:-Mid,M_Code,M_Name,Price,Mstock,Mdescription,,Manifacturingdate.

Purchase :-Pid,Cid,Sid,M_Code,Qty,Price,P_Date

Bill:-Bid,Cid,Sid,Pid,,B_Date,Total_Amt,Vat,Gst,Tax.