Store DB Normalisation for Suggestions (1 Viewer)

jmq

Registered User.
Local time
Today, 02:31
Joined
Oct 4, 2017
Messages
87
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:
  1. A store can have many Address
  2. An Address of a store could have many Types (Office, Bill To, Warehouse)
  3. Store can have many Contacts
  4. Contacts can have many ContactNumbers or Landline or Email
  5. A Contact can be Agent of many Stores
  6. ..etc

Is my diagram correct?

Thank you!

Developed @: https://repository.genmymodel.com/jmquilario/PMCC
 

Attachments

  • Normalized Store DB.PNG
    Normalized Store DB.PNG
    45 KB · Views: 135

jmq

Registered User.
Local time
Today, 02:31
Joined
Oct 4, 2017
Messages
87
May you give me advice for improvements before i start developing the tables..

Thank you.
 

jmq

Registered User.
Local time
Today, 02:31
Joined
Oct 4, 2017
Messages
87
And also a Store could have many Types such as:
  1. Wholesaler
  2. Retailer
  3. Distributor
  4. etc..
 

Users who are viewing this thread

Top Bottom