Question

DRAW EER Diagram
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]

Answer 1

Answer:

sorry bad at drawing

Explanation: