Using MS Excel, create a customer database with at least 10 entries, with screenshots to document and show progress

This post will detail the step-by-step setup of an Excel customer database along with other tables related to the client.

1. Creating User table (Customer table)

The image below shows an empty user (customer) database with the six properties id, first name, last name, email, address, and phone in an Excel spread sheet. The user id serves as the entity's main key, and the address from the address table below serves as the foreign key.

The user database table's fully inserted data is seen in the screenshot below.

2. Creating Product table

The product table, which is the second table in relation to the customer table, has five properties: an id, a title, a description, a price, and a category id. In this table, the primary key is the product id, and the foreign key is the category key.

How the data is kept in the product table is shown in the figure below.

3. Order table

The third table that contains user order data has seven properties: id, date, quantity, product id, status, payment method, and total amount. In this table, the order id is the primary key, the product id is the foreign key, and the payment method is the foreign key.

The image below demonstrates how data is kept in this database table.

 21

4. Address table

The user's address information is stored in the fourth table, which includes six properties: ID, nation, county, city, street, and post. Address id serves as the table's main key.

The screenshot below demonstrates how the database's address table's data is displayed.

5. Payment table

This payment table, where the payment method choice list is stored, simply has the properties id and title, with id serving as the singular primary key.

The values are recorded in the database's payment method table according to the screenshot below.

6. Category table

There are only two fields in this category table—id, which serves as the primary key—and title, which contains the categories of the products.

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