- All Journals
- Al-Qadisiyah University
- Basrah University
- Kirkuk University
- Mosul University
- The Iraqi Borad for Medical Specialization
- University of Anbar
- University of Technology
- Al Mustafa University
- Al-Zahraa University for Women
- Alnoor University
- Kunooz University
- Misan University
- Ninevah University
- Tikrit University
- University of Al-Hamdaniya
- University of Kerbala
Automatic Determining Of Candidate Keys Sets Depending On Functional Dependency | ||
| Al-Rafidain University College For Sciences | ||
| Article 1, Volume 0, Issue 25, 2017, Pages 183-202 | ||
| Author | ||
| Nada Adnan | ||
| Abstract | ||
| This paper presents a step in automatic database design, re-engineering and schema modification, design weak points detection, and normalization. This step represents determining the candidate keys of the tables automatically via proposing and implementing an algorithm which depends on the functional dependency and attribute set closure. Also, some techniques of Apriori algorithm of association rule mining are used to generate keys and minimize the keys space. The implementation is done by using Oracle PL/SQL to utilize the facilities provided by ORACLE DBMS and to give the features of embedded system to the proposed one. | ||
| Keywords | ||
| Automatic Determining | ||
|
Statistics Article View: 133 PDF Download: 68 |
||