Write a sql query that lists the names of the top 3

Assignment Help Computer Engineering

Reference no: EM132153496

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 < ID#, name, date of birth, etc. > 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.

Reference no: EM132153496

Questions Cloud

What are the extreme limits of memory address somewhere : What are the extreme limits of memory address "somewhere" that the program may reach?

Maissahger brewery produces beer using water from river : Two kilometers downstream from the paper mill, Maissahger Brewery produces beer using water from the river.

Maissahger profit-social and maissahger profit-private : Riditna Paper withdraws river water for use in its paper mill, and returns it, along with waste effluent, back into the river.

Store random strings of lowercase letters in a table : Write a C++ hash function that could be used to store random strings of lowercase letters in a table of size 150.

Write a sql query that lists the names of the top 3 : Draw the schema for this election database below: clearly show table names, column names, PK and FK (linking between the tables).

How much faster is the pipelined machine : How much faster is the pipelined machine over the non-pipelined machine assuming no branches are taken?

Supply curves in the healthcare insurance market : Please explain your answer briefly in the language of economics by stating the shift(s) of demand and/or supply curves in the healthcare insurance market.

Supply curves in the gas market : Please explain your answer in the language of economics by stating the possible shift(s) of demand and/or supply curves in the gas market.

Determine which algorithm runs faster : Determine which algorithm runs faster. Show your work; you will need to compute a maximum common point after which one algorithm is better.

User Account

All Pages