Posts

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

Image
 I created this diagram using DRAW.IO. The entities include ORDER, PRODUCT with their attributes marked inside the cardinality ratios that are also marked using the figure that was showed and I also used the diamond to show the relationships between the entities.

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

Image
  Definition of an ERD  Entity Relationship Diagram, or ER Diagram for short, is a diagram that shows the connections between entity groups that are kept in databases. To put it another way, ER diagrams assist in describing the rational organization of databases. Three fundamental ideas are used to make ER diagrams: things, characteristics, and connections (Peterson, 2022) RED related terms: ENTITY: An entity, which stores data in the database, can be a location, person, object, event, or concept. Entity characteristics must have a property and a distinctive key. Each "attribute" that makes up an entity serves to symbolize it. ATTRIBUTE: It is either a single-valued entity or relationship type attribute. RELATIONSHIP: The definition of a relationship is simply the association of two or more things. Tom, for instance, works in the Chemistry division. CARDINALITY: The definition of the word "cardinality" differs marginally in the context of databases, though. Cardinal...

Write about understanding of database. Explore the database Advantages and write about database concepts such as primary and foreign keys

Image
A database is a collection of data that has been organized to make it simple to handle and update. A collection of data records or files, such as sales transactions, customer information, financial data, and product information, are usually kept in computer databases (Lutkevich, 2023) Definition of database from what I think: A database is an organized collection of data and information that are stored. Advantages of Database:    1Improves staff productivity and data sharing. 2. No duplicate material 3. Increases the data's protection and privacy. 4. Presents the overall view. 5. Improves your capacity to boost earnings. 6. Assures data integrity 7. Dependable storage and restoration 8. Makes your marketing more effective generally and guarantees better customer service.  (Valcheva, 2020) Database concepts: Primary Key: A table's primary key is used to uniquely identify each entry. (Gallagher, 2022) Foreign key: A foreign key connects records between two tables ...

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

Image
 Hello, in this blog I would want to show my progress on database and the screenshots. moreover, I used MS Excel to create it. My progress: 1. I started by using the title of the database. All I did was to type and write it.  2. And then I changed the color to green. To change the color or to use color I went to HOME first then went to the font section After then I clicked on the LETTER A that indicates the color when you place the arrow of your mouse on top of it.  3. After then I wrote the titles in each category, I also made the texts bigger. 4. After all that I ensured that all the information was there. 5.Finally, I added all border to make it even more presentable and better. this is the final look.  

Research about SDLC,

Image
I'll speak about the SDLC and go over its methodology, advantages, and crucial phases. How do you define the SDLC (software development life cycle) first? Software Development Life Cycle (SDLC) refers to the entire process of creating a software solution, including all phases and steps from ideation to creation, deployment, and maintenance.  (Pathak, 2022) It usually includes seven stages: Requirement analysis Planning or ideation Design Development Testing Deployment Operations and maintenance    Software development teams use the SDLC, or software development life cycle, to plan, create, test, deploy, and maintain software solutions. This cycle enables you to create high-quality software that can satisfy client needs, is finished within budgetary constraints, and meets deadlines. What Is the SDLC Process? The various steps required to develop, implement, and manage a software solution are outlined in the software development life cycle. It aids managers in dividing...

Analyse and compare different examples of product Pages

Image
I'll contrast and evaluate various merchandise page examples. But first, before I give the illustration, I need to clarify what product pages are.  A website's "product page" is a page that provides details about a specific good or service. in the form Here are the examples for:  1. GLAMIRA: 2. TIFFANY & CO: First off, both GLAMIRA and Tiffany & Co. offer high-quality products. Despite their differences, both have sufficient knowledge to allow customers to choose what they want and make purchasing decisions. Reference(s) Women's Jewellery | Jewellery For Her | Warren James  (Accessed: March 11, 2023). Earrings for Women | Tiffany & Co.   (Accessed: March 11, 2023).

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

I'll discuss ALT tags, title tags, how HTML defines them, and how they can help websites' search engine optimization. What do Title tags and ALT tags mean? An HTML feature called an alt tag, also known as an "alt attribute" or "alt description," is added to image tags to give search engines a text alternative. Applying images to alt tags for things like product photos can help an online shop. Additionally, title tags are an HTML tag that labels your website for both people and search engines. It is written as title> under the head> section. Titles are the blue text that appears in SERPs that users click to go to your website. They also show up at the browser's  top. how to improve Seo  for ecommerce website. The usefulness of the information that search engines provide to users depends on a variety of variables. You can create a blog and update any images or videos to achieve this. You can promote your goods, provide more value to your customers, a...

DOCUMENTATION OF CREATING AND EDITING YOUR WIX WEBSITE CONTACT FORM

Image
Contact form: (If they are an issue how will the customers contact you or tell you what the difficult are) payments, shipping's, addresses, email, message. Looking at the customer Form service of other pages of website and check and make your own. 

Screenshots of Website development (Wix website).

Image
 

About pages/Brand stories

Image
 It took some investigation into the about pages of related websites to create the initial "About Us" page. I conducted case studies using the websites PANDORA and Georg Jensen. PANDORA: I found About page in pandora website and the images they used was okay. GEORG JENSEN Reference(s) About (pandoragroup.com) https://pandoragroup.com/about/pandora-in-brief/the-pandora-story https://www.georgjensen.com/en-gb/jewellery/earrings

Discuss the 4Ps of marketing, establishing and focusing on the ones most relevant to your project

I'll be discussing the four pillars of marketing in this post and concentrating on the pillars that apply to my website endeavor the most. Product, price, location, and promotion make up the four PS. To effectively market a good or service, the four Ps are the main factors that must be carefully examined and put into practice. Product, price, location, and promotion make up this list. 1.  Product: Developing a good product or service that meets a major customer need is the first step in developing a successful marketing mix. 2. Place: Place is where and how customers will purchase your goods. Making ensuring your products are accessible when and where customers want them to be is important. 3. Price:  Price is the sum that a client must pay in order to buy your good or service.  The 4Ps' most easily manipulated factor is price. You can alter your price over night and observe a difference in your revenue right away. It can be difficult to set a price for your offering. 4....

Website homepage wireframe: hand sketch and digital

Image
Hand sketch: Digital:

Website research: including type of E-commerce website you plan to develop, 5 similar websites, model and target market.

A B2C e-commerce website for a brand of handcrafted goods and jewelry is the kind of website I intend to create. A catalog of exceptional and high-quality products, complete with in-depth descriptions and pictures, will be available on the website. It will also have tools for managing customer accounts and inventory, as well as a shopping cart function and a checkout procedure. Similar websites: 1.  A marketplace for handcrafted and vintage goods, including jewelry and hobbies, is Etsy.com. 2. Handmadeartists.com is an internet bazaar for handcrafted goods like jewelry and crafts. 3. Artfire.com - An internet store selling jewelry, handmade crafts, and other goods. For more information, visit the website. 5. Handmadebyamazon.com is an Amazon-run online store for handcrafted goods like jewelry and crafts. Consumers searching for one-of-a-kind, fine-quality, handcrafted crafts and jewelry are the website's target market. B2C is the preferred strategy for this e-commerce site. In th...

Types of E-commerce Business

Image
Types of E-commerce An online retailer has a variety of options for how it will run its business, depending on its products, services, and structure. Here are a few of the most well-liked company models. Business to Consumer (B2C): The most common e-commerce strategy is business-to-consumer (B2C). When you purchase something from an internet retailer, for instance, it is described as being "business to consumer" sales. (Zande, 2023)  Business to Business (B2B): In business-to-business (B2B) e-commerce, a company sells a product or service to another company, such as a manufacturer and wholesaler or a wholesaler and a retailer. Business-to-business e-commerce typically includes goods like raw materials, software, or combined goods and isn't targeted at consumers. Through B2B e-commerce, manufacturers can also sell straight to retailers. (Zande, 2023) Business to Government (B2G) Business to government, also referred to as business-to-administration (B2A), is the exchange o...

Website Project Initial Idea

My website project's initial idea is about a n e-commerce website for handmade crafts and jewellery. The website would feature a catalogue of unique and high-quality items, including detailed product descriptions and images.  It would also include a shopping cart feature and a checkout process, as well as customer account management and inventory management tools. The website would feature a catalogue of unique and high-quality items, including detailed product descriptions and images. It would also include a shopping cart feature and a checkout process.

Advantages and Disadvantages of Meta Tags and Ways to Overcome the Disadvantages

Image
  Advantages of meta tags: 1.With some less well-known search engines, it might be an influence. 2. Yahoo might give it a little weight. 3. If you use misspelled words on the website, your page will be more likely to show up in yahoo search results for those misspelled words. Disadvantages of meta tags: 1.By using it, you are divulging to your rivals the precise keywords for which you are optimizing each website. 2. Working on meta keyword tags takes time away from more crucial tasks like optimizing your website for those terms.   . Ways to overcome the disadvantages of meta tags: 1.Avoid overusing keywords. 2. Do not have a long inventory of keyboards. Reference Meta tags and search engine optimization - web hosting talk Available  at: https://www.webhostingtalk.com/blog/meta-tags-and-search-engine-optimization/ (Accessed: January 25, 2023). 

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

Image
Definition of Meta tags? Meta tags are small snippets of text on your website, describing the page content and how the basic page the information would be presented in SERP. (Scrcevic, 1633) Meta Tag Analysis of DMU In this analysis, the title tag "Uber: Sign Up to Ride or Drive on the App" is a clear and concise description of what the webpage is about.  The meta description "Get a ride in minutes. Or become a driver and earn money on your schedule. Uber is finding you better ways to move, work, and succeed" is a compelling summary of the benefits of using the Uber app.  The meta robots tag "index, follow" tells search engines to index the webpage and to follow the links on it. Description of each meta tag: Title Tag The title tag is a small, one-line snippet on your page code, invisible to users and visitors, but a very important factor for Search Engines and your position on them. The Title tag is one of the most important tags for your page SEO, becaus...

What is SEO and How is SEO used?

Image
Definition: Search engine optimization is known as SEO. It is the practice of optimizing your web sites so that they appear highly in Google and other search engine results.  (Rakt, 2022) How is SEO used:  SEO helps people discover your website online by placing it near the top of search engine results. (Eneix, 2022) Reference(s) Rakt, M.van de (2022) What is seo? an explanation for beginners, Yoast. Available at: https://yoast.com/what-is-seo/ (Accessed: March 5, 2023). Eneix, K. (2022) How does seo work? how search engine optimization works with Google, FANNIT. FANNIT. Available at: https://www.fannit.com/seo/how-does-seo-work/ (Accessed: March 5, 2023).

Invention of WWW and E-commerce

Image
History of WWW Online world (WWW), According to the World Wide Web Foundation, a researcher at CERN named Tim Berners-Lee began creating a layer on top of the internet in 1993 to make it simpler to reach. (Opens in new tab).  Berners-Lee's concept was to publish material as pages in the form of a common language called Hypertext Markup Language. (HTML). This ultimately developed into the World Wide Web, which is the global internet platform used by billions of people. According to the World Wide Web Foundation, a researcher at CERN named Tim Berners-Lee began creating a layer on top of the internet in 1993 to make it simpler to reach. (Opens in new tab).  In this initial proposal for the World Wide Web, Berners-Lee described the shortcomings of the then-current system at CERN in allowing scientists access to their information and documentation. Though the internet had been around for a decade, the information had limited accessibility.   In order to transform data sh...

Analyse the homepage for 2 E-commerce websites: including comparisons and features improvement.

Image
VS Comparisons Both Konga.com and Amazon.com's homepages are made to successfully highlight the goods and services the e-commerce websites have to offer. The layout and design of the two homepages are one of their major differences. With a slider showcasing featured goods and a grid structure showing various product categories, the Konga homepage has a more colorful design. With a search bar clearly displayed at the top of the page and a few featured products and categories displayed below, the Amazon homepage has a more simplistic design. The quantity of features and choices presented on the site is another distinction. The layout and design of the two homepages are one of their major differences. With a slider showcasing featured goods and a grid structure showing various product categories, the Konga homepage has a more colorful design. With a search bar clearly displayed at the top of the page and a few featured products and categories displayed below, the Amazon homepage has a...