Question: Turkey will run elections over the Internet starting by the year 2019. You are asked to design the DB for this online election system. This

Turkey will run elections over the Internet starting by the year 2019. You are asked to design the DB for this online election system. This DB logs all voting activity. There can be 20+ political parties with more than 2000+ candidates in 81 different cities. About 60 million registered citizens/voters with profile information such as will vote for parties. Note that the candidates are also citizens. a. Draw the schema for this election database below: clearly show table names, column names, PK and FK (linking between the tables). b. Using the schema you designed in part a) Write a SQL query that lists the names of the top 3 (most voted) parties after the election
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
