DMCA
Derivation of Database Keys ’ Operations
BibTeX
@MISC{Akinwale_derivationof,
author = {Adio Akinwale and Olusegun Folorunso and Adesina Sodiya},
title = {Derivation of Database Keys ’ Operations},
year = {}
}
Share
 |
 |
 |
 |
||
OpenURL
Abstract
Designing normalized relation is subject of great difficult, yet great importance. The paper pre-sented automatic derivation of database keys as a step forward solution to designing normalized relations. It studied relational schema and functional dependencies to derive keys of primary, candidate, alternative and super key of relational database. The necessary algorithms to derive database keys were analyzed, modified and coded in Java Programming Language to display graphical key derivation input interface. The input interface accepts any length of schemas ’ at-tributes and functional dependencies to compute power set, closure, derived keys and specific group of keys which can aid database designers to control anomalies at initial stage of database design. The system also assists the students to find, “see”, and learn database keys derivation. The effectiveness has a positive impact on the students ’ performance on normalization technique.
Keyphrases
database key operation database key functional dependency normalized relation graphical key derivation input interface database key derivation relational schema super key schema at-tributes great importance database designer student performance relational database database design paper pre-sented automatic derivation necessary algorithm initial stage positive impact specific group input interface java programming language normalization technique
