Online shopping site with the member system and real store stock checking system

System Background
- The online shopping site with the member system and real store stock checking system
- When user buy online will earn the points
- User will go to the shop to take the product so no need to store address in “Order”

Database Requirement
- Catalog
- Type
- Product
- Shops (With Address and Location
- Order
- Stock
- User Login (Email / ID card + Password)
…And more