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
Need help with the following. See attachment for Database details.
Â
Need this info by end of day 2/3/17.
Â
Â
Artwork Table
Field Data Type Key Constraint ART_ID INT PK Auto Increment, Not Null Name VARCHAR(50) Not Null Date Created Date/Time Not Null Artist Table
Field Data Type Key Constraint ARTIST_ID INT PK Auto Increment ,Not null ART_ID INT FK Not null Name VARCHAR(50) Not null Address VARCHAR(250) Null Telephone VARCHAR(12) Not null Location Table
Field Data Type Key Constraint ID INT PK Auto Increment, Not null Location VARCHAR(100) not null Start Date Date/Time not null End Date Date/Time not null ART_ID INT FK 1 not null ERD Diagram 2
-----------