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

Invention of WWW and E-commerce

Image
  Invention of WWW and E-commerc e Tim Berners-Lee, 41, is the person who invented the World Wide Web. Which means he is the creator of WWW. Tim Berners-Lee has stated that he developed some software to keep track of his “memory” since he said he is neither good at names nor faces. So he created it as a “memory substitute”. For this reason, technology has advanced increasingly. He is the reason that we can look at a photo online and click on it to find out the photographer’s name. ( Wright, R., 1997) Michael Aldrich is the person who created e-commerce. Moreover, 1995 was the year when e-commerce started growing. Furthermore, the internet and the web were the main factors that helped e-commerce grow ( Laudon and Traver., 2013).  Even though e-commerce has become more popular over the last decade, it has been around for over 30 years. Furthermore, the  idea of e-commerce is associated with notions of the internet economy and digital economy. In addition, all these concepts...
Read more

Analyse and compare different examples of product pages

Image
Introduction: In this blog I will be analysing and comparing different product pages from websites. I have also chosen websites that sell clothes since I am creating a similar website.    White Fox boutique: This product page is quite simple. Both the description and image are available and in good quality. And the description is short and simple. Also, you can easily navigate your way through the pages. Furthermore, this website has different categories. In addition, you can see the prices of the products and the different colours that are available. Overall, this is a good product page and very straightforward. ZARA: Although Zara's homepage appears attractive, many people complained that shopping and browsing the website were difficult. First of all, the size of the description is small. Furthermore, it can be a bit challenging to find what you are looking for. Also, it seems to appear that they are cramming several product images in one row. On the other hand, the colours ...
Read more

Essentials features of an e-commerce website

Image
                    What features should I use for my website?                  _______________________________________________________ The sources that I have used to write this blog all agreed that there are some points that developers must do in order to get a number of satisfied customers. For instance , many e-commerce website creators spend an amount of time in these unnecessary and irrelevant features. These include, use of frames , consistency , cohesion , and amount of advertisement   ( Udo, G.J. and Marquis, G.P., 2002.   42 (2), pp.10-16.) .  These four elements might not satisfy customers and have a rather negative affect on your website.  On the other hand, according to   Udo, Godwin J., and Gerald P. Marquis   focusing your attention on the download time can have a noticeable increase in your ranking. It can also be considered the most beneficial an...
Read more