The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 103 Weeks Ago, 3 Days Ago |
| Questions Answered: | 4870 |
| Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
1. Create a new table named Publisher. Publisher contains the following attributes:
|
PUBLISHER_CODE, Character, 2 spaces wide, primary key |
|
PUBLISHER_NAME, Character 20 spaces wide |
|
PUBLISHER_CITY, Character, 20 spaces wide |
|
PUBLISHER_STATE, Character, 2 spaces wide  |
2. Add the following values to the Publisher table you just created:
|
AH, Arkham House Publ., Sauk City, WI |
|
AP, Arcade Publishing, New York, NY |
|
AW, Addison Wesley, Reading, MA |
|
BB, Bantam Books, New York, NY |
|
BF, Best and Furrow, Boston, MA |
|
JT, Jeremhy P. Tarcher, Los Angeles, CA |
|
MP, McPherson and Co., Kingston, NY |
|
PB, Pocket Books, New York, NY |
|
RH, Random House, New York, NY |
|
RZ, Rizzoli, New York, NY |
|
SB, Schoken Books, New York, NY |
|
SI, Signet, New York, NY |
|
TH, Thames and Hudson, New York, NY |
|
WN, W.W. Norton and Co., New York, NY |
Note: the values listed above are all listed by PUBLISHER_CODE, PUBLISHER_NAME, PUBLISHER_CITY, and PUBLISHER_STATE order.
-----------