
CREATE TABLE artwork (
	"Artwork_ID" INTEGER, 
	"Type" TEXT, 
	"Name" TEXT, 
	PRIMARY KEY ("Artwork_ID")
)


CREATE TABLE festival_detail (
	"Festival_ID" INTEGER, 
	"Festival_Name" TEXT, 
	"Chair_Name" TEXT, 
	"Location" TEXT, 
	"Year" INTEGER, 
	"Num_of_Audience" INTEGER, 
	PRIMARY KEY ("Festival_ID")
)


CREATE TABLE nomination (
	"Artwork_ID" INTEGER, 
	"Festival_ID" INTEGER, 
	"Result" TEXT, 
	PRIMARY KEY ("Artwork_ID", "Festival_ID"), 
	FOREIGN KEY("Festival_ID") REFERENCES festival_detail ("Festival_ID"), 
	FOREIGN KEY("Artwork_ID") REFERENCES artwork ("Artwork_ID")
)

CREATE TABLE artwork (
	"Artwork_ID" INTEGER, 
	"Type" TEXT, 
	"Name" TEXT, 
	PRIMARY KEY ("Artwork_ID")
)

/*
2 rows from artwork table:
Artwork_ID	Type	Name
1	Program Music/Variety Show	Indonesian Idol
2	Program Music/Variety Show	I Know
*/


CREATE TABLE festival_detail (
	"Festival_ID" INTEGER, 
	"Festival_Name" TEXT, 
	"Chair_Name" TEXT, 
	"Location" TEXT, 
	"Year" INTEGER, 
	"Num_of_Audience" INTEGER, 
	PRIMARY KEY ("Festival_ID")
)

/*
2 rows from festival_detail table:
Festival_ID	Festival_Name	Chair_Name	Location	Year	Num_of_Audience
1	Panasonic Awards	Raymond Floyd	United States	2006	152
2	Flower Awards	Charles Coody	United States	2007	155
*/


CREATE TABLE nomination (
	"Artwork_ID" INTEGER, 
	"Festival_ID" INTEGER, 
	"Result" TEXT, 
	PRIMARY KEY ("Artwork_ID", "Festival_ID"), 
	FOREIGN KEY("Festival_ID") REFERENCES festival_detail ("Festival_ID"), 
	FOREIGN KEY("Artwork_ID") REFERENCES artwork ("Artwork_ID")
)

/*
2 rows from nomination table:
Artwork_ID	Festival_ID	Result
1	2	Nominated
2	2	Won
*/
List the name of artworks whose type is not "Program Talent Show".
SELECT Name FROM artwork WHERE TYPE != "Program Talent Show"
[{'Name': 'Indonesian Idol'}, {'Name': 'I Know'}, {'Name': 'Loving you'}, {'Name': 'Why'}, {'Name': 'Boys'}, {'Name': 'Daniel Mananta'}, {'Name': 'Back Home'}]