The assignment content includes the creation of three tables: Artist, Art, and Location. The tables have various columns such as Name, Val, Sizes, Genre, Date_created, Artist_Id, Location_Id, Start_Date, End_date, Section, Locations. The content also includes several SQL queries such as SELECT statements to retrieve data from each table, SQL joins to combine data from multiple tables, and WHERE clauses to filter data based on specific conditions.