Loading...
Please wait, while we are loading the content...
Similar Documents
FD-EXPLORER: A Pedagogical and Design Tool for Functional Dependency Exploration
| Content Provider | Semantic Scholar |
|---|---|
| Author | Scher, Julian Qiu, Canghui |
| Copyright Year | 2004 |
| Abstract | Functional dependencies are merely a type of relationship between attributes in a relation, or, alternatively, may be viewed as constraints on attributes, but their importance in the optimal design of databases is enormous. Normalization of a database, and the decomposition of relations, are totally dependent upon the database designer being able to identify functional dependencies, and manipulate them. Curricula in CS, IS and IT will almost always include a course in database design, with functional dependencies being a key topic in such a course. FD-Explorer is a new tool we have developed which enables both the student of database design, as well as professional database developers, to define a known set of functional dependencies on a relation, deduce new sets of functional dependencies, compute closures of individual attributes and the set of functional dependencies, and identify superkeys. This software tool, which we ultimately intend to make freely available for students in database design classes in institutions of higher learning, will provide the user with significant insight into the underlying explicit and implicit relationships between attributes, contribute to the optimal design of database structures in applications, and enhance the user’s understanding of the fundamental principles of functional dependencies. |
| File Format | PDF HTM / HTML |
| Alternate Webpage(s) | https://isedj.org/4/7/ISEDJ.4(7).Scher.pdf |
| Language | English |
| Access Restriction | Open |
| Content Type | Text |
| Resource Type | Article |
