Skip to content

SQL | Fashion Relational Database Management System - MySQL - Fashion Wardobe Organizational System | Fashion Technology

Notifications You must be signed in to change notification settings

La-Nique/Closet_System

Repository files navigation

Lanique's Closet System

Developed by Lanique Lynn Peterson
IBM Cloud sponsored by Power Systems Academic Initiative; CSCI 435

Database Management Project Deliverable Problem Statement:
Lanique's Closet System

View Presentation / Project Demo

System Description:

We all struggle to find the best outfit to wear to events. We forget the clothes in our closets when we shop for new pieces. We even forget which garments look best with others.

Lanique's Closet System is a closet management system for young adults that eliminates decision fatigue. This database system will organize garments within your closet.

For Lanique's Closet System, the user will manually enter images of their clothing and its description into our system. Our system will then organize the data based on the type of garment, its color, season, and event. Each garment will have a mapping to other items within their closet that work well with that piece based on user input.

Our service will automate different clothing choices based on the user’s daily events and weather conditions with the support of external data collection via weather.com and from their digital calendars such as Google Calendar.

[teaser photo of project demo] project data collection prior to SQL entry:

Lanique_Peterson_DBM

Requirements:

  • A user must have clothing and must have:
    • Username
    • Clothing
    • Camera
    • Computer or Phone (to access system)
  • A database of garment information navigated by:
    • Garment Type:
      • T-Shirts + Tanks, Blouses, Jeans, Pants, Shorts, Skirts, Activewear, Hoodies, Jackets + Coats, Loungewear, Sweaters + Pullovers, Cardigans + Blazers, Skirts, or Dresses.
    • Color:
      • Black, Blue, Brown (tan + neutral colors), Clear, Green, Gray, Multi-colored, Navy, Orange, Pink, Purple, Red, White, or Yellow.
    • Season:
      • Warm, Cool, or Both.
    • Event:
      • School, Work, Date Night, Wedding, Professional Networking Event, Indoor Party, Outdoor Party, Gym, WFH, Concert, or Casual Day Out.

List of Services Provided:

  • Automated Outfit Choices
    • The system will show the user a list of potential outfit pairings from previous outfits.
  • Garment Mapping
    • Based on the user's input, the system will record a list of garments that pair well with others.
  • Personalized Guidance
    • Will signal users to find or shop for garments that pair well with others.

Users & Information:

  • User – Lanique's Closet System provides an efficient and time-effective way to coordinate outfits for any event.
  • Database:
    • Name, type of garment, color, season, and event type.
  • Provide:
    • Images, garment descriptions, and "outfit of the day" logs.
  • Receive:
    • List of recommended outfits and notification that a garment needs matching.
all rights reserved by Lanique Lynn Peterson
Final Class Grade: A

About

SQL | Fashion Relational Database Management System - MySQL - Fashion Wardobe Organizational System | Fashion Technology

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published