How to create an external table for hbase?

Why didn't Microsoft create a separate shipping address table in the northwinds database?

• If you look at the Microsoft Access  Northwinds sample database, you will see that they have customer address in the customer table and shipping address in the orders table. Surely a typical customer would be more likely to ship to the same address many times. Why didn't they create a separate table of shipping addresses and link that to either the customer table or the order table. I am trying to do this, but I can't figure out how to do it and make all the tables and forms work together. Of course it is possible, that they didn't do it this way because it can't /shouldn't be done. Therefore, my question is "should I continue down this road trying to figure out how to make it work, or should I give up and retype the shipping address for every order?"

• Answer:

  They did this because once a customer places an order the delivery address needs to be independent. Imagine, if they were linked then when the customer changed addresses the shipping addresses from previous orders would also be changed, which is not a good practice. A common practice is to copy the customer’s default address to the order address when the client is chosen in an order. A simple example of this could be: Me.CustomerAddress = Me.OrderAddress   Hope this helps.