{
"name":"Canvas",
"description":"A data base to answer all of your questions about art.",
"tables":[
{
"name":"work",
"description":"Data about a spesific work of art.",
"feilds":[
{
"name":"work_id",
"description":"The unique identifier for the work table.",
"type":"VARCHAR"
},
{
"name":"name",
"description":"The name of the work as designated by the artist.",
"type":"VARCHAR"
},
{
"name":"artist_id",
"description":"A foreign key that references the artist table to indicate which artist created the work.",
"type":"VARCHAR"
},
{
"name":"style",
"description":"The artistic style of the work such as as Impressionist, cubist, etc.",
"type":"VARCHAR"
},
{
"name":"museum_id",
"description":"A foreign key that references the museum table to indicate where the work is currently housed.",
"type":"VARCHAR"
}
]
},
{
"name":"museum_hours",
"description":"Data about a spesific work of art.",
"feilds":[
{
"name":"museum_id",
"description": "A primary key that references the museum table to indicate where the work is currently housed.",
"type":"VARCHAR"
},
{
"name":"day",
"description":"The day of the week, also a primary key.",
"type":"VARCHAR"
},
{
"name":"open",
"description":"Time of day the museusm opens",
"type":"VARCHAR"
},
{
"name":"close",
"description":"Time of day the museusm closes",
"type":"VARCHAR"
}
]
},
{
"name":"artist",
"description":"Data about a spesific work of art.",
"feilds":[
{
"name":"artist_id",
"description":"A primary key that references the artist table to indicate which artist created the work.",
"type":"NUMBER"
},
{
"name":"full_name",
"description":"The full name of the artist.",
"type":"VARCHAR"
},
{
"name":"first_name",
"description":"The first name of the artist.",
"type":"VARCHAR"
},
{
"name":"middle_names",
"description":"The middle names of the artist, seperated by spaces.",
"type":"VARCHAR"
},
{
"name":"last_name",
"description":"The last name of the artist.",
"type":"VARCHAR"
},
{
"name":"nationality",
"description":"Where the artist came from.",
"type":"VARCHAR"
},
{
"name":"stayle",
"description":"The style of art the artist is known for.",
"type":"VARCHAR"
},
{
"name":"birth",
"description":"The year the artist was born",
"type":"NUMBER"
},
{
"name":"death",
"description":"The year the artist died",
"type":"NUMBER"
}
]
},
{
"name":"subject",
"description":"Contains the subject of each work of art",
"feilds":[
{
"name":"work_id",
"description":"The unique identifier for the work table.",
"type":"VARCHAR"
},
{
"name":"subject",
"description":"The subject.",
"type":"VARCHAR"
}
]
}
]
}