110 likes | 228 Views
A Little Database: LS 560 Assignment 3. Emily Bibb and Belinda Sawyer. A Little Bit Sheepish: a yarn shop in historic Berlin, MD. http:// www.alittlebitsheepish.com /. Newsletter Sign-up. Events Calendar. Online shopping. So, what does this site need?. Searchable Events Date Price
E N D
A Little Database: LS 560 Assignment 3 Emily Bibb and Belinda Sawyer
A Little Bit Sheepish: a yarn shop in historic Berlin, MD • http://www.alittlebitsheepish.com/
So, what does this site need? • Searchable Events • Date • Price • Searchable customer information • Amount spent
Online shopping, with returning customers functionality added
SQL • Query 1: To determine class size • SELECT "eventtitle", "instructor", "enrollment" FROM "events" WHERE "enrollment" <= 8 ORDER BY "eventtitle" • Query 2: To determine a customer’s spending • SELECT "purchaseID", "customer", "amountpaid", "date" FROM "purchases" WHERE "customer" = 1234 ORDER BY "date" ASC • Query 3: To find available classes within a certain price range • SELECT "eventtitle", "startdate", "crafttype", "cost" FROM "events" WHERE "cost" <= 40 ORDER BY "startdate" ASC
Sample Report: Classes where enrollment was equal to or less than 8 participants, ordered by Class Title.