About This Project

This project aims to build a relational database design tool (Product name: OneSchema) which helps users who are designing database to come out with a good database design which has few or no update anomalies. It offers a way for the users to input the set of attributes and functional dependencies, from which, the user is able to verify whether the generated relation is in normal form. If it is not, then the tool will be able to further decompose the generated relation into specified normal forms (3NF or BCNF). In addition, OneSchema can generate a SQL script which contains all table definitions (i.e. the generated relations) that can be piped to common DBMS.

Our target users will be the teaching staff and students of CS2102 and it can be used for teaching and learning purposes.

OneSchema Features

• Check whether the tables in a database are in 2NF, 3NF or BCNF.
• Decompose into BCNF or 3NF.
• Showing intermediate decomposition steps and results.
• Allow user to customize the decomposition steps.
• Generate SQL Schema (The format is based on MySQL and Oracle)

Coming Soon

The user guide for OneSchema should be available soon.

We are looking for an icon for OneSchema also. If you would like to design one for us, please contact us. Thanks!