Question

Define a table with the following properties representing a voter voting in an election.

Create a unique id for the table

Foreign key pointing to the voter table.

Foreign key pointing to the election table.

Create a field or fields representing the time and date of the voter's vote.

Answer 1

Below is the DDL statement for voter table

1.Table Name :voting

create table voting(
votingID int primary key,
VoterID int,
electionID int,
votingDateTime datetime,
foreign key (VoterID) references Voter(VoterID),
foreign key (electionID) references election(electionID));

• Here VoterID is primary key in the Voter table which acts as foreign key in the voting table
• electionID is primary key in the election table which acts as foreign key in the voting table