Advanced Relational Database /* Assignment 1 Frog Database */ 1/24/11

use master;  
 Go  
 Create database Frogs  
 use Frogs  
 create table NDFrogs  
      (  
      ID Int Primary Key identity (1,1)  
      , Scientific_Name varchar(50)  
      , IUCN_Red_List_Status varchar(30)  
      , Vernacular_Name varchar (30)  
      , Family varchar (30)  
      )  
 insert into NDFrogs  
 (Scientific_Name, IUCN_Red_List_Status, Vernacular_Name, Family)  
 values  
 ('Bufo americanus', 'Least Concern (LC)', 'American Toad', 'Bufonidae')  
 insert into NDFrogs  
 (Scientific_Name, IUCN_Red_List_Status, Vernacular_Name, Family)  
 values  
 ('Bufo cognatus', 'Least Concern (LC)', 'Great Plains Toad', 'Bufonidae')  
 insert into NDFrogs  
 (Scientific_Name, IUCN_Red_List_Status, Vernacular_Name, Family)  
 values  
 ('Bufo hemiophrys', 'Least Concern (LC)', 'Canadian Toad', 'Bufonidae')  
 insert into NDFrogs  
 (Scientific_Name, IUCN_Red_List_Status, Vernacular_Name, Family)  
 values  
 ('Bufo woodhousii', 'Least Concern (LC)', 'Woodhouse''s Toad', 'Bufonidae')  
 insert into NDFrogs  
 (Scientific_Name, IUCN_Red_List_Status, Vernacular_Name, Family)  
 values  
 ('Hyla versicolor', 'Least Concern (LC)', 'Eastern Gray Treefrom', 'Hylidae')  
 insert into NDFrogs  
 (Scientific_Name, IUCN_Red_List_Status, Vernacular_Name, Family)  
 values  
 ('Pseudacris maculata', 'Least Concern (LC)', 'Boreal Chorus Frog', 'Hylidae')  
 select * from NDFrogs