Research about SDLC, discussing it's methodology, benefits and key stages. Comment on activities you have conducted during your website development that correlates with the stages

https://commons.wikimedia.org/wiki/File:SDLC_-_Software_Development_Life_Cycle.jpg

SDLC (Software Development Life Cycle) is a systematic process for planning, creating, testing, deploying, and maintaining software applications or systems. It provides a structured framework for software development projects, ensuring that they are completed on time, within budget, and with the desired functionality and quality. There are various SDLC methodologies, and I'll discuss the most common one, the Waterfall model, along with its benefits and key stages. I'll also provide comments on how website development aligns with these stages.(Admin, 2023)

Methodology: Waterfall Model

The Waterfall model is a traditional and linear approach to SDLC. It consists of a series of well-defined stages, with each stage dependent on the deliverables of the previous one. Here are the key stages:

Requirements Gathering and Analysis:Activity During Website Development: This stage involves understanding the client's requirements, goals, and objectives for the website. It includes discussions, interviews, and surveys to gather necessary information.

System Design:Activity During Website Development: In this stage, the website's architecture, structure, and design are planned. Activities include creating wireframes, sitemaps, and designing the user interface (UI).

Implementation (Coding):Activity During Website Development: Developers write the code for the website based on the design specifications. This includes front-end (HTML, CSS, JavaScript) and back-end (server-side scripting, databases) development.

Testing:Activity During Website Development: The website undergoes various testing phases, such as unit testing, integration testing, and user acceptance testing (UAT). Bugs and issues are identified and fixed.

Deployment:Activity During Website Development: The final, tested website is deployed to a production server or made available to users. This includes setting up hosting, domain configuration, and ensuring a smooth launch.

Maintenance and Support:Activity During Website Development: After the website is live, ongoing maintenance is crucial. This includes addressing user feedback, bug fixes, updates, and enhancements.

Benefits of SDLC:

Structured Approach: SDLC provides a systematic and organized approach to software development, ensuring that all necessary steps are taken.

Improved Collaboration: It fosters collaboration among team members, stakeholders, and clients by defining roles and responsibilities.

Quality Assurance: The testing phases in SDLC help identify and rectify issues early in the development process, resulting in higher software quality.

Transparency: SDLC provides visibility into the project's progress, making it easier to manage timelines and budgets.

Risk Management: It allows for early identification and mitigation of risks, reducing the chances of project failure.

Website Development and SDLC:

During website development, I have conducted activities aligned with SDLC stages:Requirements Gathering: I have interacted with clients to understand their website needs, objectives, and target audience.

Design: I've created wireframes and design mockups to visualize the website's layout and UI.

Coding: I've written HTML, CSS, JavaScript, and server-side code to build website features.

Testing: I've conducted thorough testing to ensure the website functions correctly, including cross-browser testing and responsiveness testing.

Deployment: I've configured web hosting, domain settings, and ensured a smooth website launch.

Maintenance: Ongoing support and maintenance involve regular updates, bug fixes, and adding new features based on user feedback.

Refferences:

Admin. (2023, January 18). The SDLC Process Key phases and Methodologies | Edvantis. Edvantis. https://www.edvantis.com/blog/software-development-process/

The SDLC: phases, popular models, benefits & more. (2022, June 1). Raygun Blog. https://raygun.com/blog/software-development-life-cycle/

Excel, Create charts and graphs to represent your data,

 On This blog we will be discuss about charts and graphs represent my data

As You can see on to screenshot this chart show How is Totale Sale but bottom graphs sho us how much profit we got

MS Excel, create a product database with at least 10 entries

On this blog byusing MS Excel, create a product database with at least 10 entries, with screenshots to document and show your progress.

Product ID column is show product number

Product Name column  show Name of products.

Unit price colums show coast of product to make it.

Sale price colums show us price for How much we sell to client or business

Stock quantity colums show us how many stock we got on stock

Srock Sold column show us how many product of single lane we already sold

Total Cost colums show us how much money been invest for products

Total Sale column show us total sale of products

Profit column show us clear profit without unit price

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

 

On this blog we will be find out what is ERD related terms, including enttities, attributes, cardinalities and relationship.

https://www.gliffy.com/

An Entity-Relationship Diagram (ERD) is a visual representation of the structure and organization of data within a database system. ERDs are commonly used in database design to illustrate how diffrent entities are related to each other and how data is organized.(Peterson, 2023)

Terms related to ERDs:

Entities: are objects, concepts, or things in the real world that are represented in the database. each entity in an ERD is typically shown as a rectangle or a table and corresponds to a table in a relational database. Examples of entities could be "Custumer, Product, Employee or Order"

Attributes: are characteristics or properties of entities. They describe the data that is associated with an entity. Attributes are offten shown as olves or columns inside the entitity rectangle. For example for a Custumer entity, attributes might include Custumer ID Name Email and Phone Number.

Cardinalities: define the relationship between entities and specify how many instances of one entity are related to another entity. Cardinalities are represented using notations like "1" (one) :M"(Many) or "0" (zero)

One-to One (1:1) A single instance of one entity is associated with a single instance of another entity

One-to-Many (1:M) A single instance of entity can be related to multiple instances of another entity.

Many-to-One (M:1) Multiple instances of one entity can be related to a single instance of another entity.

Many-to-Many(M:M) Multiple instances of one entity can be related to multiple instances of another entity.

Relationships: represent how entities are connected or related to each other witin the database. Relationships are typically depicted as lines connecting the entities, and they have names that describe the nature of the relationship, such as "Owns, Works For or Purcharse Fom"

Refferences:

Entity relationship diagram (ERD) (no date) Entity Relationship Diagram (ERD) - What is an ER Diagram? Available at: https://www.smartdraw.com/entity-relationship-diagram/ (Accessed: 06 September 2023).

Peterson, R. (2023). Entity Relationship (ER) Diagram Model with DBMS Example. Guru99. https://www.guru99.com/er-diagram-tutorial-dbms.html