This DB will also be used in week 5 as the target for other SQL questions. We will refer to this table in other contexts as well, so, loading the data will be a one-time task ( except for later edits !! :-) )

Ch4Ch5VeggieDatabaseA6.1DBGarden.doc

Assignment  A6.1DBGarden for 2016

This DB will also be used in week 5 as the target  for other SQL questions.   We will refer to  this table in other contexts as well, so, loading the data will be a one-time task ( except for later edits !! 🙂 )

For this assigment, A6.1DBGarden,  I will ask you to build  and query it using the built in NB tools.

Assignment details:

Build a database , the table below, and send in a screen shot of the create,  insert code, and a

query that prints out the name, variety, season, and daysToHarvest, sorted by name,

embedded within a work document.

In your table creation code, include checks on season, daysToHarvest, and watering

Scenario: You are a consultant to home gardeners who ask you to advise them as to what to grow and when to plant.You will show them a database that consists of the following sketches for tables that  you will make available for their particular situation( to be revised as needed)

The vegetable name will be something like Peas, and the variety will be something like Wando. 

plantingSeason, specific  to the Tucson/Phoenix  area, is an enumeration  {spring, summer, fall, winter}

veggieID :    Int   // the key for this table

daysToHarvest : Int     Check < 80 ( a required check in the table)

watering : Decimal(4,2) is the estimated total water needed for a unit of planting area, Check < 100.00 

All entries in the table are required, no nulls allowed. 

Database : MyGarden   // use whatever name you wish

Table 1.  VeggiePropertiesRR( veggieID, veggieName, variety, plantingSeason, daysToHarvest, watering)

Use the data supplied in the table below 

VeggiePropertiesRR

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"