-- Polls
create table dbo.Polls
(
	PollID uniqueidentifier not null
		constraint PK_Poll primary key clustered,
	CreatedAt datetime null,	
	IsActive bit null,	
	Question nvarchar(200) null,
	UpdatedAt datetime null
)

-- Options
create table dbo.Options
(
	OptionID uniqueidentifier not null
		constraint PK_Poll primary key clustered,
	PollID uniqueidentifier not null,		
	CreatedAt datetime null,	
	IsActive bit null,	
	Answer nvarchar(200) null,
	UpdatedAt datetime null,
		constraint FK_Options_Pools
			foreign key(PollID)
			references dbo.Polls(PollID)
			on delete cascade,	
)

create table dbo.Votes
(
	VoteID uniqueidentifier not null
		constraint PK_Poll primary key clustered,
	OptionID uniqueidentifier not null,
		constraint FK_Votes_Options
			foreign key(OptionID)
			references dbo.Options(OptionID)
			on delete cascade,	
)

quote:

---

Originally posted by shapper

But do I need to related it to Polls?

Options is already related to Polls so if I relate a vote to an option why should I related all to Polls?

Anyway, this is what I am thinking:

create table dbo.Votes
(
	VoteID uniqueidentifier not null
		constraint PK_Poll primary key clustered,
	OptionID uniqueidentifier not null,
		constraint FK_Votes_Options
			foreign key(OptionID)
			references dbo.Options(OptionID)
			on delete cascade,	
)

Am I wrong? This way to get votes I would count the records in this table related to each option in Options only for a given PollID.

---