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

Console

Code editor

Result

TableConsole