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

 


Entities:

-Customers

-Product

-Transaction

Attributes:

-Email

-Address

-Username

-Password

-First name

-Last name

-Colour

-Size

-Price

-Description

-Amount

-Payment type

-Payment ID

Relationships:

-Buys

-Goes through

Cardinalities:

-one to many (1:M)

-many to many (M:M)

-one to one (1:1)

Comments

Post a Comment

Popular posts from this blog

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

Image
  Hello, in this blog I will be documenting my progress on creating a customer database. Furthermore, I have used MS Excel to create it. Adding to that, MS Excel is famous for creating wonderful and organised databases and having all the needed tools to create it. My Progress: 1- I started by writing the title of the database. All I had to do is click on one of the cells and start typing. 2- I changed the colour of the text to red.   To do that I clicked on 'Home'. Then I went to the 'Font' section. After that I clicked on the letter 'A' that says font colour when you place the arrow of your mouse on top of it. 3- I then wrote the headers of each category. I also made the text bolder. 4-After that I started inserting all the information that was needed. 5- Finally, I added borders around it to make it look better. And that is the final look.
Read more

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

Image
Entity-Relationship Diagram (ERD): An ERD is a diagram that allows you to notice the entities and how they interconnect with each other. An ERD also has specific shapes, symbols, and arrows to describe the diagram. They are used to understand how a database system is going to be  structured. RED related terms: -Entities: They are considered as objects that can store data about it. In other words, they represent nouns. Also, they are placed into a rectangular on the ERD. There are also weak entities and strong entities. -Attributes: They are used to explain an entity. They can be described using an oval shape in an ERD. In addition, there are multiple types of attributes, such as simple, composite, and derived.  Attributes can involve single values or multi values. -Relationships: They explains how two entities are related to each other. They can be considered a verbs to explain the relationship better. Furthermore, there a types of relationships, such as one to one, ...
Read more

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

Image
  Alt tags: -  Traditionally Alt tag is used on a simple images. Furthermore, Alt tags is an attribute on an <img> or <Figure> tag .  It is also useful as it provides a text alternative for search engines  ( McCall et all,2022). Title tag: - A title tag is an HTML code. Furthermore, the title tag of a web page can be found as title that appears in the search engine result. In addition, the information that is included in a title tag can be seen as a header at the top of the screen. An alt title should be added to every web page. However, the title tag should represent the content of the web page. How Alt tags and title tags improve SEO: - First of all, title tags are necessary as they affect the user experience. Also, they are a perfect place to apply a keyword. Furthermore, placing a good keyword can boost your search ranking. For instance, it is better to keep the keyword short and use some title modifiers (Kinsella, 2021). - Alt tags are important as ...
Read more