InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Do You Mean By Shipping Address And Billing Address Of Customer ? How Do We Store Them In Db? |
|
Answer» The SHIPPING and billing address of the CUSTOMER are stored in the ADDRESS table. There are two RECORDS in this table - one is for shipping and other is for billing ADDRESSES. The ADDRBOOK_ID is the foreign KEY in the ADDRESS table. The ADDRESSTYPE will be S for shipping , B for billing and SB for both shipping and billing. The shipping and billing address of the customer are stored in the ADDRESS table. There are two records in this table - one is for shipping and other is for billing addresses. The ADDRBOOK_ID is the foreign key in the ADDRESS table. The ADDRESSTYPE will be S for shipping , B for billing and SB for both shipping and billing. |
|