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

please answer this question thank you so much uwu
please answer this question thank you so much uwu Consider the academic

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!