Grade: TBD
This project involves designing and implementing a database system to manage a franchise of clothing stores, covering logistics, store management, and customer interaction.
create1.sql: Initial database creation.create2.sql: Final database version after utilizing AI (ChatGPT).populate1.sql: Initial database population.populate2.sql: Final population script after incorporating AI feedback.
This project encourages the use of AI tools to improve the quality of work and documentation, aligning with modern development practices.
- Manages multiple stores within the franchise.
- Tracks store layouts, employees, articles, stock, suppliers, and customer purchases.
- Supports detailed record-keeping and efficient management.
For a comprehensive description of the database design and functionality, refer to the full documentation here.
- Stores: Identification, location, layout, and staff.
- Employees: Roles, schedules, and salaries, with store managers identified.
- Purchases: Time, date, total value, and customer details.
- Articles: Names, colors, sizes, prices, and seasonal collections.
- Stock: Managed per store, replenished by suppliers with detailed records.
Explore the complete details in the docs/README.md file!