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.