Go to Content
Columbia College Chicago
IAM Wiki: DD Final
DD Final

Cheese Browser by Region

Create an aspx page tha displays all the cheeses in the Cheese Database on iamdb

The aspx page should be able to filter the displayed cheese by Region. All of the cheeses from the selected region should be displayed. The cheese in the selected region should display there name, the name of their region, milk type and consistency. These properties should be strings not numbers so you'll need to use the view Cheese_vw or craft the joins yourself.

Keep you code clean and remember to comment

Extra Credit add the flags of the regions flags. images are here http://iam.colum.edu/dd/RegionIcons/ 
Extra Credit 2 Change the appearance of the selected region.

Post the url to your cheese browser to oasis when you are finished

Used Automobiles

Please normalize this data to at least 3NF (third normal form).

You can either

  • build an MSSQL Diagram and turn in the name of the diagram
  • Use a diagram tool like dia
  • Draw a diagram on papaer or drawing program and post on you website (please scan the paper drawing)

Remeber to use

  • Primary Keys
  • Mark proper datatypes
  • Show relationships
Make Model Year Category Color Doors Miles Condition
Ford Country Squire 1992 Wagon Blue 5 78,000 Good
Honda Civic LX 1991 Sedan Green 4 121,000 Fair
GMC 1500 1998 Pickup Red 3 92,000 Poor
BMW M3 2006 Coupe 2D Black 2 12,000 Excellent

Post the url or the name of your diagram to oasis when you are finished

This page was last modified on 5 August 2008, at 18:37. This page has been accessed 1,282 times. About IAMMediaWiki Powered by MediaWiki