E-commerce

 

 

ERD Example For my E-Commerce Website Here are the Tables From where the informations are taken from:

Customer Database for my website

the process of creating After I managed to add the necessary functions to the template that I have chosen for my E-Commerce website such as implementing a search bar, adding a live chat icon, adding products, and connecting the database with the website, I was still missing contact information page, the store policy including the shipping and return policies and moreover I was still missing the FAQs and the about us page. So had to add some textual content in those page, the screenshots bellow shows the development stages that my website went through in terms of adding the textual content to the pages mentioned above. v   Home page before: v   Home page after: v   FAQs before: v   FAQs after: v   About us before: v   About us after:

Website Development Documentation As you can see on the bellow screen shoot it is the first version of my website (the template), it is a template for an E-Commerce website for a women clothing and accessories online shop. That initial idea was to provide an online store where the costumer can   find every detail about the product and including some discounts, moreover, there will be a worldwide and local shipping and the after salle service in the help section and other options that make online shopping easier for the costumer. After putted my initial ideas together I had to start editing on the template: adding products, creating a product categories, putting the products database, adding the necessary options to make the website looks professional such as search bare, live chat, contact page, about us page, FAQs page and other important functionalities. And currently the website is still being edited coinciding with the continuation of the course work.

The First Version: The Updated Version:

Understanding ERD (ERD) is the abbreviation if this term entity relationship diagram, also known as an entity relationship model, is a graphical depiction of the relationships that exist between people, things, locations, concepts, or events in an information technology (IT) system. An ERD employs data modelling approaches to assist in the definition of business processes and as the foundation for a relational database (Techtarget, 2022). Here are the difrences between the (ERD): v   Entity: These forms are independent of other entities and are frequently referred to as parent entities since they frequently rely on weak entities. They will also have a primary key that will differentiate each instance of the object (Lucidchart, 2022). v   Relationship : Relationships are relationships formed by or between things (Lucidchart, 2022). v   Attribute: Attributes are qualities of an entity, a many-to-many or one-to-one connection (Lucidchart, 2022). References:...

Understanding Databases A database is a collection of information that has been organised for easy access, administration, and updating. Computer databases are often used to hold aggregations of data records or files including information such as sales transactions, customer data, financials, and product information (Techtarget, 2022). Databases are used to store, manage, and retrieve any type of data. They gather data about people, locations, or objects. That data is collected in one location so that it may be examined and evaluated. Databases are essentially structured collections of information. The databases caries a several positive towards the business of any facility where a database is needed here are some of the advantages of the DB: ·        Reduced data redundancy (Pearlson, G., 2009). ·        Reduced updating errors and increased consistency (Pearlson, G., 2009). ·        Gre...

SDLC (methodology, benefits, and key stages) At the beginning let define what is the SDLC, this is a brief about the main components and methodologies of the SDLC: Software is a sophisticated product that is created and supplied in a number of processes. Every development process begins the same way; software, like all goods, begins with an idea. The concept evolves into a paper and maybe a prototype before reaching the hands of an actual user. Whether it's a text, a graphic, or running software, the product of one phase becomes the input for the next. The development team eventually provides the programme to the client (Adebiyi, J.E, 2020). This process is known as the Software Development Lifecycle (SDLC). Herer are the different Steps of the SDLC process: v   Formation phase: This fundamental, first phase is the birth of an idea for a solution that either improves on an existing one or creates a completely new one. It aids in defining the scope of the project in order to p...

Examples of Product Pages The first product page on the list is the Apple product page, their vibrant colours are pleasing and contrast massively with the simple, usually one block colour product design. They have a simple design and colours. The second on the list which must be mentioned “Amazon” it the perfect example for a product page as their product pages have loads of content, and this clearly works, as the content includes everything you might need to know and answers any objections you might have. The third product page is from Filippo Loreti, which is an E-Commerce website that sells men accessories, and it has a speciality in watch products. Filippo Loreti makes excellent use of space on large desktop screens by placing the imagery on the left, the title, description, and video in the middle, and the price and buy button on the right - effectively a three-column layout at the top, allowing for more content to be displayed higher up the page. The last one on today’s l...

The 4Ps of marketing in my domain of women wear and accessories To successfully sell a product or service, the four Ps must be carefully examined and properly utilised. Neil Borden, an advertising professor at Harvard, popularized the idea of the marketing mix—and the concepts that would later be known primarily as the four Ps—in the 1950s. They are as follows: product, pricing, location, and promotion. More Ps have been recognised since the four Ps were presented in the 1950s (Investopedia, 2022), including people, process, and physical evidence and by that they became the 7Ps rather than the four Ps (MBA Team, 2022). For instance, in my small business of selling women clothing and accessories there must be the 4Ps included in the plan of promoting for the product so that there will be a successful business. Here is an example on my small business: Place refers to where consumers buy your product (Investopedia, 2022), or where they discover it “the online based market” and maybe...

What are Alt Tags and Title Tags in HTML, how they improve SEO for an E-commerce website 1-What are Alt Tags and Title Tags: The first thing that has to be mentioned is that An HTML tag is everything between the < and > brackets and the alt is merely one of a range of attributes that can appear inside a tag, here is an example of an HTML tag <img src=“image.jpg” alt=“image description” title=“image tooltip”> . And now to define the alt property and the title attribute or the title tags are the two primary techniques for adding descriptive textual information to web page components in HTML (Doyle, 2022). While these two characteristics may appear to function similarly, they serve quite different purposes, in brief: v   Use the HTML alt property to supply alternative text for an element that will be displayed if it cannot be displayed (Doyle, 2022). v   When appropriate, use the title property to provide additional text to explain the element in greater depth...