Hi guys!
I have attached a diagram of my normalised table for Store.
Store
Store Address
Store Contacts
Type of Address
Type of Contacts
Basically what's in my mind when i designed this were:
Is my diagram correct?
Thank you!
Developed @: https://repository.genmymodel.com/jmquilario/PMCC
I have attached a diagram of my normalised table for Store.
Store
Store Address
Store Contacts
Type of Address
Type of Contacts
Basically what's in my mind when i designed this were:
- A store can have many Address
- An Address of a store could have many Types (Office, Bill To, Warehouse)
- Store can have many Contacts
- Contacts can have many ContactNumbers or Landline or Email
- A Contact can be Agent of many Stores
- ..etc
Is my diagram correct?
Thank you!
Developed @: https://repository.genmymodel.com/jmquilario/PMCC