Question : Draw the EER diagram that describes the following scenario: ( PLEASE EXPLAIN STEP BY STEP AND IN DETAIL) We want to design a database for keeping track of information about votes taken is the PAKISTAN PROVISIONS in the current administration. They include the PARLIAMENT and the SENATE. A MINISTER in the PAKISTAN is either a Parliament Member or a Senator depending on to which body they are elected to. The database needs to keep track of each PAKISTAN CITY’s Name (e.g., ‘Lahore’, ‘Karachi’, ‘Multan’) and include the Region of the country to which the city belongs (whose domain is {‘Punjab’, ‘Sind’, ‘KPK’, ‘Baluchistan’}) and its population in the 170 million. Each MINISTER is described by his or her Name, plus the District represented, the Start_date when the parliament was first elected, and the political Party to which he or she belongs (whose domain is {‘PPP’, ‘PTI’, ‘PML(N)’, ‘PML(Q)’, ‘ANP’, ‘MQM’, ‘Independent’, ‘Other’}). A city can have a number of parliament member, but only two senators. The database keeps track of each bill (i.e., proposed law), including the Bill_name, the Date_of_vote on the bill, whether the bill Passed_or_failed (whose domain is {‘Yes’, ‘No’}). A Bill may be sponsored by any number of MINISTERS including Parliamentarian and Senators. During the voting, a device is used to record the vote secretly. The database keeps track of how each parliamentary voted on each bill (domain of Vote attribute is {‘Yes’, ‘No’, ‘Abstain’, ‘Absent’}). [A BILL passed in the Assembly goes later to the Senate – but this is not represented in our database] Question : Draw the EER diagram that describes the following scenario:We want to design a database for keeping track of information about votes taken is thePAKISTAN PROVISIONS in the current administration. They include the PARLIAMENT andthe SENATE. A MINISTER in the PAKISTAN is either a Parliament Member or a Senatordepending on to which body they are elected to. The database needs to keep track of eachPAKISTAN CITY's Name (e.g., 'Lahore', 'Karachi', 'Multan') and include the Region of thecountry to which the city belongs (whose domain is {'Punjab', 'Sind', 'KPK', Baluchistan'})and its population in the 170 million. Each MINISTER is described by his or her Name, plus theDistrict represented, the Start date when the parliament was first elected, and the political Partyto which he or she belongs (whose domain is {'PPP', 'PTI', 'PML(N)', 'PML(Q)', 'ANP’,'MQM', 'Independent', 'Other'}). A city can have a number of parliament member, but only twosenators. The database keeps track of each BILL (i.e., proposed law), including the Bill name,the Date of vote on the bill, whether the bill Passed or failed (whose domain is {'Yes', No'}).A Bill may be sponsored by any number of MINISTERS including Parliamentarian andSenators. During the voting, a device is used to record the vote secretly. The database keepstrack of how each parliamentary voted on each bill (domain of Vote attribute is {'Yes', 'No','Abstain', 'Absent'}). [A BILL passed in the Assembly goes later to the Senate – but this is notrepresented in our database]

Question

Question : Draw the EER diagram that describes the following scenario:     ( PLEASE EXPLAIN STEP BY STEP AND IN DETAIL) We want to design a database for keeping track of information about votes taken is the PAKISTAN PROVISIONS in the current administration. They include the PARLIAMENT and the SENATE. A MINISTER in the PAKISTAN is either a Parliament Member or a Senator depending on to which body they are elected to. The database needs to keep track of each PAKISTAN CITY’s Name (e.g., ‘Lahore’, ‘Karachi’, ‘Multan’) and include the Region of the country to which the city belongs (whose domain is {‘Punjab’, ‘Sind’, ‘KPK’, ‘Baluchistan’}) and its population in the 170 million. Each MINISTER is described by his or her Name, plus the District represented, the Start_date when the parliament was first elected, and the political Party to which he or she belongs (whose domain is {‘PPP’, ‘PTI’, ‘PML(N)’, ‘PML(Q)’, ‘ANP’, ‘MQM’, ‘Independent’, ‘Other’}). A city can have a number of parliament member, but only two senators. The database keeps track of each bill (i.e., proposed law), including the Bill_name, the Date_of_vote on the bill, whether the bill Passed_or_failed (whose domain is {‘Yes’, ‘No’}). A Bill may be sponsored by any number of MINISTERS including Parliamentarian and Senators. During the voting, a device is used to record the vote secretly. The database keeps track of how each parliamentary voted on each bill (domain of Vote attribute is {‘Yes’, ‘No’, ‘Abstain’, ‘Absent’}). [A BILL passed in the Assembly goes later to the Senate – but this is not represented in our database] Question : Draw the EER diagram that describes the following scenario:We want to design a database for keeping track of information about votes taken is thePAKISTAN PROVISIONS in the current administration. They include the PARLIAMENT andthe SENATE. A MINISTER in the PAKISTAN is either a Parliament Member or a Senatordepending on to which body they are elected to. The database needs to keep track of eachPAKISTAN CITY's Name (e.g., 'Lahore', 'Karachi', 'Multan') and include the Region of thecountry to which the city belongs (whose domain is {'Punjab', 'Sind', 'KPK', Baluchistan'})and its population in the 170 million. Each MINISTER is described by his or her Name, plus theDistrict represented, the Start date when the parliament was first elected, and the political Partyto which he or she belongs (whose domain is {'PPP', 'PTI', 'PML(N)', 'PML(Q)', 'ANP’,'MQM', 'Independent', 'Other'}). A city can have a number of parliament member, but only twosenators. The database keeps track of each BILL (i.e., proposed law), including the Bill name,the Date of vote on the bill, whether the bill Passed or failed (whose domain is {'Yes', No'}).A Bill may be sponsored by any number of MINISTERS including Parliamentarian andSenators. During the voting, a device is used to record the vote secretly. The database keepstrack of how each parliamentary voted on each bill (domain of Vote attribute is {'Yes', 'No','Abstain', 'Absent'}). [A BILL passed in the Assembly goes later to the Senate – but this is notrepresented in our database]

Accepted Answer

1-

2-

3- 
ER(Entity Relational), displaying the connection among one entity to any other entity,…