MYSQL

WordNet (cardinality)

general

synset having N words (1..28)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(wordid) AS N FROM synsets LEFT JOIN senses USING(synsetid) GROUP BY synsetid) AS C

MIN(N)	MAX(N)
1	28

word having N synset (1..75)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(synsetid) AS N FROM words LEFT JOIN senses USING(wordid) GROUP BY wordid) AS C

MIN(N)	MAX(N)
1	75

morphology

morph having N words (1..3)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(wordid) AS N FROM morphs LEFT JOIN lexes_morphs USING(morphid) GROUP BY morphid) AS C

MIN(N)	MAX(N)
1	3

word having N morphs (0..7)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(morphid) AS N FROM words LEFT JOIN lexes_morphs USING(wordid) GROUP BY wordid) AS C

MIN(N)	MAX(N)
0	7

verb frames

sense having N vframes (0..8)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(frameid) AS N FROM senses LEFT JOIN senses_vframes USING(wordid,synsetid) GROUP BY synsetid,wordid) AS C

MIN(N)	MAX(N)
0	8

vframe having N senses (1..801)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(CONCAT(wordid,synsetid)) AS N FROM vframes LEFT JOIN senses_vframes USING(frameid) GROUP BY frameid) AS C

MIN(N)	MAX(N)
1	13233

verbframe sentences

sense having N vtemplates (0..8)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(templateid) AS N FROM senses LEFT JOIN senses_vtemplates USING(wordid,synsetid) GROUP BY synsetid,wordid) AS C

MIN(N)	MAX(N)
0	4

vtemplates having N senses (1..801)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(CONCAT(wordid,synsetid)) AS N FROM vtemplates LEFT JOIN senses_vtemplates USING(templateid) GROUP BY templateid) AS C

MIN(N)	MAX(N)
0	295