create some tables, implement constraints, create queries, create views, use group, and single row functions and in general practice with the knowledge you gain from this class.
computer science
Description
create some tables, implement constraints, create queries, create views, use group, and single row functions and in general practice with the knowledge you gain from this class. Elements for your final exam: Presidential Elections USA 2020.
• 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.
