• I have attempted to add a row with 0,1, True and False in the DuesColumn but receive error prompts. Here is my code:

    CREATE Table Groups

    (GroupID INT Identity Primary Key,

    GroupName Varchar NOT NUll,

    Dues money Default 0 CHECK (Dues >= 0))

    CREATE Table Individuals

    (IndividualID INT Identity Primary Key,

    FirstName Varchar NOT NUll,

    LastName Varchar NOT NUll,

    Address Varchar NOT NUll,

    Phone Varchar) --Null allowed since the user may not have a phone

    CREATE Table GroupMembership

    (GroupID INT Identity REFERENCES dbo.Groups (GroupID),

    IndividualID INT NOT NUll REFERENCES dbo.Individuals (IndividualID))

    CREATE CLUSTERED INDEX IX_GroupID

    ON GroupMembership (GroupID)

    CREATE INDEX IX_IndividuaLID

    ON GroupMembership (IndividualID)

    ALTER TABLE Individuals

    ADD DuesPaid bit NOT NULL DEFAULT ((0))