ToolSphere
All tools

DBMS Lab

Database course tools. Type the relation and its functional dependencies to get attribute closures, every candidate key and the prime attributes, or translate a SQL query into relational algebra.

1. Functional dependencies, keys and normal forms

Compute attribute closures, find every candidate key, test 2NF/3NF/BCNF, and synthesize or decompose relations.

2. Relational algebra

Translate SQL queries into relational algebra expressions and read them operator by operator.

Other labs

Frequently asked questions

How do I find candidate keys?

Enter the attributes and functional dependencies in the candidate key finder. It computes closures of attribute sets and lists every minimal set whose closure is the whole relation.

What does the closure tool give me?

The closure of the attribute set you choose under your functional dependencies, so you can check whether it is a superkey. The worked guide shows the closure steps by hand.