A methodology and tool for top-down relational database design

0
121

Authors: Naphtali Rishe

Tags: 1993, conceptual modeling

This paper presents a methodology for logical design of relational schemas and integrity constraints using semantic binary schemas. This is a top-down methodology. In this methodology, a conceptual description of an enterprise is designed using a semantic binary model. Then, this description is converted into the relational database design. The paper also describes a tool which automates all the busy work of the methodology and provides graphic output. With respect to the intelligent design decisions, the tool accepts instructions from its user, who is a database designer, or, when the user defaults, makes decisions itself based on “rule-of-thumb’ principles.

Read the full paper here: https://pdf.sciencedirectassets.com/271546/1-s2.0-S0169023X00X01000/1-s2.0-0169023X9390032K/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEMv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMSJHMEUCIBA6xKSJQcm0B93A1Vhb62mnXeK8GiweRKnMDNgUc2uLAiEAyicA3joD%2BQ%2BphSZV81%2BRUuDamxwWwamy3DnMFFpPEJAqvQMI9P%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARADGgwwNTkwMDM1NDY4NjUiDLPlIvgnhABEtn%2BR%2FiqRA7z01FRUw%2BzMqqLeT4S9cGQyPX2gbuQX7BCDMYbQOYBbnyiaF%2F18eX%2Fef6atVwndCfkDu%2Ft2%2FYTcyYdgOn9MKSoovma6wKbdxXqv0zakwyCLF51BTT4hm5hlgGFlfyRvfGLcChwilaz41w39ad%2FpiWgzm63SXUAEAPaCWfKxyuHB7zndD2IFUVBz2PmH8pEcG7LWtXQlphHlJMDsCTUZM7qzSKt%2Bp8uYK4ogv4DaIAqs2T4vWUhNQubOyvP%2Bc22DFicbfB0g6ZGIt1%2BMSdGW8UfEqFArWcMde68eew3RK0WshsPXE3WYKfExnDO2Z6qo1KeTJtTz3QBXBgqL0RjqjYuNqKelkrFoRKB13xOEfjmFu3I4D3%2FhiBnoo1xzSCcHKBk2Q1fwYfwI12yLJu8b2HFrVguZyqrA9ijWYIsu2rTG3p2s%2FXHpEGSFmAp%2BQUgmB4Ud1PWqvvgcRHROT6um2hb8BAcBC%2BQNJfuHc6tEHYoJBDardLxYxfns2uCAMgxNV42ErA2IKQamkI6gN1QJI5t7MNfw8vsFOusB51UWt%2B3CZoWJWvPzp73egsAqYnEj0iVNLDprMwBarSFpIYlZt%2F2s9%2BVF6DUzvdxtWpoCPbFABjnLBF3hQ52%2Bi0gP6behoupbS7fRfeWPO2420akCcmIzuN0PvV6z21CplJz4Pnptjkis%2BTbUKojUxuG9xOkdolrpGG0ie1Mw219bETszInjHZLgD0N2VwqPMBImEnY1KUKCBMjQAUjvHNw7s25qQplz8cPQezahrL6WdPhVqc1WTn6KDb6KKyqZj%2B9jX7oc845729WVPeOGVKvnT1wgLRTzQ5%2FF554EEs3psIvNH0eWUj6FBjQ%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20201006T191924Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTYSU6LDHUX%2F20201006%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=fde295806bc02700da12b7bca4addd6e0657b3dcdc97cde779502a36cd4df616&hash=c1a33943b32f0242263574f69fa4f5137ebaf883d949437f3f2d62b39be5ee64&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=0169023X9390032K&tid=spdf-4dea9b35-308c-469c-8940-5a781c297b36&sid=486d779f37b05542706a4e676167ccab2c3agxrqa&type=client