24. What is an ERD. Define the RED related terms, including entities, attributes, cardinalities and relationships

ERD

An Entity Relationship Diagram (ERD) is a visual tool used to represent the relationships between different entities within a database or application. It is created during the design phase to structure the database, but can also be used to analyze and improve existing systems. ERDs use symbols to represent entities and their relationships, providing a clear and concise depiction of complex systems. ERDs can help identify issues and optimize database structure, making it an essential skill for database design (Brumm, 2019).

Entity, Relationship and Attributes make up an Entity Relation Diagram.

(Geissinger, 2017)

Entity

Entities are fundamental components in data storage. They are commonly illustrated as rectangles on an Entity Relationship Diagram (ERD). Entities can be classified as either strong or weak. Strong entities possess their own unique identifier, also known as a primary key, and do not rely on other entities. Conversely, weak entities depend on a strong entity and have a foreign key associated with it (Brumm, 2019).

Relationship

In database design, relationships between entities are crucial to understanding how data is organised and connected. These relationships are represented in an Entity Relationship Diagram (ERD) and are derived from verbs that describe the interactions between entities. Relationships are visually depicted as lines connecting entities, with labels that provide further information about the nature of the relationship. There are three main types of relationships: one-to-one, one-to-many, and many-to-many (Brumm, 2019).

Attributes

Attributes are essential properties of an entity that describe it and can be represented as an oval or an entry inside an entity. These attributes come in different types, including simple, composite, and derived. Simple attributes cannot be divided into other attributes, while composite attributes can be split into other attributes. Derived attributes, on the other hand, are calculated from other attributes (Brumm, 2019).

Moreover, attributes can be single-value, which is captured once for an entity, or multi-value, which can be captured more than once. For instance, an entity can have multiple phone numbers, making it a multi-value attribute (Brumm, 2019).

References

Brumm, B. (2019). A Guide to the Entity Relationship Diagram (ERD). [online] Database Star. Available at: https://www.databasestar.com/entity-relationship-diagram [Accessed 15 Mar. 2023].

Geissinger, M. (2017). Black Server Racks on a Room. [Online Image] Pexels. Available at: https://www.pexels.com/photo/black-server-racks-on-a-room-325229/ [Accessed 15 Mar. 2023].

‌

Comments

20. Analyse and compare different examples of product Pages

We are going to review and compare 2 websites selling energy drinks. Firstly, we have https://www.lucozade.com/ . The page features a minimal look with a large product image and clear description. The price and quantity are enlarged to gain attention of the user as it is one of the most important part of a e-commerce website. The product page also has a promotion banner with free delivery and another stating reliable delivery and easy returns. (Lucozade, 2023) Secondly, we have https://www.yourcoca-cola.co.uk/monster-energy-12-x-500ml/ . The page is similar to the previous, however this page contains more information like reviews about the product by customers, subscription and discounts for subscription , recycling banner for packaging and a product overview about the item. (The Hut.com Ltd, 2023) References Lucozade (2023). Lucozade Alert - Original 12 x 500ml» Lucozade . [online] www.lucozade.com. Available at: https://www.lucozade.com/product/l...

9. Understanding Meta tags: Definition, Meta tag analysis of a webpage of choice and description of each meta tag

Meta Tags The <meta> tag defines metadata about an HTML document. This metadata is not displayed on the page, but is machine-readable. It is used by browsers to determine how to display content or reload a page, by search engines to identify keywords, and by other web services (w3schools, 2019). Taking an example of a website https://www.boohoo.com/ . We can view the source page and the meta tags of the website. References Boohoo (2023). boohoo | Womens & Mens Clothes | Shop Online Fashion . [online] Boohoo.com. Available at: https://www.boohoo.com [Accessed 2 Feb. 2023]. w3schools (2019). HTML meta tag . [online] W3schools.com. Available at: https://www.w3schools.com/tags/tag_meta.asp [Accessed 2 Feb. 2023]. ‌

17. Document the process of creating/editing your Wix website contact form, justifyimg your thought process and decision making

Effective customer communication is essential for businesses to succeed, yet many face obstacles when attempting to implement it. A common issue is failing to solicit customer feedback, which makes it difficult to identify areas for improvement. Additionally, businesses often lack a clear way for customers to contact them. Creating a website with a contact us page and form can help address these issues. Contact forms can help businesses acquire leads, close sales, and provide excellent customer service (Strehlow, 2020). The above resulting screenshot included the essentials to contact the business in a simple layout. The page is separated into sections and includes the business logo for a welcoming feel. A contact form is provided for the customer to fill. References Strehlow, R.N. (2020). Effective Contact Form Design: Templates and Examples . [online] Wix Blog. Available at: https://www.wix.com/blog/2020/09/contact-form-design/ [Accessed 21 Feb. 2023]. ‌

ecommerce module

Search This Blog