Clothing Ensemble Generator Anne Taylor Website

1. Clothing Ensemble GeneratorAnne Taylor Website Nikki DeMoville & Marie Haddox LS 560 Spring 2014

2. Our Idea ? The 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. ? ?

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

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

5. 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)

7. Relationships

8. Query 1a: All the pink or blue skirts Constructing queries using SQL—making sure we understand the process SELECT * FROM skirts WHERE color='Pink' OR color='Blue';

9. Query 1b: All the pink or blue shirts under $100 SELECT * FROM skirts WHERE (color='Pink' OR color='Blue') AND price <100;

10. Query 2: All the outfits that go with the pink shirt Design View Allows choice of color for the demo query Calculates total cost of each ensemble

11. Query 2: All the outfits that go with the pink shirt 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] WHERE (((Colors.[color name])=[Shirt color?]));

12. Query 3: Simple report –which goes with which Design View

13. 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)

14. Mock-Up Design: Page Placement GENERATE OUTFIT

15. Mock-Up Design: Outfit Generator

16. Mock-Up Design: Outfit Generator

17. Thank you! Questions? Marie Haddox Nikki DeMoville