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))