E-R Diagram

E-R Diagram

Entities

• Customer
  • ID int(PK)
  • Name Varchar(999)
  • Email varchar(200)
  • Phone varchar(15)
  • OrderID int (FK)
• Cart
  • CustomerID int (FK)
  • ProductID int (FK)
  • TotalAmount float
  • ProductAvailability varchar(999)
• Order
  • ID int
  • Amount float
  • Type varchar(200)
  • Quantity int
  • Products varchar(5000)
  • ProductID int (FK)
• Product
  • ID int
  • Price float
  • Category varchar(500)
  • Manufacturer varchar(1000)
  • Details varchar(5000)
  • OrderID int (FK)

Relations:-

The post E-R Diagram appeared first on My Assignment Online.

Expert Help With This Assignment — On Your Terms