Cosmetics Database Project

Table of Contents

• Introduction
• Technologies
• Features
• Getting Started
• Usage
• Contributing
• License

Introduction

This project is a cosmetics database management system developed as part of the DBTheoryProject. It allows you to manage customers, orders, products, invoices, and more in a cosmetics retail setting. This README provides an overview of the project, its features, and how to get started.

Technologies

• C# and .NET Framework for the desktop application.
• SQL Server for the database management system.
• WinForms for the user interface.

Features

• Manage customer information, including registration and login.
• Create and manage orders, order details, and invoices.
• Maintain product information and categories.
• Handle cart functionality for online shopping.
• Manage shipments and reviews.
• Audit tables to keep track of changes.

Getting Started

1. Clone the repository to your local machine:

   git clone https://github.com/javeria2108/Database_Management_System_MakeupShop
   

Development Environment

• Open the project in your preferred development environment (e.g., Visual Studio).

Database Setup

1. Ensure you have SQL Server installed.
2. Create a new database (e.g., "CosmeticsDatabaseProject").
3. Execute the SQL scripts in the SQLQueries directory to create the necessary tables.

Connection String Update

• Open the project's code and locate the connection string in the form files (e.g., CustomersForm.cs, OrdersForm.cs, etc.).
• Replace the connection string details with your own SQL Server credentials.

Build and Run

• Build and run the project.

Usage

• Open the GUI in Visual Studio.
• Register as a new customer or log in with existing credentials.
• Use the different forms to manage customer data, orders, products, invoices, etc.
• View, edit, or delete records as needed.
• Utilize the audit functionality to keep track of changes made to tables.

Contributing

Contributions are welcome! If you'd like to contribute to this project, please follow these steps:

1. Fork the repository.
2. Create a new branch for your feature or bug fix.
3. Make your changes and commit them.
4. Push your changes to your fork.
5. Create a pull request to merge your changes into the main repository.

Fork the repository. Create a new branch for your feature or bug fix. Make your changes and commit them. Push your changes to your fork. Create a pull request to merge your changes into the main repository.