E N D
DB Mod Group P05: Tang Zhonghua Dai Yuan Hunar Khanna Tan Tze Chong
Outline • Introduction • Normal form decomposition • ER-Diagram
Introduction • Problem Statement • Current database designing software are quite complicated to database rookies • Our solution (DB Mod) • A web-based application to help its users planning and design database schema • 2 ways to design • Normal Form Decomposition • ER Diagram
Normal Form decomposition • Input of attribute in relation • Input of FDs and MVDs • FDs • MVDs
Normal Form decomposition (cont.) • Algorithm behind • Normal Form Checker • 2nf; 3nf; 4nf; bcnf • Decomposition • bernstein • BCNF
ER diagram • Sidebar • Addition entities • Adding Relationships • Adding attributes • Verify Diagrams • Screen Capture
ER diagram (cont) • Canvas • Adding link between components • Attribute to Regular Entity/Relationship • Regular Entity to Regular Relationship • IS-A / EX / ID Relationships • OP Relationships • Decomposition Relationships
ER diagram (cont) • Smart Context Menu • Empty space • Entities/Relationships • Attributes • Future Improvement