Question: please answer this question thank you so much uwu Consider the academic board of a university. In an academic board, there will be elected representatives
Consider the academic board of a university. In an academic board, there will be elected representatives from each faculty. During the board meeting, the representatives propose an agenda, and all the board members vote on it. Depending on the vote, the agenda is put forward for execution. University is planning to create a database to track votes taken in the academic board meetings. - It should record each faculty (for instance, Engineering) with its name and number of representatives. - Each representative is identified by their name which might not be unique, the school (denoted by school name) they belong to and the year when they were first elected in the academic board. You may assume that there will be at most one representative from each school. - The database should track each agenda (legislation) with its unique title, description, the date on which its vote was taken, the outcome of the vote meaning whether the agenda passed or failed (so the domain is yes and no), and its initiators (the representatives who proposed the agenda). - It should track how each representative woted on each agenda (yes, no, absent). Your task is to design an entity-relationship (E-R) schema diagram for the above enterprise. State clearly any assumptions that you make. Also state any business ruleslogic to which the database should adhere-that are not captured in your E-R diagram
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
