clothing ensemble generator anne taylor website nikki demoville & marie haddox ls 560 spring...
TRANSCRIPT
Clothing Ensemble GeneratorAnne Taylor
WebsiteNikki DeMoville & Marie Haddox
LS 560 Spring 2014
Our IdeaThe Anne Taylor website has lots of great clothing, but it can be hard to tell which clothing coordinates with other choices.
We propose to add a feature that allows a site visitor to use an outfit generator that will form a coordinated ensemble with any given shirt on the website.
The Plan Construct a demonstration prototype
Leverage site’s existing color choices
Site already assigns basic color names to all items
“Faint Maple” and “Coral Essence” both considered “Pink”
Implement for shirts only
Limit list of clothing choices
Generate clothing ensemble choices that go with the selected shirt
Create tables in Excel and import into Access
So work could be fairly divided when only one group member has Access
Tables – Clothing Color
Each color has a unique listing in the Colors table
Each color is assigned to one or more colors in the GoesWith table
Tables – Clothing Choices Each table can be queried for a simple list (e.g. all the Pink
Shirts or Black Pants)
Can also query for all outfits that go with certain shirts (e.g. All Shirts or Pink Shirts)
Relationships
Query 1a: All the pink or blue skirts
Constructing queries using SQL—making sure we understand the process
SELECT *FROM skirtsWHERE color='Pink'OR color='Blue';
Query 1b: All the pink or blue shirts under $100SELECT *FROM skirtsWHERE (color='Pink'OR color='Blue')AND price <100;
Query 2: All the outfits that go with the pink shirt
Design View
Allows choice of color for the
demo query
Allows choice of color for the
demo query
Calculates total cost of each ensembleCalculates total cost of each ensemble
Query 2: All the outfits that go with the pink shirt
SQL and ResultsSELECT Shirts.Name, Shirts.Price, Jackets.Name, Jackets.Price, Pants.Name, Pants.Price, Skirts.Name, Skirts.Price, [Shirts].[Price]+[Jackets].[Price]+[Pants].[Price]+[Skirts].[Price] AS Total
FROM Shirts INNER JOIN (Colors INNER JOIN (((GoesWith INNER JOIN Jackets ON GoesWith.[goes with] = Jackets.Color) INNER JOIN Pants ON GoesWith.[goes with] = Pants.Color) INNER JOIN Skirts ON GoesWith.[goes with] = Skirts.Color) ON Colors.[color name] = GoesWith.[color name]) ON Shirts.Color = Colors.[color name]
WHERE (((Colors.[color name])=[Shirt color?]));
Query 3: Simple report –which goes with which
Design View
Query 3: Simple report –which goes with which
SQL and Results
SELECT Shirts.Name, Shirts.Price, Jackets.Name, Jackets.Price, Pants.Name, Pants.Price, Skirts.Name, Skirts.Price, [Shirts].[Price]+[Jackets].[Price]+[Pants].[Price]+[Skirts].[Price] AS Total
FROM Shirts INNER JOIN (Colors INNER JOIN (((GoesWith INNER JOIN Jackets ON GoesWith.[goes with] = Jackets.Color) INNER JOIN Pants ON GoesWith.[goes with] = Pants.Color) INNER JOIN Skirts ON GoesWith.[goes with] = Skirts.Color) ON Colors.[color name] = GoesWith.[color name]) ON Shirts.Color = Colors.[color name];
Continues (long list)
Mock-Up Design: Page Placement
GENERATE OUTFIT
Mock-Up Design: Outfit Generator
Mock-Up Design: Outfit Generator
Thank you!Questions?
Marie HaddoxNikki DeMoville