hi i need help with an sql assignment for creating data for 2020 presidential election.

this is the information needed:

• Create some tables to implement State, Electoral Colleges, Number of Votes for each of the presidential candidates and winner according with the latest news. Implement a database to solve the following questions: (You may use substitution variables) • How many electoral colleges offer state X? • Who won State X? • How many votes candidate X won in state Y? • Total votes for candidate X. • Total electoral colleges for candidate X. Assume two candidates. Trump and Biden. Requirements: • Include an ER diagram. • Include in your report the SQL query that solve the previous questions. • Include a picture of your outputs. • In general, the final report follows the format used in previous reports. • You may use any database system available to you: APEX account, Oracle Live, Postgress, etc. • Normalize as much as practical your tables. • Along with your LAB report submit your votes.sql script used to create the tables.

pur-new-sol

Related Questions