Eseosa's e-commerce blog

  For customers who want an immediate solution or help with a problem, a FAQ page would be much appreciated. As this would contain questions and enquiries mostly asked by other customers.

  With the use of excel, a product analysis has been created. Below is a visual representation of sales and profits made. However, first, a view of the formulas used. The above chart shows the profit generated by these products. It can be noted that "Gameflow Black" has made the most profits, with "L503 Headset" generating the lowest. In this chart, a representation of how much a product was bought in  relation to the profit made, and how much is left.

  (Author's work) With the help of draw.io, an ERD has been created for the website. The website depicts the relation between entities involved in my business. It can be seen that customers are able to purchase many products, and many products can be added to multiple orders.

  What is a database? (Vecteezy, n.d.) An instrument for gathering and arranging information is a database. Databases can include data about people, things, orders, and anything else. In a spreadsheet or word processing application, lists frequently begin as databases. Redundancies and inconsistencies in the data start to show themselves as the list gets longer. Lists of data make it difficult to comprehend what they mean, and there are few options to search for or extract certain subsets of data for analysis. It is a good idea to move the data to a database made by a database management system (DBMS), such as Access, whenever these issues start to arise. A container of items is a digital database. Multiple tables may exist in a single database (Microsoft, 2021). Advantages  A database management system (DBMS) is essentially a set of software tools and applications that can access, analyse, and alter data. By taking into account the proper security measures, it permits access ...

  Customer Database It is important for a business to have a database for their customers, as this can help tailor the marketing efforts to their needs. An essential intangible asset for businesses is a customer data management system. It enhances customer relations, expands marketing and sales initiatives, boosts operational effectiveness, and increases revenue. A customer database is a repository of data that contains lead contact information such first and last names, phone numbers, email addresses (Zhostka, 2022). Below, is an example of a customer database. It was made for the website project, which was created by Microsoft excel. Creating the right fields is vital for any business. This is especially true in the video game market, as taking note of customers preferred genre can help one determine the most popular games, consoles, and items that are in demand. Keeping track of products, and availability in stock is important. Below, is an example of a product databas...

  Definition The Software Development Life Cycle, sometimes known as SDLC, is a method for creating software that is of the best possible quality while being developed at the lowest feasible cost. An organisation may easily develop high-quality software that has been thoroughly tested and is prepared for usage in production thanks to the well-organized phases of the SDLC (Altvater, 2020). Methodology The techniques and procedures used by software development teams to effectively complete the Software Development Life Cycle are known as SDLC Methodologies (SDLC). Below are the most often used methodologies in SDLC. Waterfall model Prototyping model Iterative model Spiral V-shaped model Agile Scrum Kanban Extreme programming Lean DevOps (Trunkett, 2020). Importance It offers a defined framework that specifies tasks and outcomes. It supports project scheduling, estimating, and planning. It facilitates project management and control. It makes all parties engaged in the develo...