Website Database ERD illustration
This post presents the ERD illustration of ecommerce website created with the online tool draw.io. The image below shows the entities, attributes, cardinalities, and relationship between them.
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, quan
Comments
Post a Comment