1 / 7

CS4221 Project

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

ulla
Download Presentation

CS4221 Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. Table of Contents • What our project is about • Features • Limitations • Live Demo • Q&A

  3. 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

  4. Features • Creation of Relation, Attribute, FDs. • Detection of NF • Suggestion for conversion to 3NF • Detect Losslessness/Dependency Preserving • Find Superfluous Attributes • Find BCNF

  5. Limitations • Might not give the best solution (due to redundant covering found) • Cannot do MVD • Only up to BCNF

  6. Live Demo

  7. Q & A

More Related