An emerging company is embarking on the development of its information system, focusing its core business on online sales of electronic components. Our mission is to design and implement a solution aimed at digitizing some of its operational processes.

For the smooth execution of our solution, it is essential to set up and configure the following components in your development environment :

• Visual Studio Comunity 2010 with CLI : Download
• SQL server 2019 : Download
• SQL server management studio 19 : Download

HCI (Human-Computing Interaction)
    MyForm/Main

Services
    CLstock     CLemployee     CLcustomers     CLorders     CLstats

Components

mother classes
    CLmap     CLAdress

of mapping
    CLmapStock     CLmapEmployee     CLmapCustomers     CLmapOrder     CLmapStats

of connexion
    CLcad

A use case diagram is crucial for understanding our project, simplifying system complexities through visual representation. As a communication tool, it fosters clarity among stakeholders and guides development by defining requirements. Emphasizing concrete scenarios, it anticipates user needs and adapts to changes in the development cycle.

Class diagrams are essential for understanding the static structure of our project, visually representing classes, relationships, attributes, and methods. Serving as a communication tool, they foster team collaboration and maintain consistency between design and implementation. These diagrams provide a robust foundation for development, aiding code reference, promoting reuse, and facilitating static analysis, contributing to efficient system maintenance and reducing errors.

The creation and population of the database are fundamental steps in ensuring the functionality of our project. We have added fictitious data, however for your use we leave it to you to enter the values ​​linked to your activity. The following outlines the process using the codes you've developed and shared on our GitHub project:

1. Database Creation Script The initial step involves executing the database creation script available in the GitHub repository.

2. Data Population Script Once the database structure is in place, the data population script is executed. This script inserts sample data or necessary initial records into the tables, allowing for testing and functionality validation.

3. Database Population Test After running the data population script, it's crucial to perform a thorough test to ensure that the database is correctly populated. This involves executing predefined queries to retrieve and verify the inserted data. You have the different requests separated by categories

• Create an employee
• Modify an employee (in progress)
• Display an employee
• Delete an employee

• Create a client
• Modify a client
• Display a client
• Delete a client

• Create an order
• Modify an order
• Display an order
• Delete an order

• Create an article
• Modify an article
• Display an article
• Delete an article

• Calculate the average basket value
• Calculate the turnover for a specific month
• Identify products below the restocking threshold
• Calculate the total amount of purchases for a client
• Identify the top 10 best-selling items
• Identify the top 10 least-selling items
• Calculate the commercial value of the inventory
• Calculate the purchase value of the inventory
• Simulate variations in commercial values to deduce the inventory value

• Robin NOIRET - Robin GitHub
• Peïo PICABEA - Peïo GitHub
• Abdelmalik MEBARKI - Abdelmalik GitHub
• Axel RUFFIN - Axel GitHub