For a data model to be valid, the data structure must reflect that model. You would run
Fantastic news! We've Found the answer you've been seeking!
Question:
For a data model to be valid, the data structure must reflect that model. You would run a series of scripts to confirm the entities seen in the data have the same maximum cardinalities as specified in your diagram.
SELECT parent_identifying_attribute, COUNT(DISTINCT child_identifying_attribute) ChildCount FROM import_table GROUP BY parent_identifying_attribute HAVING COUNT(DISTINCT child_identifying_attribute) > 1; Rows returned means PARENT - 1:N - CHILDREN No rows returned means PARENT - 1:1 - CHILD NOTE: If the parent or child identifying attribute is FirstName & LastName, use EmployeeName or CustomerName accordingly. To confirm the PURCHASE entity only use PurchaseDate as your identifying attribute. For SKILL use only SkillName. |
Related Book For
An Introduction To Statistical Methods And Data Analysis
ISBN: 9781305465527
7th Edition
Authors: R. Lyman Ott, Micheal T. Longnecker
Posted Date: