70 likes | 303 Views
P02. CS4221 Project. Relational Normalization CASE Tool for Database Schema Design. A0074001B Anthony Choo Kah Weng A0073998E Cheung Yew Kong Benjamin A0074064J Luk Ming Kit A0071031B Quek Pei Xian Samantha. Table of Contents. What our project is about Features Limitations Live Demo
E N D
P02 CS4221 Project Relational Normalization CASE Tool for Database Schema Design A0074001BAnthony Choo Kah Weng A0073998ECheung Yew Kong Benjamin A0074064JLuk Ming Kit A0071031BQuek Pei Xian Samantha
Table of Contents • What our project is about • Features • Limitations • Live Demo • Q&A
What our project is about A CASE-Tool that: • detects which normal form the input relations are in • synthesizes 3NF relations with an enhanced Bernstein Algorithm • states whether resulting relations are lossless
Features • Creation of Relation, Attribute, FDs. • Detection of NF • Suggestion for conversion to 3NF • Detect Losslessness/Dependency Preserving • Find Superfluous Attributes • Find BCNF
Limitations • Might not give the best solution (due to redundant covering found) • Cannot do MVD • Only up to BCNF