Create an ERD for your website database. Identify the entities, attributes, relationships and cardinalities.

-

 

(Designed by fullvector, shorturl.at/FS259 )


In this post, I aim to introduce the Entity-Relationship Diagram (ERD) that I have designed using the tool draw.io. An ERD is a graphical representation of entities and their relationships to each other, and it is an important tool in the development of any database-driven system, such as my e-commerce project. The ERD I have created using draw.io accurately depicts the relationships between entities in my e-commerce project, ensuring its compatibility and functionality.

 

(www.draw.io)


The presented ER diagram showcases a product database of my an e-commerce website, consisting of three entities - Customers, Products, and Orders. The Customers entity has attributes such as first name, last name, primary key, phone number, address, and email. It is then connected to the Products entity via a one-to-many relationship that I have named "purchase". The Products entity, on the other hand, has attributes like primary key, quantity in stock, product name, product image, product price, and product description. Furthermore, it is connected to the Orders entity via a many-to-many relationship, which I have named "products_orders". The Orders entity has attributes including product's foreign key, customer's foreign key, primary key, order date, total price, payment method, delivery address, order status, and quantity of ordered products.


(www.draw.io)


The relationship between the Customers and Products tables is one-to-many because each customer can have many products in their purchase history, but each product can only belong to one customer. On the other hand, the relationship between the Products and Orders tables is many-to-many because each order can contain multiple products, and each product can be included in multiple orders.

Comments

Post a Comment

Popular posts from this blog

Example of different types of E-commerce: including screenshots, description and links.

-
Image
E-commerce encompasses the buying and selling of goods and services through the internet, providing businesses and consumers with greater convenience and accessibility. There are several types of e-commerce, each with its own distinct features and characteristics. Let's take a closer look at some of the most common forms of e-commerce: Business-to-Consumer (B2C) - In this type of e-commerce, businesses offer their products and services directly to consumers. B2C e-commerce websites offer a wide range of items, including electronics, fashion, household goods, and groceries. Examples of B2C e-commerce websites include Amazon, Walmart, and Best Buy (Techopedia, 2012). Business-to-Business (B2B) - This form of e-commerce involves businesses supplying their products and services to other businesses. B2B e-commerce websites often specialize in products and services that cater to the specific needs of businesses. Examples of B2B e-commerce websites ...
Read more

Research what Alt Tags and Title Tags are in HTML, and discuss how they improve SEO for your E-commerce website.

-
Image
(Designed b yvectorjuice,  shorturl.at/axzLP ) Alt tags and title tags are HTML elements that provide important information about the content of an image and a web page, respectively. These tags play a crucial role in improving Search Engine Optimization (SEO) for an e-commerce website. Alt tags, also known as alt attributes or alt descriptions, are added to the HTML code of an image and provide a brief description of the image. For example, if an e-commerce website has an image of a red dress, the alt tag could be written as "red dress for sale." Alt tags help search engines understand the context of an image, making it easier to index and understand its content. Additionally, alt tags also provide valuable information to users who are visually impaired or have slow internet connections and are using screen readers to access the website. In such cases, screen readers will use the alt tag to describe the image to the user. (W3Schools, 2021) ( dulandrzejjs.wixsite.com/photos...
Read more

Documentation of progress in Website Development (Using Wix). Post should cover signification milestones in the development process.

-
Image
  (Designed by vectorjuice, shorturl.at/eyRZ2 ) The project was accomplished utilizing Wix, which functions as both a website builder and editor. This post intends to serve as a comprehensive guide to creating a website using Wix. The initial step in constructing a website is establishing its framework or arrangement. Wix presents three methods for achieving this objective. The first method involves Wix automatically generating a website through answering a series of questions. The second method offers the option of selecting a template that aligns with the intended design, which can then be customized to specific specifications. The third method involves starting from scratch and building the website from the ground up. In my project, I employed the first method and adjusted the site suggested by Wix. This approach allowed me to save time and expedite the creation of the website. Additionally, Wix provides numerous features, such as customizable templates, a drag-and-drop interfac...
Read more