"An instance of an entity is associated with zero or several instances of another entity." (Owen Williams, "MCSE TestPrep: SQL Server 6.5 Design and Implementation", 1998)
"A relationship between two tables in which a single row in the first table can be related to one or more rows in the second table, but a row in the second table can be related only to one row in the first table. A typical one-to-many relationship is between the publishers table and the titles table in the pubs sample database, in which each publisher can be related to several titles, but each title can be related to only one publisher." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)
"A logical data relationship in which the value of one data element can exist in combination with many values of another data element, but not vice versa." (Ralph Kimball & Margy Ross, "The Data Warehouse Toolkit" 2nd Ed., 2002)
"A relationship type between tables where one row in a given table is related to many other rows in a child table. The reverse condition, however, is not true. A given row in a child table is related to only one row in the parent table." (Bob Bryla, "Oracle Database Foundations", 2004)
"These relationships exist when a single instance of an entity (the parent entity) relates to many instances of another entity (the child entity). One-to-many relationships are the most common relationships in the real world." (Thomas Moore, "EXAM CRAM™ 2: Designing and Implementing Databases with SQL Server 2000 Enterprise Edition", 2005)
"The relationship between two tables dictated by having one record in one table, and many related records in another table." (Gavin Powell, "Beginning Database Design", 2006)
"The use of one key value from a dimension table in many rows of a fact table." (Reed Jacobsen & Stacia Misner, "Microsoft SQL Server 2005 Analysis Services Step by Step", 2006)
"A relationship between two tables in which a single row in the first table can be related to one or more rows in the second table, but a row in the second table can be related only to one row in the first table." (S. Sumathi & S. Esakkirajan, "Fundamentals of Relational Database Management Systems", 2007)
"Used in a relational database to denote that a single row in the parent table can be related to one or more rows in the related child table but that a row in the child table can be related to only a single row in the referenced parent table." (Marilyn Miller-White et al, "MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance 70-444", 2007)
"A relationship where one object of one type may correspond to many objects of another type. For example, one INSTRUCTOR may teach many COURSEs but each COURSE has only one INSTRUCTOR." (Rod Stephens, "Beginning Database Design Solutions", 2008)
"One of three types of relationships (associations among two or more entities) that are used by data models. In a 1:M relationship, one entity instance is associated with many instances of the related entity." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management" 9th Ed., 2011)
"A link between two entities in which the cardinality of one side of the relationship is one and the other is multiple." (Craig S Mullins, "Database Administration", 2012)
"A relationship in which the connected field is unique in one table and not unique in the other table." (Faithe Wempen, "Computing Fundamentals: Introduction to Computers", 2015)
"A relationship between two entities in a database such that one instance of an entity can be related to many instances of a second entity and the second entity can be related to only one instance of the first." (Jan L Harrington, "Relational Database Design and Implementation" 3rd Ed., 2009)
No comments:
Post a Comment