0 Replies - 697 Views - Last Post: 23 April 2012 - 07:21 PM Rate Topic: -----

#1 rethc  Icon User is offline

  • D.I.C Head

Reputation: 12
  • View blog
  • Posts: 76
  • Joined: 23-April 12

Two Order Types ERD

Posted 23 April 2012 - 07:21 PM

Hi, im new to database design and im trying creating an ERD for a pharmacy that sells products online and also accepts repeat prescriptions orders to customers.

Here is my ERD:
Posted Image

I'm wondering how i could only make use of only 1 payment and card details entity for both orders. Would i be able to make a relationship between the ORDER TYPE entity and payment/card details entity.

Any help would be appreciated. thanks

Is This A Good Question/Topic? 0
  • +

Page 1 of 1