Authors: Peretz Shoval
Tags: 1991, conceptual modeling
The types of dependencies between objects in some reality determine to a large extent the structure of its database schema. While 1:n (or n:l) and m:n dependencies received extensive treatment in various models and methods for database design, 1:l dependencies received arbitrary treatment only. We focus on the 1:l dependency type and show its significance in database design. Various situations involving 1:l dependencies are analyzed and classified, and proper treatment of the dependency in those situations is suggested. These dependencies are treated at both the conceptual and the logical design levels. Decision rules are provided for the conversion of 1:l dependencies into 1:n or n:l dependencies. These are implemented within the system ADDS for automated database design.Read the full paper here: https://ieeexplore.ieee.org/stamp/stamp.jsp?tp=&arnumber=91053
