Presenting...............a Bracelet Database?

I was looking for a way to showcase my skills using SQL Server, SSMS and Telerik Report Designer. As luck would have it, I was also starting to make and sell leather and gemstone beaded bracelets. I created this database to keep track of supplies and costs as well as a crosstab report to track bracelet inventory.

Database and SQL Queries

Here is my Bracelet Database Diagram with Foreign Key Relationships.

Click image below to see fullsize

Here are the Create Table Scripts edited for readability.

To create a Telerik Report, you must decide what parameters (if any) the user will need to select.

For this to report, the user can search by Bead (Gemstone), Bracelet Size, Button (I have a variety of fun buttons used for clasps) and Status (Available/Sold).

Here are the Parameter Queries that were used to populate the picklists as well as the main query that produces the report.

Telerik interface and report design

Click image below to see fullsize

Picklists populated with information

Select Gemstone/Bead(s)

Select Size(s)

Select Button(s)

Select Status

Report examples with real data

Searching for available bracelets with either aquamarine, aventurine, lepidolite or onyx, all button options, sizes 7.00, 7.25, 7.50, 7.75.

Searching for sold bracelets with aquamarine, aventurine, lepidolite or onyx, all button options, sizes 7.00, 7.25, 7.50, 7.75.

Here is a general inventory report showing available bracelets with 10 of the gemstone/bead(s), all button options and all sizes. (2 images)

Click below images to see fullsize