Skip to main content

Posts

23. Write about your understanding of databases. Explore the database advantages and write about database concepts such as primary and foreign keys

A database is a collection of data that can store a wide range of information, and a database management system is utilised to store, retrieve, and modify this data. Databases are crucial for businesses to facilitate internal operations, maintain customer interactions, administrative records, and specialized data. In today's digital age, databases have become an essential tool for organizations of all sizes. They provide a centralized location for storing and managing data, allowing for easy access and manipulation. With the help of a database management system, businesses can efficiently organize and analyze their data, leading to better decision-making and improved performance  (amazon, 2023) . Moreover, databases can be customised for specific needs of a company. For instance, a retail business may use a database to track customer purchases and preferences, while a healthcare organization may use a database to manage patient records and medical histories  (amazon, 2023) . (Moril
Recent posts

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

A customer database includes lead contact details and additional data such as demographic characteristics, profession-related characteristics, buying behavior, and firmographics for B2B clients  (Zhostka, 2022). It is a must have for any e-commerce website to gain and retain customers including making tracking orders easier. A screenshot below shows a simple customer database for my website.   Finally, the following picture shows the details of my product database advertised within my website. References Zhostka, T. (2022).  What is a Customer Database: Definition, examples, and software | Snov.io . [online] snow.io. Available at: https://snov.io/glossary/customer-database/ [Accessed 16 Mar. 2023]. ‌

21. Research about SDLC, discussing it's methodology, benefits and key stages.

SDLC The Software Development Lifecycle (SDLC) is a process that development teams use to create high-quality software through forward planning. The SDLC is divided into tasks that can be assigned, completed, and measured. It provides a systematic management framework with specific deliverables at every stage of the software development process to help manage changing requirements, technology upgrades, and cross-functional collaboration. Additionally, the benefits of using the software development lifecycle (SDLC) methodology include increased visibility of the development process for all stakeholders, efficient estimation, planning, and scheduling, improved risk management and cost estimation, systematic software delivery, and better customer satisfaction  (Amazon, 2023) . (Lukas, 2017) Most common phases of SDLC include; Plan The planning phase of software development includes tasks such as cost-benefit analysis, scheduling, resource estimation, and allocation. The development team g

20. Analyse and compare different examples of product Pages

We are going to review and compare 2 websites selling energy drinks. Firstly, we have  https://www.lucozade.com/ . The page features a minimal look with a large product image and clear description. The price and quantity are enlarged to gain attention of the user as it is one of the most important part of a e-commerce website. The product page also has a promotion banner with free delivery and another stating reliable delivery and easy returns. (Lucozade, 2023) Secondly, we have  https://www.yourcoca-cola.co.uk/monster-energy-12-x-500ml/  . The page is similar to the previous, however this page contains more information like reviews about the product by customers, subscription and discounts for subscription , recycling banner for packaging and a product overview about the item.   (The Hut.com Ltd, 2023) References   Lucozade (2023).   Lucozade Alert - Original 12 x 500ml» Lucozade . [online] www.lucozade.com. Available at: https://www.lucozade.com/product/lucozade-alert/lucozade-alert-

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

ERD An Entity Relationship Diagram (ERD) is a visual tool used to represent the relationships between different entities within a database or application. It is created during the design phase to structure the database, but can also be used to analyze and improve existing systems. ERDs use symbols to represent entities and their relationships, providing a clear and concise depiction of complex systems. ERDs can help identify issues and optimize database structure, making it an essential skill for database design  (Brumm, 2019) . Entity, Relationship and Attributes make up an Entity Relation Diagram. (Geissinger, 2017) Entity Entities are fundamental components in data storage. They are commonly illustrated as rectangles on an Entity Relationship Diagram (ERD). Entities can be classified as either strong or weak. Strong entities possess their own unique identifier, also known as a primary key, and do not rely on other entities. Conversely, weak entities depend on a strong entity and hav

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

The 4Ps of marketing: Product, Price, Promotion and Place .  Right product with right price and promotion at the right place. Purely Branded (2017) describes 4Ps as; Product The first P in marketing is product, refers to an item or service that meets the desires or needs of consumers. It is important to have in depth understanding of the product and features to market it effectively. Price Depending on the various price points, similar products and brands may need to be positioned differently. Once we have a thorough understanding of the product we are offering, we can begin to determine the pricing. The decisions we make about pricing will have a significant impact on factors such as profit margins, supply and demand, and marketing strategies. Promotion Promotion involves the various methods to distribute information about a product to consumers and make it stand out from the competition. This includes advertising, social media marketing, email marketing, search engine optimization, v

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

Alt tags The alt tag provides alternative details of an image if the image is not viewable. This tag is required for image element in HTML  (w3schools, 2023).  Google's image article mentions alt text as an important feature and plays a great role to identify the content of the image and surrounding text, resulting in higher SEO rankings  (Valk, 2019). We can see the alt tag for left hand thumbnail alt="Rishi Sunak" as an example from BBC website homepage. (Mason, 2023) Title tag The title tag provides a title to a webpage for browsers and search engines which can only be used once in a webpage. We can view the title tag of an article of BBC as an example. (Mason, 2023) References Mason, C. (2023). NI Protocol: UK and EU appear to be on brink of new Brexit deal.  BBC News . [online] 24 Feb. Available at: https://www.bbc.com/news/uk-politics-64765375 [Accessed 25 Feb. 2023]. Valk, J. de (2019).  Image SEO: alt tag and title tag optimization • Yoast . [online] Yoast. Availa