Documentation: Customer database in Excel

This post will document the customer database creation process in excel step by step with other tables in relation with the customer.

1. Creating User table (Customer table)

The image below illustrates the empty user (customer) table in excel spread sheet with six properties id, first name, last name, email, address and phone. In this entity the user id is the primary key and the address is the foreign key from the address table shown below.

The screenshot below illustrates the fully entered data in the user database table.

2. Creating Product table

The second table in relation with customer table is product table which contains five properties they are id, title, description, price, and category id. Product id is the primary key and the category key is the foreign key in this table.

The image below presents how the data is stored in the product table.

3. Order table

This is the third table which stores the order information of users and it has seven properties they are  id, date, quantity, product id, status, payment method, and total amount. Furthermore, order id is the primary key, product id and payment method are the foreign key in this table.

This image below shows how the information are stored in this table in the database.

4. Address table

The forth table is address table which stores the address information of user and it has six properties id, country, county, city, street, and post. In this table address id is the primary key. 

This screenshot below shows the information stored in the address table looks in the database.

5. Payment table

This is payment table which stores the payment method option list and it has only id and title property where id is the unique primary key.

The screenshot below shows how the data are stored in the payment method table ]in the database.

6. Category table

This is category table which stores the categories of the products and it has only id and title fields where id is the primary key.

The screenshot below shows hoe the data are stored in the category table in database.