Flags

Task

Let us create a database of all of the world's national flags. Flags must be stored with a picture and a short description, and they must be associated with their country. Of the countries you want to store name, extension, population and the continent where they belong.

Design an entity-relationship diagram, a relational schema and an instance of the database.

Create also the queries which will return:

1. a list of all the countries and of the file names of their flags;
2. a list of all countries ending with "a" and their extensions ordered by extension in decending order;
3. the names of all the continents in the DB;
4. a list of all the countries of the American continent and a list of the descriptions of their flags;
5. the ids of the countries which have less than a million inhabitants.