Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started