On the first table, named "members", you will have 5 fields:
- m_id - member id (the id field is important because it may be the only field that is unique to each table entry and also keep track of any record).
- username - user name of the member
- password - password of the member
- email - email of the member
- privilege - members may be the customers or administrator of the eStore.
On the second table, named "products", you will have 3 fields:
- id - product id
- product - name of the product