Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Experts Guide To Database 2

Authors: Bruce L. Larson

1st Edition

0070232679, 978-0070232679

More Books

Students also viewed these Databases questions