Skip to content

Latest commit

 

History

History
48 lines (31 loc) · 1.59 KB

README.md

File metadata and controls

48 lines (31 loc) · 1.59 KB

🛠️ Project: Databases Class @ FEUP

Grade: TBD

📖 Overview

This project involves designing and implementing a database system to manage a franchise of clothing stores, covering logistics, store management, and customer interaction.

🗂️ Project Structure

  • 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.

🧠 Learning Focus

This project encourages the use of AI tools to improve the quality of work and documentation, aligning with modern development practices.

🏢 Database Summary

  • Manages multiple stores within the franchise.
  • Tracks store layouts, employees, articles, stock, suppliers, and customer purchases.
  • Supports detailed record-keeping and efficient management.

📂 Documentation

For a comprehensive description of the database design and functionality, refer to the full documentation here.

🔗 Description Highlights

  • 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!