文章基本信息

标题：Derivation of Database Keys’ Operations
本地全文：下载
作者：Adio Taofiki Akinwale ; Olusegun Folorunso ; Adesina S. Sodiya 等
期刊名称：Issues in Informing Science and Information Technology
印刷版ISSN：1547-5840
电子版ISSN：1547-5867
出版年度：2011
卷号：8
出版社：Informing Science Institute
摘要：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
关键词：database anomalies, inconsistency, database keys, functional dependencies, relational schemas, Armstrong’s inference rules, prime and non-prime attributes, normal forms