Skip to main content

Posts

Showing posts from March, 2023

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

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