Is there a specific term to describe a relation with a cardinality of one?
I'm thinking particularly of RDBMS "special" one-row tables, for example, DUAL
(Oracle), SYSIBM.SYSDUMMY1
(DB2, Derby) and RDB$DATABASE
(Interbase, Firebird).
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityIs there a specific term to describe a relation with a cardinality of one?
I'm thinking particularly of RDBMS "special" one-row tables, for example, DUAL
(Oracle), SYSIBM.SYSDUMMY1
(DB2, Derby) and RDB$DATABASE
(Interbase, Firebird).
Singleton Table. In relational terms it is a relation with primary key ∅ (the empty set).