Rainbow Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Dictionary database
5. Get to know the dictionary table
Summary

Instruction

Okay, let's try another table, shall we?

In the next couple of exercises, we'll work with words in a dictionary. Do you know that linguists classify words?

Our table contains some English words and their hypernyms.

A hypernym is a term with a broad meaning, that "contains" other terms. For example, the hypernym of "sparrow" is "bird".

Exercise

Select all data from the dictionary table. It contains the following columns:

  • entry_id - the ID of an entry in the dictionary,
  • word - the word associated with a particular entry,
  • hypernym_id - the ID of an entry that is a hypernym for a particular word.

Stuck? Here's a hint!

Type:

SELECT
  *
FROM dictionary