tag:blogger.com,1999:blog-19888049.post9222709333871669950..comments2023-10-02T14:54:11.063+01:00Comments on Ian A. Macey Photography: M359: Block 3 Ex 5.13 - Flawed?Ian M.http://www.blogger.com/profile/00662874467585962278noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-19888049.post-33434598299777132162007-07-11T15:38:00.000+01:002007-07-11T15:38:00.000+01:00Yes I agree. The problem is that the course text ...Yes I agree. The problem is that the course text did not make this to clear in block 3 when it talked about constraints.Ian M.https://www.blogger.com/profile/00662874467585962278noreply@blogger.comtag:blogger.com,1999:blog-19888049.post-23786050886764061892007-07-11T10:40:00.000+01:002007-07-11T10:40:00.000+01:00But a constraint should apply to all the data in t...But a constraint should apply to all the data in the database, not just data added after the constraint has been imposed.<BR/><BR/>If there is existing data that violates the constraint that is about to be added then the constraint is meaningless until that data is made to comply with the constraint (or the original intent of the constraint is flawed). <BR/><BR/>Only after the data already in the table is made to satisfy the constraint should the constraint be added.Anonymousnoreply@blogger.com