-- Insert into ComicPublisher
-- All Values 
insert into ComicPublisher values ('Marvel Entertainment Inc.','417 5th Avenue','','New York','NY','10016')

insert into ComicPublisher values ('DC Comics','1700 Broadway','7th Floor','New York','NY','10019')

-- Don't insert Address2
insert into ComicPublisher (Name, Address1, City, State, Zipcode) 
 values ('Dark Horse Comics', '10956 SE Main Street', 'Milwaukie', 'OR', '97222')

 --Insert into ComicCharacters
 insert into ComicCharacters values ('Clark','Kent','Superman','Fly', NULL, 'Good')

 insert into ComicCharacters values ('Bruce','Wayne','Batman','Strong', NULL, 'Good')

 insert into ComicCharacters values ('Lex','Luther','Lex','Diabolical',NULL,'Evil')

 --Delete from ComicCharacters and Redo
 delete from ComicCharacters

 --Insert into ComicCharacters
 insert into ComicCharacters values (2, 'Clark','Kent','Superman','Fly', NULL, 'Good')

 insert into ComicCharacters values (2, 'Bruce','Wayne','Batman','Strong', NULL, 'Good')

 insert into ComicCharacters values (2, 'Lex','Luther','Lex','Diabolical',NULL,'Evil')

 --Insert into UserInformation
 insert into UserInformation (FirstName, LastName, Age, Gender, Address1, City, State, UserName)
  values ('Kimberly', 'Garnto', 30, 'F', '123 Main Street', 'Orlando', 'FL', 'ComicQueen')

 -- Insert into ComicInformation
 insert into ComicInformation (Title, Author, PublicationDate, Condition, Description, 
								PublisherID, ComicPrice, CCharacterID)
 values ('Superman', 'Ray Scope', '01/01/1994', 'Excellent', 'Superman with Girl of Steel',
         2, '5.95', 1)
                               

