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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!